Start a new topic

Can't connect to Oracle using thin JDBC and SSL

[This topic is migrated from our old forums. The original author name has been removed]

Hi, Our security policy is to mandate SSL connections to our databases from office users, we have a working setup using tnsnames for non-ssl connections with DBVis or SSL-connections with SQLDeveloper but we can't get DBVis working with SSL. Looking at a wire-trace of the connection it looks like DBVis successfully authenticates with the listener and is then pushed to a (random) high port on the Oracle server. This means the connection is then blocked by the firewall and times out. We have the same problem running DBVis on both Linux and Mac OS X. Is there anyway to control this behaviour difference between SQLDeveloper and DBVis? thanks Michael

[This reply is migrated from our old forums.]

Re: Can't connect to Oracle using thin JDBC and SSL
Hi Michael, This sounds like some configuration issue between the JDBC driver and the TNS listener. Have you followed the instructions in this document? http://www.oracle.com/technetwork/database/enterprise-edition/wp-oracle-jdbc-thin-ssl-130128.pdf JDBC driver properties can be set in DbVisualizer in the Properties tab for a connection. Please don't hesitate to get back to us if you need more help. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: Can't connect to Oracle using thin JDBC and SSL
That document gave me a clue: It turns out that the problem is the old version of the Oracle driver shipped with DBVis. Using a newer set of drivers from Oracle solves the problem. SSL With Oracle JDBC Thin Driver Page 18 o Starting in 11.2.0.2.0, the JDBC thin driver has the ability to renegociate the SSL handshake and hence no longer needs to reconnect through a different port. There is a direct handoff by the listener to the server process. This addition to JDBC thin driver was done in the fix for bug 8935561 which was also backported into 11.1.0.7.0 (backport label ST_JAVAVM_BLR_8935561_BACKPORT_11.1.0.7.0).
[This reply is migrated from our old forums.]

Re: Can't connect to Oracle using thin JDBC and SSL
Hi Michael, Great that you found the solution, and thanks for pointing it out. We will look at upgrading the JDBC drivers we bundle with future versions of DbVisualizer. Best Regards, Hans