We have created tables from the backend. Now form a portlet we want to query those tables wht are the different methods to query the tables,
One of them is to use service builder, but i think by using service builder again we need to create the tables, which is not the case as i have already created the tables and they contain data.

Please suggest some approach.

Hi usha kiran,

Liferay providing gr8 feature call Service Builder from this we can create tables and also create all service classess from that we can access data from tables.

http://www.liferay.com/community/wiki/-/wiki/Main/Service+Builder
http://www.javabeat.net/2011/06/using-liferays-service-builder-part-1/

Liferay IDE direct support to create servises using service builder.

Regards,
Meera Prince

HI
If you use service builder you need not to create tables manually.And for retrieving u can use dynamic query,finder method or custom sql
Regards azar