RE: How to use LIBL in connection string.

I've tried using that, see my reply below but no joy I'm afraid.

        regards,

Rajesh Anand
Email:Rajesh_anand@xxxxxx


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Franco Biaggi
Sent: 28 July 2005 17:04
To: Java Programming on and around the iSeries / AS400
Subject: Re: How to use LIBL in connection string.


Hi,
you should use SystemNaming

Anand, Rajesh wrote:

>I've tried using multiple lib with commas, but the pgm fails to
>locate the file  like so...
>
>               Connection con = 
>       
>DriverManager.getConnection("jdbc:as400://mldev400;libraries = mylib1,
>mylib2; date format = iso" , "*CURRENT",
>               "*CURRENT");
>
>       But the main objective is to use LIBL rather than hard coding
>libs.
>
>       My java pgm is run from a CL where I'm also setting libl but its
>not being used by Java pgm.
>
>       Tried adding naming = system in the above string with no lib
>names, that didn't work either.
>
>       Any more ideas????
>
>       regards,
>
>       
>
>Rajesh Anand
>Email:Rajesh_anand@xxxxxx
>
>
>-----Original Message-----
>From: java400-l-bounces@xxxxxxxxxxxx
>[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Clapham, Paul
>Sent: 28 July 2005 16:01
>To: Java Programming on and around the iSeries / AS400
>Subject: RE: How to use LIBL in connection string. 
>
>
>No, you can't use %LIBL%. Direct quote from the documentation:
>
>"The server uses specified libraries to resolve unqualified stored
>procedure names, and stored procedures use them to resolve unqualified
>names. To specify multiple libraries, use commas or spaces to separate
>individual entries. You can use *LIBL as a placeholder for the current
>library list of the server job"
>
>In other words, it's *LIBL not %LIBL%.
>
>PC2
>
>-----Original Message-----
>From: java400-l-bounces@xxxxxxxxxxxx
>[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Anand, Rajesh
>Sent: July 28, 2005 01:51
>To: java400-l@xxxxxxxxxxxx
>Subject: How to use LIBL in connection string. 
>
>Folks,
>
>       I've seen in the list people talking about this but not found a
>solution.
>
>       I want to use a %LIBL% in my connection string as below.
>
>       Connection con =
>DriverManager.getConnection("jdbc:as400://mldev400;libraries = %LIBL%;
>date format = iso" , "*CURRENT", "*CURRENT");
>
>       However, when I run the pgm , it always uses mylib as opposed to
>%LIBL%.
>
>       How can overcome this problem. Can I also use *LOCAL instead of
>'mldev400' name of our system???
>
>       Thanks in advance.
>
>       
>
>Rajesh Anand
>
>  
>