Re: dataSource.getConnection jt400 -- JAVA400-L

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.