Re: how do we know that JDBC connection has correct library list

Find it here: http://home.columbus.rr.com/jbmmdietz/iseries.html

Pete


Ashish Kulkarni wrote:

Hi
Suppose i am doing the following to create connection
Does this gurantee that the connection will have the
library list as defined in libl.
is there a way to check if the connection was created
properly with library list or not?
is there a way to find out the libarary list of
connection

Ashish
Class.forName("com.ibm.as400.access.AS400JDBCDriver"
);

//DriverManager.registerDriver(new
com.ibm.as400.access.AS400JDBCDriver());
         Properties prop = new Properties();
         prop.put( "user", "user" );
         prop.put( "password", "pass" );
         prop.put("prompt", "false");
         prop.put( "naming", "system" );
         prop.put( "date format", "iso" );
         prop.put( "time format", "hms" );
         prop.put("translate binary", "true");
         String libl = new String("TESTLIB62

MAPS6202FX MAPS6202DV MAPS6202TF MANU6202TQ QTEMP QGPL"); prop.put( "libraries", libl );

          conn = DriverManager.getConnection(

"jdbc:as400:myas400ip", prop );

                
____________________________________________________

Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs