Re: Getting the User on a JDBC connection

Hi neill,

You're getting a ClassCastException because the native driver connection is a com.ibm.db2.jdbc.app.DB2Connection. Unfortunately, I couldn't quickly find javadocs for the native kit (and I have clients to help), so I don't know offhand if you'll still be able to get the ID.

The lack of a quick path to the javadocs is frustrating. If someone knows offhand, please post.


Joe Sam

Joe Sam Shirah - http://www.conceptgo.com
conceptGO - Consulting/Development/Outsourcing
Java Filter Forum: http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International? http://www.jguru.com/faq/I18N
Que Java400? http://www.jguru.com/faq/Java400

----- Original Message ----- From: <Neill.Harper@xxxxxxxx>
To: <java400-l@xxxxxxxxxxxx>
Sent: Thursday, November 13, 2008 1:32 PM
Subject: Getting the User on a JDBC connection

Hi

I have been using the following code to get the user on a JDBC connection.

((AS400JDBCConnection)connection).getSystem().getUserId();

this works fine using the remote driver: com.ibm.as400.access.AS400JDBCDriver

but when the code runs natively using the local driver:
com.ibm.db2.jdbc.app.DB2Driver

The code fails with a classcast exception.

Does anybody have any idea how I can establish the userid of a native jdbc sql connection?

Thanks neill
--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.