Re: AS400 Object from Container Managed JDBC

Thanks Mark, you're actually the one that gave me the idea :-). My
only problem is I can't seem to unwrap my connection. I think this is
something specific to WebSphere though. I've seen complaints about not
being able to unwrap a WebSphere connection, but they are all old
posts on various sites. So either, I'm missing something easy or
people just don't use WebSphere anymore.

I am saving this code for future use though. I prefer PCML calls over
stored procedures. I don't like redefining all my parameters again to
create the stored procedure.
--
James R. Perkins



On Wed, Apr 28, 2010 at 08:47, Anderson, Mark
<Mark.Anderson@xxxxxxxxxxxxx> wrote:

Please read the disclaimer at the bottom of this e-mail.

Hi james,

I've done something similar using Glassfish, I assume you will need to do something similar by replacing the sun connection holder with your app servers default connection wrapper. here's my code, hope it helps :


import com.ibm.as400.access.AS400;
import com.ibm.as400.access.AS400JDBCConnection;
import com.sun.gjc.spi.base.ConnectionHolder;
import java.sql.Connection;
import java.sql.SQLException;

         // get a basic connection from the pool
         connection = DBManager.getDB2Connection(country);
         // get the connection holder
       ConnectionHolder sunConn = (ConnectionHolder) connection;
       AS400JDBCConnection conn = null;
       try {
               // extract the connection from the connection holder
           conn = (AS400JDBCConnection) sunConn.getMetaData().getConnection();
       } catch (SQLException ex) {
           Logger.getLogger(ApiCallBean.class.getName()).log(Level.SEVERE, null, ex);
       }

       as400 = conn.getSystem();



-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of James Perkins
Sent: 28 April 2010 16:37
To: Java Programming on and around the iSeries / AS400
Subject: Re: AS400 Object from Container Managed JDBC

I should have noted too, I'm using NetBeans in this case. It's a JSF/Facelets app and eclipse/RD(whatever you want to end it with) does not support facelets. More so, does not support auto-complete for Facelets. NetBeans does it very well, plus I like NetBeans maven support and native Mercurial support a little better :-)
--
James R. Perkins



On Wed, Apr 28, 2010 at 08:28, James Perkins <jrperkinsjr@xxxxxxxxx> wrote:

It's definitely a wrapper class. The interface is
com.ibm.websphere.rsadapter.WSDataSource, I found that by using the
java.sql.Wrapper.isWrappedFor() method.

There is a WSJdbcUtil class that has a getNativeConnection() method,
but it's deprecated in WAS 7. I also read that IBM suggests not to use
any of these classes as they are for IBM internal usage only.

I might just end up switching back to stored procedure calls. With
Java EE 5 I can get a java.sql.DataSource injected so there's no real
trouble getting an SQL connection.

Thanks for the tips!

--
James R. Perkins

Sounds like a Rational wrapper around the raw Connection object but I
could not locate the corresponding javadoc.

I would cast it to the WSJdbcDataSource class, and then investigate
the available methods on it with the usual Eclipse tools.  There
might be a "getWrappedConnection" method or similar.

--
  Thorbjørn Ravn Andersen  "...plus... Tubular Bells!"

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

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


*****************************************************

Confidentiality: -

This message and any attachments are strictly confidential and may contain legally privileged information.
The contents of the transmission are intended for the named addressee(s) only. If you are not the addressee please do not read, print, store or re-transmit it or any attachments to it. Instead, please email it back to the sender and then immediately permanently delete it from your system

The views or opinions presented here are solely of the author and do not necessarily represent those of Redcats (UK) PLC or any of its subsidiaries.

Redcats (UK) plc. Registered Office: 2 Holdsworth Street, Bradford, BD1 4AH. Registered in England, No. 106691
--
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.