Hibernate Query setString method with Empty String

Asked Nov 08 '13 at 12:30

Active Nov 09 '13 at 04:48

Viewed 140 times

I'm using the method setString(String name, String val) from Query Class of Hibernate.

import org.hibernate.Query;

String q = "from Table n where n.field=:annee ";
Query query= session.createQuery(q);
query.setString("annee","");

I want to store an empty String and not a null, because this field can not be null in my database. But I get an error message saying that I cant insert a null value.

I don't understand what happens. Because an empty string is not null.

It is the Query method who converts the empty chain into a null, and then Oracle gives me the error?. Or its Oracle itself who converts an empty string into a null, and then it complains?

edited Nov 08 '13 at 12:42

asked Nov 08 '13 at 12:30

gcotis

3

In Oracle, an empty string is considered null. [Why does Oracle 9i treat an empty string as NULL?](http://stackoverflow.com/q/203493/1073063) – Pablo Nov 08 '13 at 12:35
1

Yeah, Oracle does this. – Roman C Nov 08 '13 at 12:36

Hibernate Query setString method with Empty String

0 Answers0