Accessing database from portlet

[usha kiran, geändert vor 11 Jahren.]

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.

[meera prince, geändert vor 11 Jahren.]

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

[mohammad azaruddin, geändert vor 11 Jahren.]

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