RE: How to use LIBL in connection string.

Hi
I tried it to, but some how java could not pick up the
current jobs library list, so i added a parameter to
my java class and send the library list from CL to
this java program
what i did was following
in CL
 DCL        VAR(&usrlibl) TYPE(*CHAR) LEN(2750) 
 RTVJOBA    USRLIBL(&USRLIBL)      

and in my java program created connection as belwo
Properties prop = new Properties();
       prop.put("prompt", "false");
       prop.put("naming", "system");
       prop.put("date format", "iso");
       prop.put("time format", "hms");
       prop.put("libraries", liblList);
       prop.put("behavior override", "1");
       String sourceURLDB2 = "jdbc:db2:*local";
      
Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
       Connection db2conn =
DriverManager.getConnection(sourceURLDB2, prop);

Ashish


--- "Anand, Rajesh" <Rajesh_Anand@xxxxxx> 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
> 
> -- 
> 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.
>
--------------------------------------------------------
> 
> If you are not an intended recipient of this e-mail,
> please notify the sender, delete it and do not read,
> act upon, print, disclose, copy, retain or
> redistribute it. Click here for important additional
> terms relating to this e-mail.    
> http://www.ml.com/email_terms/
>
--------------------------------------------------------
> 
> -- 
> 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.
> 
> 



        
                
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - You care about security. So do we. 
http://promotions.yahoo.com/new_mail