Can't you get around this using the Native JDBC driver (which you should be
doing if the application is running in the 400 directly anyway)? I assume
you currently are not because of the comment about the connection asking
for a user id and password.
There is some profile that is running your batch job... if you connect
specifying no user id or password, the current job user profile and
password will be used. Doesn't that solve your problem?
Regards,
Richard D. Dettinger
AS/400 Java Data Access Team
"Biologists have a special word for stability -- dead"
Larry Wall
Open Source Developers Journal
Issue 1, Jan 2000
"DUCRET Gilles (GVA)" <Gilles.DUCRET@LloydsBank.ch>@midrange.com on
07/06/2001 05:00:29 AM
Please respond to JAVA400-L@midrange.com
Sent by: owner-java400-l@midrange.com
To: "JAVA400-L (E-mail)" <JAVA400-L@midrange.com>
cc:
Subject: Connection and password
I have an annoying specification.
I have a server written in java, running on the as400. This serveur must
access the database. Nobody is logged
to this server, it just receives queries from a batch process and do its
job.
I access the DB using JDBC.
The spec i have is: the operators want to automate the processes and so
they don't want to manage any password.
+ the password can not be stored in a property file, even encoded.
What can i do to access the DB. With websphere i could use a datasource
managed by websphere. I do not use websphere
in this case.
Can i use a special profil, with no password. I have tried, but the JDBC
connection always asked me to give a password.
Can i use this kind of "system" profile, the kind we use for MQSeries. No
password is requested in this case.
I don't know how to solve that
Many thanks
Gilles Ducret
Wealth Management Division
IT Architect
Lloyds TSB Bank
Tel: + 41 22 307 31 50
Mob: +41 79 217 21 41
**********************************************************************
This E-mail and any files transmitted with it are confidential
and intended for the exclusive use of the addressee(s) only.
You should not disclose its contents to any other person.
If you are not the intended recipient please notify the sender
immediately.
**********************************************************************
+---
| 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
+---
