PDA

View Full Version : DBVisualizer Connection problem



bingo11
February 28th, 2005, 05:38 AM
Hi all,

I have installed DBVisualizer few days ago and have had some problems
connecting to a remote database. My jre is the following version :
java version "1.5.0_01"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_01-b08)
Java HotSpot(TM) Client VM (build 1.5.0_01-b08, mixed mode, sharing)

My SQL connector is 3.0.9. This is the connector i use with Fedora 3
from work to connect to that same database with DBvisualizer.

The mysql version i am trying to connect to is : mysql Ver 11.18
Distrib 3.23.58, for redhat-linux-gnu (i386)

When trying to connect the "Connecting. wait..." is displayed for a
while in the connection message area, then a debug window pops up
with the following message :

java.sql.SQLException: Unable to connect to any hosts due to
exception: java.net.ConnectException: Connection timed out
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:1797)
at com.mysql.jdbc.Connection.<init>(Connection.java:562)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:361)
at java.sql.DriverManager.getConnection(DriverManager .java:512)
at java.sql.DriverManager.getConnection(DriverManager .java:140)
at com.onseven.dbvis.wrapper.DriverManagerImpl.getCon nection(DriverManagerImpl.java:40)
at com.onseven.dbvis.sql.Database.doConnect(Unknown Source)
at com.onseven.dbvis.sql.Database.access$000(Unknown Source)
at com.onseven.dbvis.sql.Database$ConnectionCommand.e xecute(Unknown Source)
at se.pureit.util.ThreadCommand.runExecute(ThreadComm and.java:163)
at se.pureit.util.ThreadCommand.run(ThreadCommand.jav a:143)
at java.lang.Thread.run(Thread.java:534)
java.sql.SQLException: Unable to connect to any hosts due to
exception: java.net.ConnectException: Connection timed out
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:1797)
at com.mysql.jdbc.Connection.<init>(Connection.java:562)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:361)
at java.sql.DriverManager.getConnection(DriverManager .java:512)
at java.sql.DriverManager.getConnection(DriverManager .java:140)
at com.onseven.dbvis.wrapper.DriverManagerImpl.getCon nection(DriverManagerImpl.java:40)
at com.onseven.dbvis.sql.Database.doConnect(Unknown Source)
at com.onseven.dbvis.sql.Database.access$000(Unknown Source)
at com.onseven.dbvis.sql.Database$ConnectionCommand.e xecute(Unknown Source)
at se.pureit.util.ThreadCommand.runExecute(ThreadComm and.java:163)
at se.pureit.util.ThreadCommand.run(ThreadCommand.jav a:143)
at java.lang.Thread.run(Thread.java:534)

I would really appreciate if you could give me any pointers about how
to resolve this problem.

Thank you for your cooperation,

Madi

mrhacim
February 19th, 2007, 02:11 PM
I was having the same problem here. I found that I had unknowingly upgraded to java 6. I was trying to connect to MS Sql Server and DbVis was using the java 6 version of the driver and it seems that this driver was causing the exception. So I loaded in my old driver and it worked just like before.

Hope that helps.