Re: Toolbox and JDBC User / Password

["Dave Wall" <dawall@xxxxxxxxxx>]

1. Use the default AS400 c'tor ...
      AS400 system = new AS400();
That will connect you to the current system using the current job's
uid/pwd.

2. Same answer for Toolbox JDBC -- don't specify system name, uid or pwd
...
      connection = DriverManager.getConnection
("jdbc:as400://;prop1=value;prop2=value");

Don't forget to add the classes that extract the current job's uid/pwd to
your CLASSPATH.  Use /qibm/proddata/os400/jt400/lib/jt400Native.jar (v5r1
and later), or jt400.jar plus /QIBM/ProdData/Java400/jt400ntv.jar


David Wall
Toolbox for Java
iSeries ODBC Driver for Linux




                      "Richards, Etienne
                      (CAP, PTL)"               To:       
"'java400-l@midrange.com'" <java400-l@midrange.com>
                      <Etienne.Richards@        cc:
                      penske.com>               Subject:  Toolbox and JDBC User 
/ Password
                      Sent by:
                      java400-l-admin@mi
                      drange.com


                      03/08/2002 07:03
                      AM
                      Please respond to
                      java400-l





All,

Two questions:

1. How do you connect to an AS/400 using the AS400 Toolbox object if you
are
running the code on the AS/400 and you want to connect as the current user?

   AS400 system = new AS400("localhost", ?, ?);

2. How do you connect to an AS/400 database using the Toolbox jdbc driver
and the native DB2 jdbc driver if you are running the code on the AS/400
and
you want to connect as the current user?
   Connection conn = DriverManager.getConnection("localhost", ?, ?);


Thanks,
Etienne
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.