Setting NULL value in UPDATE query of Native JPA in Spring data

Question

Whenever my primaryGrpId comes as null the following native query is failing with SQLGrammerException, because it is expecting NUMBER. Andy idea how to set NULL if parameter value is null with native query in JPA. The database is ORACLE.

@Modifying
@Query(nativeQuery = true, value = "update EVENT set PRIMARY_CATEGORY_ID=?2, PRIMARY_GROUPING_ID=?3 where PRIMARY_PERFORMER_ID=?1")
  void updatePrimaryCatGrpOfEntities(Long primaryPerfId, Long primaryCatId, Long primaryGrpId);

Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY

All my DAO methods are just declared, no implementation is provided to write something like "setParameter"....etc.

I would not like to write any implementation for DAO method updatePrimaryCatGrpOfEntities. I don't see any of these answers are providing a solid solution especially for update queries. — user1614862
– user1614862, Commented Aug 16, 2017 at 1:26
It seems to be not possible to deal with NULL values with native queries in JPA — user1614862
– user1614862, Commented Aug 16, 2017 at 19:22

NimChimpsky · Accepted Answer · 2017-08-15 23:58:47Z

-2

Check the column definition allows null.

answered Aug 15, 2017 at 23:58

NimChimpsky

47.5k61 gold badges202 silver badges319 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Setting NULL value in UPDATE query of Native JPA in Spring data

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related