Re: [Squirrel-sql-users] remote db2 connection over ssh tunnel

[Alexandre P. <Ale...@ei...>]

You question implies that you are connecting to a DB2 database on a server, but the connection URL you quoted seem to indicate that you directed SQuirreL to connect to localhost.

Sent from my iPhone

On Aug 29, 2016, at 12:01 AM, Matt F <de...@ya...<mailto:de...@ya...>> wrote:

What CLI commands are you issuing?

I have always used the IBM drivers over the SQUIRREL included drivers FWIW

==============================================
Matt Ferreira
de...@ya...<mailto:de...@ya...>


________________________________
From: Shilpa Kotiyan <sko...@zt...<mailto:sko...@zt...>>
To: squ...@li...<mailto:squ...@li...>
Sent: Friday, August 26, 2016 8:21 AM
Subject: [Squirrel-sql-users] remote db2 connection over ssh tunnel

Hi,
I am using squirrel 3.7  to connect to a db2 database on linux. I am tunneled to the DB server over ssh using putty. I confirmed that the tunnel is working as I can execute sql over the command line. However, when I attempt to connect via squirrel;, I get the error below:

Connection via DB2 universal driver. using the format "jdbc:db2://localhost:port/dbname"

Java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2057][11264][4.17.29] The application server rejected establishment of the connection.
An attempt was made to access a database, AUTH, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004