|
midrange.com
As Rich said, the Toolbox must have a password to connect to the database
server. You best option here is to use the native JDBC driver.
David Wall
AS/400 Toolbox for Java
"DUCRET Gilles
(GVA)" To: "JAVA400-L (E-mail)"
<JAVA400-L@midrange.com>
<Gilles.DUCRET@Lloy cc:
dsBank.ch> Subject: Connection and
password
Sent by:
owner-java400-l@mid
range.com
07/06/2001 05:00 AM
Please respond to
JAVA400-L
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.
**********************************************************************
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
+---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
