RE: How to use LIBL in connection string.

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