Re: JDBC Library list property in V4R5 native driver

Hi,
I use JT400.jar, maybe 5 or 6 libraries.


On Thu, 28 Aug 2003 12:57:52 -0700, Bruce Jin wrote:

>Hi Franco:

>This is interesting.

>I tried space, comma, and colon and nothing worked. I have to use that work
>around for V4R5. How many libraries do you include in your connection URL?

>Thanks.

>Bruce.



>----- Original Message ----- 
>From: "Franco Biaggi" <fbiaggi@xxxxxxxxxx>
>To: "Java Programming on and around the iSeries / AS400"
><java400-l@xxxxxxxxxxxx>
>Sent: Thursday, August 28, 2003 9:41 AM
>Subject: Re: JDBC Library list property in V4R5 native driver


>> fyi,
>> we are using library list on V4R5M0 without any problems...
>> Ciao.
>>
>> On Thu, 28 Aug 2003 09:28:47 -0700, Bruce Jin wrote:
>>
>> >Thanks for the reply.
>>
>> >It looks like the library list thing does not work on V4R5. One has to
>use
>> >this work around:
>>
>> >http://archive.midrange.com/java400-l/200107/msg00030.html
>>
>> >Thanks.
>>
>> >Bruce
>>
>> >----- Original Message ----- 
>> >From: "M. Lazarus" <mlazarus@xxxxxxxx>
>> >To: "Java Programming on and around the iSeries / AS400"
>> ><java400-l@xxxxxxxxxxxx>
>> >Sent: Tuesday, August 26, 2003 8:04 AM
>> >Subject: Re: JDBC Library list property in V4R5 native driver
>>
>>
>> >> Bruce,
>> >>
>> >>   I seem to recall that you needed an extra delimiter in the front of
>the
>> >> *LIBL.So it would look something like this:
>> >>
>> >> "jdbc:db2://*LOCAL;naming=SYSTEM;libraries=,LIBA,LIBB";
>> >>
>> >>   -mark
>> >>
>> >> At 8/26/03 12:23 PM, you wrote:
>> >> >This is the url I use to get connection:
>> >> >
>> >> >"jdbc:db2://*LOCAL;naming=SYSTEM;libraries=LIBA:LIBB";
>> >> >
>> >> >There is a file MYFILE in LIBB. I query MYFILE using "SELECT * FROM
>> >> >MYFILE". On a V4R5 box I get "File MYFILE in LIBA type *FILE not
>found".
>> >> >However, the same program work on V5R1 and V5R2 boxes.
>> >> >
>> >> >Any ideas? Thanks!
>>
>>
>> >_______________________________________________
>> >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.
>>
>>


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