RE: password on DB connection

Patrick,

Is this a java application or a web app running on tomcat/websphere

Cheers
Colin.W

-----Original Message-----
From: patrick.odowd@xxxxxxxxxxxxxxxxxxxxxx
[mailto:patrick.odowd@xxxxxxxxxxxxxxxxxxxxxx] 
Sent: 09 March 2004 11:58
To: java400-l@xxxxxxxxxxxx
Subject: password on DB connection


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


**********************************************************************
This e-mail is intended solely for the addressee and is strictly
confidential. If you are not the addressee, please do not read, print,
re-transmit, store or act in reliance on it or any attachments. Instead
please e-mail it back to the sender and delete the message from your
computer.

E-mail transmission cannot be guaranteed to be secure or error free and The
Co-operative Bank accepts no liability for changes made to this e-mail (and
any attachments) after it was sent or for viruses arising as a result of
this e-mail transmission.

Any unauthorised reproduction, dissemination, copying, disclosure,
modification, distribution and/or publication of this e-mail message is
strictly prohibited.

The Co-operative Bank reserves the right to intercept any e - mails or other
communication for permitted purposes in accordance with the current
legislation which you send to, or receive from, any of the employees or
agents of the Bank via Bank telecommunication systems. By so corresponding
you also give your consent to the Bank monitoring and recording of any
correspondence using these systems.   

The Co-operative Bank p.l.c. is registered in England and Wales, number
990937. The registered office is at PO Box 101, 1, Balloon Street,
Manchester, M60 4EP.  
**********************************************************************
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.


This e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is The Nest, Rosary Road Norwich NR1 1TF. 
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately. Opinions, conclusions and statements of intent in this 
e-mail are those of the sender and will not bind a Bertram Group Ltd company 
unless confirmed in writing by a director independently of this message. 
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.