Re: password on DB connection

["David Morris" <David.Morris@xxxxxxxxxxxxx>]

Pat,

If you have Kerberos running you can use a ticket to get your
connection. That would be much better but is a not a well traveled road.
Are you running this code on the iSeries? If you are you could run your
process under a user with secadm and then swap the thread to the
appropriate user before performing the actual work. 

David Morris

>>> patrick.odowd@xxxxxxxxxxxxxxxxxxxxxx 3/9/2004 4:57:49 AM >>>
Before acting on this e-mail or opening any attachment, you are advised
to read the disclaimer at the end of this mail.

Hi,
Currently when I get an AS400 DB connection I do:

      DriverManager.registerDriver(new
com.ibm.as400.access.AS400JDBCDriver());
      as400Connection =
          DriverManager.getConnection(
          "jdbc:as400://" + as400System + "/" + as400Collection, user,
password);

I retrieve the user and password from a properties file. The process is
a batch
process.

I setup a userid for DB access that cannot sign on with a password that
never
expires. Is there a better way to do this?

Thanks in advance,
Pat