× 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.



Hi there,

I'm attempting to install our software on a customer's AS400 and hitting a
brick wall attempting to connect to DB2 or establish a record access
connection for retrieving data area values.

I am told there are no exit programs which would prevent access.

This is the exception when attempting to connect via JDBC:

com.ibm.as400.access.ConnectionDroppedException: Connection was dropped
unexpectedly.
at
com.ibm.as400.access.ClientAccessDataStream.construct(ClientAccessDataStream.java:62)
at
com.ibm.as400.access.AS400ThreadedServer.run(AS400ThreadedServer.java:357)
at java.lang.Thread.run(Thread.java:736)

And this is the exception when attempting to establish an AS400 connection
(record access) for retrieving data areas:

Thread[Test Thread,5,main] to mar 12 14:10:04:977 CET 2015 DDM SECCHK
failed with code point:
12 54
java.lang.Throwable
at com.ibm.as400.access.Trace.log(Trace.java:1164)
at
com.ibm.as400.access.DDMSECCHKReplyDataStream.checkReply(DDMSECCHKReplyDataStream.java:28)
at
com.ibm.as400.access.ClassDecoupler.connectDDMPhase2(ClassDecoupler.java:103)
at
com.ibm.as400.access.AS400ImplRemote.getConnection(AS400ImplRemote.java:1028)
at com.ibm.as400.access.AS400ImplRemote.connect(AS400ImplRemote.java:402)
at com.ibm.as400.access.AS400.connectService(AS400.java:1186)
at com.ibm.as400.access.PoolItem.<init>(PoolItem.java:132)
at
com.ibm.as400.access.ConnectionList.createNewConnection(ConnectionList.java:182)
at
com.ibm.as400.access.ConnectionList.getConnection(ConnectionList.java:460)
at
com.ibm.as400.access.AS400ConnectionPool.getConnection(AS400ConnectionPool.java:953)
at
com.ibm.as400.access.AS400ConnectionPool.getConnection(AS400ConnectionPool.java:984)
at
com.ibm.as400.access.AS400ConnectionPool.getConnection(AS400ConnectionPool.java:504)
at
com.internationalpresence.impscloudgateway.util.AS400Server.getAS400(AS400Server.java:36)

I've uploaded the JT400 trace logs in the hope that someone might be able
to nudge me in the right direction:

http://www.international-presence.com/matt/jt400_trace.txt

The JDBC connection attempt is at mar 12 14:09:35:799 CET 2015
The Data Area read attempt is around mar 12 14:10:04:707 CET 2015

Source files for connection tests are here:

http://www.international-presence.com/matt/AS400ConnectionTester.java
http://www.international-presence.com/matt/AS400Server.java
http://www.international-presence.com/matt/ConnectionServer.java

Any advice would be very much appreciated. Please let me know if there's
anything else I should provide.

Thanks and regards
Matt Pryor



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.