Getting the JDBC Connection Information

, ,
1

How do i get the JDBC Connection information.

2

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

3

Christian,

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

Mark

4

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

5

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

6

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

7

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

8

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

9

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

3 Likes
10

@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