Hibernate: Avoid binding null to parameter in @Embeddable attribute

Asked Jul 10 '12 at 08:23

Active Jul 10 '12 at 10:58

Viewed 379 times

Hibernate scenario:

@Embeddable
public class CompositeKey...{
  private String keyPart1;  
  private String keyPart2;
}

public class Entity{
  @Embedded
  private CompositeKey cKey;
  ...
}

Now when running this with a cKey with a value in only keyPart1 and keyPart2 == null I get a "binding null to parameter n" binding null to keyPart2.

Can I avoid that and have hibernate generate an SQL with only the parameters that actually has a value and omit the null ones?

So instead of

where keyPart1 = ? and keyPart2 = ?

I just want

where keyPart1 = ?

if cKey.keyPart2 == null

Thanks in advance...

./CJ

edited Jul 10 '12 at 10:58

starblue

55,348
14
97
151

asked Jul 10 '12 at 08:23

CJe

1,928
3
24
53

And what's the code triggering the query? – JB Nizet Jul 10 '12 at 08:26
Kind of a sideways comment, but does it make sense in your domain to use an empty string instead of a null marker? – Andrew Lazarus Jul 10 '12 at 22:51
Solved it by dynamically constructing a where clause. – CJe Jul 12 '12 at 09:23
No - using an empty string wouldn't help – CJe Jul 12 '12 at 09:24

Hibernate: Avoid binding null to parameter in @Embeddable attribute

0 Answers0