AS400 Object from Container Managed JDBC -- JAVA400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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 mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.