Hitting the database in standard portlet

[Ishan Sahore, modificado hace 11 años.]

Hi all,

I want to know if we can access the MySQL database with code written in a standard portlet(made using eclipse) to make the portlet dynamic so that data is fetched from the database and displayed in the portlet.

Any help is appreciated.

Thanks,
Ishan

[Raja Nagendra Kumar, modificado hace 11 años.]

Portlet can use external database like any normal JSP pages..

However it is advised to use Liferay expando framework http://www.liferay.com/community/wiki/-/wiki/Main/Expando.

Regards,
Raja Nagendra Kumar,
C.T.O
www.tejasoft.com

[David H Nebinger, modificado hace 11 años.]

Raja Nagendra Kumar:

However it is advised to use Liferay expando framework http://www.liferay.com/community/wiki/-/wiki/Main/Expando.

What? That doesn't answer the OP's question...

Yes you can access data from the database. Always use Service Builder to access the database though, and never your own connection/sql.