Hello Everyone.

I've just upgraded to version 6.0.5
I'm using servisebuilder and I have a question

Previously, I was able to write entity (sample):

<entity name="EntityName" local-service="true" remote-service="false">
<column name="id" type="long" primary="true"/>
<column name="sample" type="Long"/> <<<<<<<<<<<<<<<<<<<<<<<<<<<<<Long type (allow null value, but not allowed in liferay)

<finder name="Sample" return-type="EntityName" unique="true"> <<<<<<<<<<Create uniq index in DB
<finder-column name="sample"/>
</ Finder>
</ Entity>

Please take into acccount that the column sample has Long type but not long. In 5.x liferay version I ws able to create entity withg field value == null. This way a was able to have it in unique index because many NULL is accepted in DB.
Now (v. 605), in * hbm.xml service builder specifies the type column:
<property name="sample" type="com.liferay.portal.dao.orm.hibernate.LongType" />

but converts all NULL to zeros ....

respectively, I receive an exception

Is there any way other than manually editing the file * hbm.xml allowing insertion of NULL value in DB

I think is bug

Hi,

I have the same problem, I need to keep the NULL values on numeric database columns, but all are converted to zero.

In many contexts is important to differentiate when a user leave a field blank (not required field) and when effectively introduced a zero value.

Any workaround suggested?

Hi,

Unfortunately, I also have the same problem.

Can someone help me?

Mariann

My recommendation would be to give up trying. I ran into way too many issues trying to use boxed primitives, and ended up changing the column type back to a primitive.

@Vetal, @Reinaldo, @Kőhegyi, @jelmer

A fix patch for 5.2, 6.0 and 6.1 is here.

Applying convert-null attribute in Service Builder to persist NULL and NOT NULL into data types in databases.

Related post: http://www.liferay.com/community/forums/-/message_boards/message/6811878

Do you want to test as morning birds?

Thanks

Jonas Yuan
==================
The Author of Liferay Books:
Liferay User Interface Development
Liferay Portal 6 Enterprise Intranets
Liferay Portal 5.2 Systems Development
Liferay Portal Enterprise Intranets