Re: AS400 Object from Container Managed JDBC

Gary,
It does return a WsJdbcConnection(), I've tried casting that too with
no luck. I don't know where the library is for all the IBM JDBC stuff,
so I can' directly use the WsJdbcConnection(). I did just notice that
the getMetaData() method is available on the java.sql.DataSource, so
I'm going to try it from there to see what happens. Don't know I
missed that earlier :-)

Thanks for the information and clarity!
--
James R. Perkins



On Wed, Apr 28, 2010 at 11:00, Gary L Peskin <garyp@xxxxxxxxxxxx> wrote:

Hi, James --

I'm confused.  Have you tried calling getConnection() on your
WsJdbcDataSource object?  If so, what does that return?  If that returns a
WsJdbcConnection() object, try calling getMetaData() on that and then
getConnection() on that and see what you get back.

In other words something like:

WsJdbcDataSource myDataSource = ...;
AS400JDBCConnection conn = (AS400JDBCConnection)
myDataSource.getConnection().getMetaData().getConnection();
AS400 myAs400 = conn.getSystem();

Gary