RE: Converting DriverManager connection to DataSource connection

Marc,

I understand your point - I can't find a setter missing.

The problem is that currently the jdbcUrl & driver properties are defined in
external property files, to allow our customers to configure their own
connection information, and changing the format of this is not an option.

So to use the existing information, I'll have to parse the JDBC URL string
to strip out the hostname and any parameters on the URL, process the
parameter file, then use reflection to call all the correct setters on
AS400JDBCDataSource. That's a lot of work to replace 2 lines of code.

To make it worse, when you look inside the code for AS400JDBCDataSource,
it's then rebuilds the JDBC URL, based on what it thinks it should be
anyway! So why can't I just set it upfront?

Chris.

-----Original Message-----
From: Marc Logemann [mailto:spam1@xxxxxxxxxxxx] 
Sent: 25 August 2004 17:04
To: Java Programming on and around the iSeries / AS400
Subject: Re: Converting DriverManager connection to DataSource connection


Price, Chris wrote:

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

Hi,

you are missing that an object is more than its set of constructor 
parameters. There are a lot of setter methods doing different things...

AS400JDBCDataSource.setLibraries()
AS400JDBCDataSource.setNaming()
[..]

Or do you miss some setters which should be there?


-- 

regards
Marc Logemann
http://www.logemann.org

--
"Programming is like Sex, one mistake and you support it for a lifetime"
--
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.