RE: AS400 Object from Container Managed JDBC

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

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-
bounces@xxxxxxxxxxxx] On Behalf Of James Perkins
Sent: Tuesday, April 27, 2010 4:59 PM
To: Java Programming on and around the iSeries / AS400
Subject: AS400 Object from Container Managed JDBC

I have a JDBC connection pool defined as a JDBC resource in a
WebSphere Application Server V7.0 environment. It uses the
com.ibm.as400.access.AS400JDBCConnectionPoolDataSource for the data
source connection pooling. This is all set-up via the WebSphere admin
console.

What I would like to do is retrieve the data source and cast it to a
AS400JDBCConnection so I can use the getSystem() method to retrieve
and AS400 object for PCML calls. I saw in the archives someone has
this working with GlassFish, so I'm wondering if someone has ever got
it working in WebSphere.

I did attempt to retrieve the data source via JNDI (and resource
injection) and cast it to an AS400JDBCConnection. That did not work as
it's returning a com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource object.
I've tried casting to a AS400JDBCDataSource and had no luck with that
either.

If anyone has any suggestions, let me know. I'd like to be able to
have 1 connection and authentication method if that's possible.

Thanks in advance,
--
James R. Perkins
--
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.