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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2022 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.