RE: Converting DriverManager connection to DataSource connection

David,

Thanks for the link. I think I'll do that - I notice that all the methods on
the interface I was worried about you've more or less ignored, so I can
probably get away with doing so as well....

Chris.

-----Original Message-----
From: David Morris [mailto:David.Morris@xxxxxxxxxxxxx] 
Sent: 25 August 2004 17:30
To: java400-l@xxxxxxxxxxxx
Subject: Re: Converting DriverManager connection to DataSource connection


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/iseriesto
olkit/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.

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


=======DISCLAIMER=======
This email transmission and any attachments may contain confidential
information which is legally privileged.  You are also notified that the
contents of this email and any which you may send in reply, may be viewed by
authorised personnel on behalf of NSB Retail Systems Plc or its subsidiaries
(the Company) in accordance with the Company's Information Access Policy.
The content of this email is always subject to contract.  The information is
intended only for the individual or entities to whom it is addressed.  If
you are not an intended recipient please contact me immediately and you are
hereby notified that any disclosure, copying, distribution, storage on any
medium or use of the information contained in this transmission is strictly
prohibited.