Sunday, 18 December 2011

Build EXT Service with "id" column - [JDBCExceptionReporter:101] Unknown column 'xxxxxxx_.id_' in 'field list'

In Liferay5.2.3 when you are trying to build a sevice with Column name "id" not
a Id,ID or etc other than "id".

for Example a table- ExampleTable has field


id long not null,
name varchar(30),
emailAddress varchar(30),

After Creating Table when you creat a Ext Service and trying to call LocalSrviceUtil ,Liferay-Hibernate  gives error like,

 [JDBCExceptionReporter:101] Unknown column 'ExampleTable0_.id_' in 'field list'


..Liferay portal doesnot support for "id" name column.

To remove these type of error,


Just rename the table field "id" to "id_" you doesn't have to rebuild Service.







 

No comments:

Post a Comment

Infinidb _CpNoTf_ problem

infinidb table with a varchar column insert string as a '_CpNoTf_' while using Cpimport. The Problem is occured if inserted string ...