Re: JDBC : How to handle user-id and password

The Native JDBC driver has always worked this way.  Code along these lines:

// Register the driver by loading it.
Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
// Connect to the database.
Connection connection = DriverManager.getConnection
("jdbc:db2://localhost");

Will connect with the user id and password of the running job.

With the Native Driver, the fact that we are using localhost here is not
significant.  Any connection that is needed will attempt to use the job
user id and password when nothing else is provided.


Regards,

Richard D. Dettinger
AS/400 Java Data Access Team

"TRUE! nervous, very, very dreadfully nervous I had been and am; but why
WILL you say that I am mad?
The disease had sharpened my senses, not destroyed, not dulled them. "

- Edgar Allan Poe
"The Tell-Tale Heart"




Dave Wall/Rochester/IBM@IBMUS@midrange.com on 10/27/2000 08:32:42 AM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   JAVA400-L@midrange.com
cc:
Subject:  Re: JDBC : How to handle user-id and password




I am able to get the Toolbox to pick up the current job's userid/password.
The key lines in my program are:
            DriverManager.registerDriver(new
com.ibm.as400.access.AS400JDBCDriver());
            connection = DriverManager.getConnection
("jdbc:as400://localhost");

Note the system name is "localhost".  That tells the Toolbox to access data
on the current system.  If you don't specify signon information the Toolbox
will default to the current job's uid/pwd.  To get it to work you must have
at least v4r3 AS/400 and Toolbox mod 1.

A few more points:
   The current job's userid must have a password.  Since Toolbox JDBC works
   through a server, a password is needed for authentication.  Password =
   *none won't work.

   In general it is better to use the native JDBC driver when running on
   the AS/400.  You will find performance is better when using the native
   driver over the Toolbox driver when the Java program and database are on
   the same AS/400.

David Wall
AS/400 Toolbox for Java


Marco_Van_Maris@ept.lu@midrange.com on 10/27/2000 04:28:29 AM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   JAVA400-L@midrange.com
cc:
Subject:  JDBC : How to handle user-id and password





Dear all.

I've written a Java programm which extracts data from tables on our AS/400
using
JDBS calls.
The programm is supposed to run on the AS/400 (OS 4.3).

The question is how do I best handle the userid and password that are
needed to
connect
to the DB2 using the DriverManager.getConnection method ? Right now I have
hardcoded both into my programm what I don't really like.

The doc says that if you run it on the AS/400 the user-profile and password
from
the user that started th job would be used. In our case this does not
happen,you
have to indicate user-id and password. Is this some PTF stuff or will OS
4.4 or
4.5 resolve that issue ?

Thanks for your feedback

Marco van Maris
EPT Luxembourg


Electronic information is not secure, therefore the Entreprise des Postes
et Télécommunications accepts no responsibility whatsoever for the
contents of this message, which is intended for the addressee only. Its
contents and any attached files are strictly confidential. If you have
received this message in error, please telephone the following number
4765-1.


+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---