RE: AS400 Object from Container Managed JDBC

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-
bounces@xxxxxxxxxxxx] On Behalf Of James Perkins
Sent: Wednesday, April 28, 2010 11:31 AM
To: Java Programming on and around the iSeries / AS400
Subject: 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

--
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.