Getting the JDBC Connection Information

How do i get the JDBC Connection information.

Anuvasan,

You may also find the services in wm.art.admin.connection useful, such as getResourceStatistics, getResourceState, … .
Most of these service take the name of your JDBC Adapter connection as an input.

Regards,

Koen

Christian,

What packages do you need to import? Where is the JDBCConnPoolAdmin class located?

Mark

Hi Mark

All the classes you need are in the server.jar (which is in your classpath). You need to import the com.wm.app.b2b.server.* and com.wm.app.jdbc.*

Good luck, Chris

For those who dislike using wildcards on import statements, the fully qualified names of the classes that need to be imported are:

  • com.wm.app.b2b.server.JDBCConnectionManager [*]com.wm.app.jdbc.JDBCConnPoolAdmin

Mark

Mark, thanks for that. Sometimes I rush a little too much to present these things properly :wink:

Sorry for waking up this old thread, but could you elaborate a bit more (e.g. code snippet) on how to get a JDBC connection using those libraries, please?

Best regards,
Marcus

Hi Marcus,

Can you please explain what exact information you are trying to retrieve as there are many built-in service available now.

Thanks!
Baharul Islam

For listing JDBC adapter connection alias names only, use the pub.art.connection:listAdapterConnections service with input “JDBCAdapter” in WmART

2 Likes

@Mahesh and Baharul:
Many thanks for your feedback so far!
Regarding your question, I want connection handles from the connection manager for given JDBC connection names (as listed in the WmJDBCAdapter package) to query different databases in a Java service.

Best regards,
Marcus