Re: JDBC SQL problem

["Franco Biaggi" <fbiaggi@xxxxxxxxxx>]

I think we are doing the same,
with the difference that I can switch to another database (like MySql) in 
seconds.

Ciao.

On Tue, 02 Dec 2003 13:22:16 -0600, Glenn Holmer wrote:

>Franco Biaggi wrote:
>> A better way, is no qualifiers
>> this worka on any databases.
>> For the AS/400 we use the library list feature of the JDBC connection from 
>> an .ini file.

>I didn't want to do that because the app allows the user to select
>divisions of the company, and each division has its files in a
>separate library.  The connection comes from a pool, so it really
>wouldn't work.  The SQL string is built using a utility method that
>gets the library name from the division ID.

>-- 
>____________________________________________________________
>Glenn Holmer                          gholmer@xxxxxxxxxxxxxx
>Programmer/Analyst                       phone: 414.908.1809
>Weyco Group, Inc.                          fax: 414.908.1601

>_______________________________________________
>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 messages was scanned for malicious contents ***
-----------------------------------------------------------------------------
Franco Biaggi
CH-6807 Taverne