Generic database connection & displaying within the portlet

[11年前 に Nikolas Quemtri によって更新されました。]

Hello!
The purpose is to display generic database tables (which structure is unknown in advance), so I probably can't use service builder and ORM for this.
How can I get DB connection properties (such as username, password) that are defined for the portal in general?

[11年前 に Eric Tse によって更新されました。]

Nikolas Quemtri:

Hello!
The purpose is to display generic database tables (which structure is unknown in advance), so I probably can't use service builder and ORM for this.
How can I get DB connection properties (such as username, password) that are defined for the portal in general?

Just for curiousity, why don't you define the connection properties in tomcat and connect liferay to the tomcat ?

[11年前 に David H Nebinger によって更新されました。]

Just call com.liferay.portal.kernel.util.InfrastructureUtil.getDataSource() to get Liferay's datasource.