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

[mandy.shaw@xxxxxxxxxxxxxxxxxxxxxxxxx]

Are you using the DB2 or the Toolbox JDBC driver? The situation varies
depending on the answer to this.





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

Please respond to JAVA400-L@midrange.com

To:   JAVA400-L@midrange.com
cc:    (bcc: Mandy Shaw/Pacific/UK)
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
+---



      Regards,
      Mandy Shaw

      Catalyst Solutions plc
      Kingfisher House
      Frimley Business Park
      Camberley
      Surrey
      GU16 5SG
      UK

      http://www.catalyst-solutions.com
      Email: Mandy.Shaw@uk.catalyst-solutions.com

      Telephone: +44 (0)870 166 1000
      DDI: +44 870 166 1324
      Facsimile: +44 870 168 3920
      Mobile: +44 410 447966
      Email to mobile 'phone: mandyshaw@sms.genie.co.uk




----------------------------------------------------------------------
----------------------------------------------------------------------
Catalyst Solutions plc.  Registered No 2918101.
Registered @ Kingfisher House, Frimley Business Park, Frimley,
Surrey. GU16 5SG   U.K.

NOTICE:
This message is intended only for the named addressee(s) and may
contain confidential and/or privileged information. If you are not the
named addressee you should not disseminate, copy or take any action
or place any reliance on it. If you have received this message in error
please notify postmaster@catalyst-solutions.com and delete the message
and any attachments accompanying it immediately.
----------------------------------------------------------------------