Re: JDBC SQL problem

Dieter,
I agree with you, but the AS/400 tables are stored in a library, not in a 
database (this is the system).
Using library lists allows you to access tables on multiple libraries, quick 
switch of test/prod environments etc.

My opinion...

On Tue, 2 Dec 2003 21:14:22 +0100, Dieter Bender wrote:

>Hi,

>IMHO no good idea to use a "Libraray List" for a database application.
>First putting constraints to ensure referential integrity and then reading the 
>order from one database (= library) and the artcel from another.

>Dieter Bender

>On Dienstag, 2. Dezember 2003 19:49, 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.
>>
>> On Tue, 2 Dec 2003 10:50:25 -0700, Kristen Henry wrote:
>> >I write a method in my databean (the 'parent' databean, and all my
>> >databeans extend from it) that gets the DataBaseMetaData from the
>> >connection, then gets the Catalog Separator for the database.  I then
>> >concatenate it into my SQL.  That way, it automatically changes
>> >depending on what database I end up connecting to.
>> >
>> >Kristen
>> >
>> >-----Original Message-----
>>
>> From: java400-l-bounces+klhnry=bonchien.com@xxxxxxxxxxxx
>>
>> >[mailto:java400-l-
>> >
>> >On Tue, 02 Dec 2003 10:05:30 -0600, Glenn Holmer wrote:
>> >>OK, I found how to do that and it works, but that means changing
>> >>all the other SQL in this program.  Is there a way to correct the
>> >>syntax so that it runs with sql naming?
>> >
>> >this is already the default on the JT/400 jdbc driver.
>> >
>> >
>> >
>> >_______________________________________________
>> >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
>>
>> _______________________________________________
>> 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.

>-- 
>mfG

>Dieter Bender


>DV-Beratung Dieter Bender
>Wetzlarerstr. 25
>35435 Wettenberg
>Tel. +49 641 9805855
>Fax +49 641 9805856
>www.bender-dv.de
>eMail dieter.bender@xxxxxxxxxxxx

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