Re: dataSource.getConnection jt400

[Patrick L Archibald <Patrick.Archibald@xxxxxxxxxxxxx>]

Here is my work around. I created a class called ToolboxDataSource that 
extends the AS400JDBCConnectionPool.

package com.hometelco.intranet;
import java.sql.*;
import com.ibm.as400.access.*;
/**
* @author     Patrick L Archibald
* @created    July 29, 2003
*/
public class ToolboxDataSource extends AS400JDBCConnectionPoolDataSource {
 AS400JDBCConnectionPool pool = null;
 private String system;
 private String user;
 private String password;
 public ToolboxDataSource(String system, String user, String password) {
   super(system, user, password);
   this.system = system;
   this.user = user;
   this.password = password;
 }
 public Connection getConnection() throws SQLException {
   Connection connection = null;
   if (pool == null) {
     System.out.println("Get pool. Date: " + new java.util.Date());
     AS400JDBCConnectionPoolDataSource test = new 
AS400JDBCConnectionPoolDataSource(system, user, password);
     pool = new AS400JDBCConnectionPool(test);
     try {
       pool.fill(5);
     }
     catch (ConnectionPoolException e) {
       System.out.println("ConnectionPoolException");
     }
   }
   try {
     connection = pool.getConnection();
   }
   catch (ConnectionPoolException e) {
     System.out.println("ConnectionPoolException");
   }
   return connection;
 }
}


Thanx, PLA

Patrick L Archibald wrote:

> Hey Joe Sam
>
> There lies the problem. I don't want to get the connection from an 
> AS400JDBCConnectionPool. I want to get the connection from the 
> DataSource so I can use the dataSource.getConnection() method in all 
> of my beans  whether it is on the 400 or the PC.  From what it looks 
> like I can't do it.  At least not with a pooled connection on the PC 
> side.  Do you concur?
>
> Thanx again, PLA
>
>
> Joe Sam Shirah wrote:
>
> > > The getConnection() method on
> > > the AS400JDBCConnectionPoolDataSource
> > > still does not return a pooled connection.
> > >   
> >
> >
> >    Correct.  I probably wasn't very clear.  Use getConnection() from
> > *AS400JDBCConnectionPool*.  So, you need to implement a DataSource
> > that creates an AS400JDBCConnectionPool and gets everything from it.
> > Take a look at the documentation for AS400JDBCConnectionPool.  Hope that
> > clears things up somewhat.
> >
> >
> >                                                         Joe Sam
> >
> > Joe Sam Shirah -        http://www.conceptgo.com
> > conceptGO         -        Consulting/Development/Outsourcing
> > Java Filter Forum:       http://www.ibm.com/developerworks/java/
> > Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
> > Going International?    http://www.jguru.com/faq/I18N
> > Que Java400?             http://www.jguru.com/faq/Java400
> >
> >
> >
> > ----- Original Message -----
> > From: "Patrick L Archibald" <Patrick.Archibald@xxxxxxxxxxxxx>
> > To: "Java Programming on and around the iSeries / AS400"
> > <java400-l@xxxxxxxxxxxx>
> > Sent: Tuesday, July 29, 2003 5:09 PM
> > Subject: Re: dataSource.getConnection jt400
> >
> >
> >  
> >
> > > Hey Joe Sam
> > >
> > > I downloaded jtopen.jar 4.0.  The getConnection() method on the
> > > AS400JDBCConnectionPoolDataSource still does not return a pooled
> > > connection.
> > >
> > > I wonder if I could extend AS400JDBCConnectionPoolDataSource and get it
> > > to work?
> > >
> > > Thanx, PLA
> > >
> > >
> > > Joe Sam Shirah wrote:
> > >
> > >   
> > >
> > > >   Take a look at AS400JDBCConnectionPool in JTOpen 4.x and try
> > > > using that.  Your getConnection() problem stems from the fact that
> > > > AS400JDBCConnectionPoolDataSource descends from
> > > > AS400JDBCDataSource and does not override the getConnection()
> > > > methods there.
> > > >
> > > >   The source has been changed considerably in
> > > > AS400JDBCConnectionPoolDataSource and
> > > > AS400JDBCPooledConnection.  You probably have an earlier version
> > > > on the AS/400; That's the only reason I can think of why it worked 
> > > > there.
> > > >
> > > >   Let us know how it goes.
> > > >
> > > >
> > > >                                                        Joe Sam
> > > >
> > > > Joe Sam Shirah -        http://www.conceptgo.com
> > > > conceptGO         -        Consulting/Development/Outsourcing
> > > > Java Filter Forum:       http://www.ibm.com/developerworks/java/
> > > > Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
> > > > Going International?    http://www.jguru.com/faq/I18N
> > > > Que Java400?             http://www.jguru.com/faq/Java400
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "Patrick L Archibald" <Patrick.Archibald@xxxxxxxxxxxxx>
> > > > To: "Java Programming on and around the iSeries / AS400"
> > > > <java400-l@xxxxxxxxxxxx>
> > > > Sent: Tuesday, July 29, 2003 1:07 PM
> > > > Subject: Re: dataSource.getConnection jt400
> > > >
> > > >
> > > >
> > > >
> > > >     
> > > >
> > > > > Hey Joe Sam
> > > > >
> > > > > You're right on target. I have a class I call ObjectServer that 
> > > > > looks up
> > > > > the OS on creation, creates the DataSource accordingly and returns it
> > > > > via ObjectServer.getDataSource().   The only problem I'm having is 
> > > > > the
> > > > > the AS400JDBCConnectionPoolDataSource.getConnection() doesn't 
> > > > > appear to
> > > > > return a pooled connnection. I have to do the following to get a 
> > > > > pooled
> > > > > connection from the AS400JDBCConnectionPoolDataSource.
> > > > >
> > > > > AS400JDBCConnectionPoolDataSource dataSource = new
> > > > > AS400JDBCConnectionPoolDataSource("myserver.com");
> > > > > dataSource.setUser("myUser");
> > > > > dataSource.setPassword("myPassword");
> > > > > AS400JDBCPooledConnection pooledConnection = 
> > > > > (AS400JDBCPooledConnection)
> > > > > dataSource.getPooledConnection();
> > > > > Connection connection = pooledConnection.getConnection();
> > > > >
> > > > > Am I missing something?
> > > > >
> > > > > Thanks for the help!
> > > > >
> > > > > PLA
> > > > >
> > > > >
> > > > >
> > > > >       
> >
> >
> >
> >
> > _______________________________________________
> > 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.