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

You are right, it is strange that your profile worked but a profile from
the operations team didn't.  Please provide more detail.  What is the URL
and/or security properties you use with JDBC.  Tell me more about the batch
environment you use.  Could you be running on a profile with no password
when in production mode?

Since both Java program and database are on the AS/400 stick with the
native driver.  But, like you I want to know why security doesn't work with
the Toolbox driver.

David Wall
AS/400 Toolbox for Java


Marco_Van_Maris@ept.lu@midrange.com on 10/31/2000 01:28:15 AM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   JAVA400-L@midrange.com
cc:
Subject:  Re: JDBC : How to handle user-id and password






Thanks for your answers, replacing our system name
by localhost got the programm running without entering
user-id and password.

Nevertheless I experienced something strange, which
I find worth being explained.

I started using the AS/400 Toolbox driver. With
my user-profile this worked fine, I could submit
the job to batch and it completed errorfree. In production
the job was to be scheduled by our operations team,
who are obviously using a different user-profile but
which has the same rights than mine. Strangely the job
did not complete under this user-id, it tried to create
awt windows to ask for user-id and password, and as it
run on the AS/400 ended of course abnormally.

Then I changed the programm to use th DB2 driver,
and luckily (for me) the programm worked under my
and under the operations user-profile.

Maybe someone could explain me this mistery ???

Thanks

marco van maris



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



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