Re: JDBC Library list property in V4R5 native driver

["Bruce Jin" <brucej@xxxxxxxxxxxxxxxxxxxx>]

Thanks for the info.



I noted that you are using toolbox driver. It would be interesting to know
if the native driver will work on your V4R5. I just had a conversation with
IBM. This was what they told me: (we were talking native driver)



We checked the V4R5 code and there is not a way to specify a library list in
V4R5.  If you need the library list, you have to use the work around
specified in the referenced URL.  Because the native driver is a type 2
driver and uses native binary code, you cannot use the JAR file from V5R1 on
V4R5 - ibm jdbc team



----- Original Message ----- 
From: "Franco Biaggi" <fbiaggi@xxxxxxxxxx>
To: "Java Programming on and around the iSeries / AS400"
<java400-l@xxxxxxxxxxxx>
Sent: Friday, August 29, 2003 12:45 AM
Subject: 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!
> >>