Menu ▾ ▴

#1203 Exception while trying to connect to iSeries/AS400/DB2 using SSL

SQuirreL
open
nobody
None
3
2015-06-17
2015-06-17
Chris Moulding
No

Squirrel version 3.6
JTOpen.jar version 8.5
Java version 1.7.0.11
Driver property "secure=true"

I'm attempting to connect Squirrel to our iSeries/AS400/DB2 database using SSL and I get the exception listed below. I was able to test the connection successfully, but actually connecting does not work. I do have the correct certificates from my iSeries installed in the cacerts file for my version of java, and I am able to successfully connect using SSL using our Websphere app server (same driver, same certs, same properties).

java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLNonTransientConnectionException: The application requester cannot establish the connection. (Connection was dropped unexpectedly.)
at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:262)
at java.util.concurrent.FutureTask.get(FutureTask.java:119)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Caused by: java.lang.RuntimeException: java.sql.SQLNonTransientConnectionException: The application requester cannot establish the connection. (Connection was dropped unexpectedly.)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
... 6 more
Caused by: java.sql.SQLNonTransientConnectionException: The application requester cannot establish the connection. (Connection was dropped unexpectedly.)
at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:817)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:549)
at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:3346)
at com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1419)
at com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1256)
at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:395)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
... 8 more
Caused by: com.ibm.as400.access.ConnectionDroppedException: Connection was dropped unexpectedly.
at com.ibm.as400.access.ClientAccessDataStream.construct(ClientAccessDataStream.java:62)
at com.ibm.as400.access.AS400NoThreadServer.receive(AS400NoThreadServer.java:189)
at com.ibm.as400.access.AS400NoThreadServer.sendAndReceive(AS400NoThreadServer.java:110)
at com.ibm.as400.access.AS400ImplRemote.signon(AS400ImplRemote.java:2397)
at com.ibm.as400.access.AS400.sendSignonRequest(AS400.java:3181)
at com.ibm.as400.access.AS400.promptSignon(AS400.java:2745)
at com.ibm.as400.access.AS400.signon(AS400.java:4076)
at com.ibm.as400.access.AS400.connectService(AS400.java:1203)
at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:3338)
... 13 more

Discussion

  • Chris Moulding

    Chris Moulding - 2015-06-17

    I also tried java version 1.8.0.40 with the same result

     

  • Chris Moulding

    Chris Moulding - 2015-06-17

    also tried 1.8.0.45 (latest), same result

    system details (from squirrel):
    java.runtime.name Java(TM) SE Runtime Environment
    sun.boot.library.path C:\Program Files\Java\jre1.8.0_45\bin
    java.vm.version 25.45-b02
    java.vm.vendor Oracle Corporation
    java.vendor.url http://java.oracle.com/
    path.separator ;
    java.vm.name Java HotSpot(TM) 64-Bit Server VM
    file.encoding.pkg sun.io
    user.script
    user.country US
    sun.java.launcher SUN_STANDARD
    sun.os.patch.level Service Pack 1
    java.vm.specification.name Java Virtual Machine Specification
    user.dir C:\Program Files\squirrel-sql-3.6
    java.runtime.version 1.8.0_45-b15
    java.awt.graphicsenv sun.awt.Win32GraphicsEnvironment
    java.endorsed.dirs C:\Program Files\Java\jre1.8.0_45\lib\endorsed
    os.arch amd64
    java.io.tmpdir C:\Users\<USER_NAME>\AppData\Local\Temp\ line.separator

    java.vm.specification.vendor Oracle Corporation
    user.variant
    os.name Windows 7
    proxySet true
    sun.java2d.noddraw true
    sun.jnu.encoding Cp1252
    java.library.path C:\Program Files\Java\jre1.8.0_45\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\oracle11g32bit\product\11.1.0\client_1\bin;C:\oraclexe\app\oracle\product\11.2.0\server\bin;C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Integrity\IntegrityClient10\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;c:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\cvsnt;C:\PROGRA~2\INTEGR~1\Toolkit\mksnt;C:\Program Files (x86)\IBM\Client Access\Emulator;C:\Program Files (x86)\IBM\Client Access\Shared;C:\Program Files (x86)\IBM\Client Access\;C:\Program Files\TortoiseSVN\bin;C:\Program Files\TortoiseGit\bin;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SDKs\TypeScript\1.0\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\WindowsPowerShell\v1.0\;c:\program files (x86)\baremetal;c:\program files (x86)\ibm\sdp\runtimes\base_v61\bin;a. \lpv-finwsdev01\test\BuildQueue;\lpv-finwsdev01\test\DeployQueue;\txv-finwsdev01\test\BuildQueue;\txv-finwsdev01\test\DeployQueue;c:\program files (x86)\sysinternalssuite;c:\public\jtwain\;c:\program files (x86)\putty;C:\Program Files (x86)\Nmap;C:\Program Files (x86)\Apache\apache-maven-3.0.5\bin;.
    http.proxyPort 8080
    sun.awt.enableExtraMouseButtons true
    java.specification.name Java Platform API Specification
    java.class.version 52.0
    sun.management.compiler HotSpot 64-Bit Tiered Compilers
    os.version 6.1
    user.timezone America/Denver
    java.awt.printerjob sun.awt.windows.WPrinterJob
    java.specification.version 1.8
    file.encoding Cp1252
    java.class.path C:\Program Files\squirrel-sql-3.6\squirrel-sql.jar;C:\Program Files\squirrel-sql-3.6\lib\antlr.jar;C:\Program Files\squirrel-sql-3.6\lib\asm-attrs.jar;C:\Program Files\squirrel-sql-3.6\lib\asm.jar;C:\Program Files\squirrel-sql-3.6\lib\autocomplete.jar;C:\Program Files\squirrel-sql-3.6\lib\axis-jaxrpc.jar;C:\Program Files\squirrel-sql-3.6\lib\axis-saaj.jar;C:\Program Files\squirrel-sql-3.6\lib\axis-wsdl4j.jar;C:\Program Files\squirrel-sql-3.6\lib\axis.jar;C:\Program Files\squirrel-sql-3.6\lib\cglib.jar;C:\Program Files\squirrel-sql-3.6\lib\common.jar;C:\Program Files\squirrel-sql-3.6\lib\commons-cli.jar;C:\Program Files\squirrel-sql-3.6\lib\commons-codec.jar;C:\Program Files\squirrel-sql-3.6\lib\commons-collections.jar;C:\Program Files\squirrel-sql-3.6\lib\commons-discovery.jar;C:\Program Files\squirrel-sql-3.6\lib\commons-httpclient.jar;C:\Program Files\squirrel-sql-3.6\lib\commons-lang.jar;C:\Program Files\squirrel-sql-3.6\lib\commons-logging.jar;C:\Program Files\squirrel-sql-3.6\lib\core.jar;C:\Program Files\squirrel-sql-3.6\lib\dom4j.jar;C:\Program Files\squirrel-sql-3.6\lib\forms.jar;C:\Program Files\squirrel-sql-3.6\lib\hibernate-annotations.jar;C:\Program Files\squirrel-sql-3.6\lib\hibernate-commons-annotations.jar;C:\Program Files\squirrel-sql-3.6\lib\hibernate-entitymanager.jar;C:\Program Files\squirrel-sql-3.6\lib\hibernate.jar;C:\Program Files\squirrel-sql-3.6\lib\icu4j.jar;C:\Program Files\squirrel-sql-3.6\lib\javahelp.jar;C:\Program Files\squirrel-sql-3.6\lib\jcommon.jar;C:\Program Files\squirrel-sql-3.6\lib\jfreechart.jar;C:\Program Files\squirrel-sql-3.6\lib\jide-oss.jar;C:\Program Files\squirrel-sql-3.6\lib\jmeld.jar;C:\Program Files\squirrel-sql-3.6\lib\log4j.jar;C:\Program Files\squirrel-sql-3.6\lib\nanoxml.jar;C:\Program Files\squirrel-sql-3.6\lib\org.eclipse.equinox.common.jar;C:\Program Files\squirrel-sql-3.6\lib\osgi.jar;C:\Program Files\squirrel-sql-3.6\lib\poi-ooxml-schemas.jar;C:\Program Files\squirrel-sql-3.6\lib\poi-ooxml.jar;C:\Program Files\squirrel-sql-3.6\lib\poi.jar;C:\Program Files\squirrel-sql-3.6\lib\rstaui.jar;C:\Program Files\squirrel-sql-3.6\lib\rsyntaxtextarea.jar;C:\Program Files\squirrel-sql-3.6\lib\rtext.jar;C:\Program Files\squirrel-sql-3.6\lib\spring-beans.jar;C:\Program Files\squirrel-sql-3.6\lib\spring-context-support.jar;C:\Program Files\squirrel-sql-3.6\lib\spring-context.jar;C:\Program Files\squirrel-sql-3.6\lib\spring-core.jar;C:\Program Files\squirrel-sql-3.6\lib\squirrel-sql.jar;C:\Program Files\squirrel-sql-3.6\lib\stringtemplate.jar;C:\Program Files\squirrel-sql-3.6\lib\swing-worker.jar;C:\Program Files\squirrel-sql-3.6\lib\treetable.jar;C:\Program Files\squirrel-sql-3.6\lib\versioncheck.jar;C:\Program Files\squirrel-sql-3.6\lib\x86.jar;C:\Program Files\squirrel-sql-3.6\lib\xml-apis.jar;C:\Program Files\squirrel-sql-3.6\lib\xmlbeans.jar
    java.vm.specification.version 1.8
    sun.arch.data.model 64
    java.home C:\Program Files\Java\jre1.8.0_45
    sun.java.command net.sourceforge.squirrel_sql.client.Main --log-config-file C:\Program Files\squirrel-sql-3.6\log4j.properties --squirrel-home C:\Program Files\squirrel-sql-3.6
    java.specification.vendor Oracle Corporation
    user.language en
    awt.toolkit sun.awt.windows.WToolkit
    java.vm.info mixed mode
    java.version 1.8.0_45
    java.ext.dirs C:\Program Files\Java\jre1.8.0_45\lib\ext;C:\Windows\Sun\Java\lib\ext
    sun.boot.class.path C:\Program Files\Java\jre1.8.0_45\lib\resources.jar;C:\Program Files\Java\jre1.8.0_45\lib\rt.jar;C:\Program Files\Java\jre1.8.0_45\lib\sunrsasign.jar;C:\Program Files\Java\jre1.8.0_45\lib\jsse.jar;C:\Program Files\Java\jre1.8.0_45\lib\jce.jar;C:\Program Files\Java\jre1.8.0_45\lib\charsets.jar;C:\Program Files\Java\jre1.8.0_45\lib\jfr.jar;C:\Program Files\Java\jre1.8.0_45\classes
    http.proxyHost <ENTERPRISE_PROXY_SERVER>
    java.vendor Oracle Corporation
    file.separator \ java.vendor.url.bug http://bugreport.sun.com/bugreport/
    sun.cpu.endian little
    sun.io.unicode.encoding UnicodeLittle
    sun.desktop windows
    sun.cpu.isalist amd64

     

Log in to post a comment.