applying convert-null element to service generator

Example:
<?xml version="1.0"?>
<!DOCTYPE service-builder PUBLIC "-//Liferay//DTD Service Builder 6.0.0//EN" "http://www.liferay.com/dtd/liferay-service-builder_6_0_0.dtd">

<service-builder package-path="com.liferay.sampleservicebuilder">
<namespace>SSB</namespace>
<entity name="Foo" uuid="true" local-service="true" remote-service="true">

<!-- PK fields -->

<column name="fooId" type="long" primary="true" />

<!-- Group instance -->

<column name="groupId" type="long" />

<!-- Audit fields -->

<column name="companyId" type="long" />
<column name="userId" type="long" />
<column name="userName" type="String" />
<column name="createDate" type="Date" />
<column name="modifiedDate" type="Date" />

<!-- Other fields -->

<column name="field0" type="Integer" convert-null="false" />
<column name="field1" type="String" />
<column name="field2" type="boolean" />
<column name="field3" type="int" />
<column name="field4" type="Date" />
<column name="field5" type="String" />
<column name="field6" type="long" convert-null="false" />
<column name="field7" type="long" convert-null="true" />
<column name="field8" type="short" convert-null="false" />
<column name="field9" type="short" convert-null="true" />
<column name="fieldA" type="int" convert-null="false" />
<!-- Order -->

<order by="asc">
<order-column name="field1" />
</order>

<!-- Finder methods -->

<finder name="Field2" return-type="Collection">
<finder-column name="field2" />
</finder>

<!-- References -->

<reference package-path="com.liferay.portlet.asset" entity="AssetEntry" />
<reference package-path="com.liferay.portlet.asset" entity="AssetTag" />
</entity>
</service-builder>

Default values of "fieldA", "field8", "field6", and "field0" should be NULL instead of 0.

By the way, a fix patch will be provided here shortly.

Moved to community backlog: this feature is interesting and can be implemented by the community or Liferay as an extra functionallity.
Thanks for your feedback

fix patch based on revision 71297.

For more details, refer to blogs post https://www.liferay.com/web/jonas.yuan/blog/-/blogs/applying-convert-null-attribute-in-service-builder-to-persist-null-and-not-null-into-data-types-in-databases

Hi Jonas,
What's the status of this enhancement? I can see the DTD liferay-service-builder_6_0_0.xml has already added this attribute to the column element in the 6.0.6 CE source code. Has this patch already been committed to the 6.0.6 branch?

Regards,
Miles.

Hi Miles,

I did not think that the fix was applied to the 6.0.6 Branch. It should be available in the 6.1 CE GA.

Thanks

Jonas

Hi Miles,

I did not think that the fix was applied to the 6.0.6 Branch. It should be available in the 6.1 CE GA.

Thanks

Jonas

Hi everyone,

it would be great to have this realy cool feature integrated in the 6.1 CE GA.

Thanks
Robert

In preparation for Ideation; we are moving this contributed solution tickets to “Feature Request”. Additional information to follow.