RE: How to use LIBL in connection string.

Some hoe java job did not pick up the librarylist of
the job or CL programm calling it, so i just send
library list as input parameter in java class
--- "Anand, Rajesh" <Rajesh_Anand@xxxxxx> wrote:

> Did this actually work???
> 
>       Did the java pgm didn't use userid as default lib.
> 
> Rajesh Anand
> Email:Rajesh_anand@xxxxxx
> 
> 
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
> Ashish Kulkarni
> Sent: 28 July 2005 16:38
> To: Java Programming on and around the iSeries /
> AS400
> Subject: 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
> -- 
> 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.
> 
> 


A$HI$H

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com