Re: AS400 Object from Container Managed JDBC

[James Perkins <jrperkinsjr@xxxxxxxxx>]

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