Re: Converting DriverManager connection to DataSource connection

["David Morris" <David.Morris@xxxxxxxxxxxxx>]

Chris,

There is no magic in a DataSource. All you need to do is implement the
interface. This link shows a pooled connection wrapped in a DataSource
(see AbstractConnectionManager):

http://cvs.sourceforge.net/viewcvs.py/iseries-toolkit/span/src/org/iseriestoolkit/database/

The connection and pool are configured via an
AS400ConnectionManager.properties files that combines Proxool and the
underlying connection's properties. The code is in the
AS400ConnectionManager class, which just looks for the properties file
on the class path.

David Morris



>>> chris_price@xxxxxxxxx 8/25/2004 9:37:27 AM >>>
All,

I have some code that creates a connection object the old fashioned,
JDBC 1
way:

        Class.forName("com.ibm.as400.access.AS400JDBCDriver").newInstance();
        Connection con =
DriverManager.getConnection(myJDBCUrl,myDriverProps);

I need to convert it to use more up to date DataSource, which I
thought
would be a simple enough job. But I'm stumped. All I really need is a
DataSource Implemetation that will wrap a connection configured as
above,
but such a thing doesn't seem to exist.

I've looked at JT400, expecting something there would do the job for
me, and
com.ibm.as400.access.AS400JDBCDataSource sounds like what I need. But
it is
configured in a completely different way:
        public AS400JDBCDataSource(java.lang.String serverName,
                                   java.lang.String user,
                                   java.lang.String password)
and can't take all the options that can be specified on the JBDC url or
the
properties file.

What am I missing here?

Chris.