Re: JDBC SQL problem

[Dieter Bender <dieter.bender@xxxxxxxxxxxx>]

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