RE: Does anybody have experience setting up the client end of secured JDBC access?

Check the QHST logs (DSPLOG). If a connection is refused, it'll usually be logged there. Lots of stuff to look through there, so know the time of the request within a few seconds.

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of James Lampert
Sent: Thursday, October 11, 2012 11:08 AM
To: Java Programming on and around the IBM i
Cc: Midrange Systems Technical Discussion
Subject: Re: Does anybody have experience setting up the client end of secured JDBC access?

John Eberhard wrote:

That documentation is very old and should not be followed. You should be
able to use the standard Java mechanism of putting any required CA
certificates into your local keystore.

Dear Mr. Eberhard, et al:

I passed your entire answer to the contractor, and he reported back:

Thanks for extra information, I followed exactly and here is what I
have right now.

Firstly, the original error is gone, did not see any error which tell
me that Cert path not find.

Secondly, I got another error like this:
===============================================
java.sql.SQLException: The application requester cannot establish the
connection. (Connection was dropped unexpectedly.)
at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:565)
at
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:3186)
at
com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1411)
at
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1248)
at

com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:389)
=========================================
I think server might closed the connection somehow, any idea why this
happen?

I checked the QSQSRVR job joblogs on the AS/400 in question, and the QEZDEBUG and QEZJOBLOG output queues, and I don't see anything that appears relevant, but then again, I don't know what to look for.

--
JHHL
--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l.