RE: How to get Job Number of a JDBC connection

[Ashish Kulkarni <kulkarni_ash1312@xxxxxxxxx>]

Hi Tim
I am using AS400JDBCConnectionPool,
here is the code i am using
AS400JDBCConnectionPoolDataSource dataSource = new
AS400JDBCConnectionPoolDataSource("myas400", "user",
"pass");
dataSource.setDateFormat("iso");
dataSource.setPrompt(false);
dataSource.setTimeFormat("hms");
dataSource.setNaming("system");
dataSource.setTranslateBinary (true);
AS400JDBCConnectionPool pool = new
AS400JDBCConnectionPool(dataSource);
pool.fill(1);
Connection conn = pool.getConnection();   
System.out.println (conn.getClass().getName());

which give me output as 
com.ibm.as400.access.AS400JDBCConnectionHandle

Ashish


--- Tim Kosacek <tkosacek@xxxxxxxxxxxxxx> wrote:
> Just a guess, but your connection pool is probably
> returning an instance
> of AS400JDBCPooledConnection instead of 
> AS400JDBCConnection (to be sure you can call
> getClass().getName() on
> that object and print it out).  If it is a
> AS400JDBCPooledConnection,
> just call getConnection() on that and cast that
> Connection object to an
> AS400JDBCConnection.  So something like:
> 
> AS400JDBCConnection =
>
(AS400JDBCConnection)((AS400JDBCPooledConnection)conn).getConnection();
> 
> Tim
> 
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
> Ashish Kulkarni
> Sent: Tuesday, March 25, 2003 2:22 PM
> To: Java Programming on and around the iSeries /
> AS400
> Subject: Re: How to get Job Number of a JDBC
> connection
> 
> 
> Hi,
> How do i cast it??
> AS400JDBCConnection conn1 =
> (AS400JDBCConnection)conn;
> gives ClassCastException , is there a way or code u
> know how to do it
> Ashish
> 
> --- David Gibbs <david@xxxxxxxxxxxx> wrote:
> > "Ashish Kulkarni" <kulkarni_ash1312@xxxxxxxxx>
> > wrote in message
> >
>
news:20030325175229.96860.qmail@xxxxxxxxxxxxxxxxxxxxxxxxxx
> > > Here is the code i am using to get the JDBC
> > connection
> > > to AS400, I want to get the job number of this
> > > connection, How do i get it??
> > 
> > Try the getServerJobIdentifier() method on the
> AS400JDBCConnection 
> > (you'll have to cast your connection object to the
> > appropriate class).
> > 
> > david
> > 
> > 
> > _______________________________________________
> > 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.
> > 
> 
> 
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Platinum - Watch CBS' NCAA March Madness,
> live on your desktop!
> http://platinum.yahoo.com
> _______________________________________________
> 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.
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com