With hsql, hibernate returns an empty string for null fields, and with oracle it returns null. What could I do to work the same way?

thanks
Emerson

Hibernate version: 3.1

Mapping documents:

<class name="com.yell2.core.enhancer.Component" table="component">
<id name="id" type="long">
<column name="id" not-null="false" />
<generator class="increment" />
</id>
<property name="createdDate" column="created_date" />
<property name="status" column="status" />
<property name="statusMsg" column="status_msg" />
<property name="type" column="type" />
<property name="updatedDate" column="updated_date" />
<property name="value" column="value" type="java.lang.String"
length="5000" />
...

Hi,

With hsql, hibernate returns an empty string for null fields, and with oracle it returns null

I think there is problem somewhere but not in the Hibernate.

Try to produce a query for INSERT with hibernate and dont set values to some attributes and check it Hibernate will not insert null in to the Database.

in oracle empty string and null are same - it is changed in newer versions, but many applications (maybe jdbc driver) suppose this