RE: Converting DriverManager connection to DataSource connection

This is how a DataSource is configured.  There is no setProperties method or
something like that.  Of course, you could extend that class and write one
yourself.

What properties can you specify on the URL that you don't have a set method
for?

Gary

> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Price, Chris
> Sent: Wednesday, August 25, 2004 8:37 AM
> To: java400-l@xxxxxxxxxxxx
> Subject: Converting DriverManager connection to DataSource connection
> 
> 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.