RE: How to use LIBL in connection string.

Rajesh,

Use colons instead of commas to separate your libraries.

DriverManager.getConnection("jdbc:as400://mldev400;libraries=mylib1:mylib2;n
aming=system;date format = iso",
"*CURRENT","*CURRENT");

Richard


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