Obtain the ClientConnectionId?

[Mario Schwaiger]

After the upgrade to Tomcat 8 I read the documentation more carefully and found out about some interesting logging-options. Sometimes queries to a slow DB-Server fail and the logs state an interesting message:

20-Oct-2015 16:33:51.511 WARNING [Tomcat JDBC Pool Cleaner[16031516:1445351581508]] 
org.apache.tomcat.jdbc.pool.ConnectionPool.abandon Connection has been abandoned 
PooledConnection[ConnectionID:10 ClientConnectionId: 700076f3-dba5-4ccc-9efd-f228e644a59b]:java.lang.Exception
	at org.apache.tomcat.jdbc.pool.ConnectionPool.getThreadDump(ConnectionPool.java:1052)
	at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:768)
	at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:617)
	at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:186)
	at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
...

It's quite interesting to to see a ClientConnectionId. I tried to find some information about it and but most Forum-Entries were just related to Tomcat-Logs. Does any one have some information if and how there are possibilities to obtain this ID in Java?

Thank you

[Karthik Shiraly]

Not tried this, but if your database is SQL server, then it's probably obtainable by casting the Connection to SQLServerConnection, and calling this method.

Out of curiosity, how does the client connection ID help you?

[Karthik Shiraly]

I'll move this to the JDBC forum, since it's related to JDBC connections, not JSP.

[Mario Schwaiger]

and calling this method.

Seems to be interesting, yet due to the policies of Microsoft the implementation it's not so easy to actually use it.
I'm having a Maven-Project using Tomcat's data-source - so actually working with a SQLServerConnection-Object is tricky.

But I assume that's the only possible way. Many thanks for your research, I assume this problem is solved