× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: Connection and password
  • From: "Richard Dettinger" <cujo@xxxxxxxxxx>
  • Date: Fri, 6 Jul 2001 08:21:14 -0500
  • Importance: Normal


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
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.