SupportSupport

trying to connect to a db. get this

Product: DbVisualizer Free 5.0
Build: #1120 (2006/04/04 14:55)
Java VM: Java HotSpot(TM) Client VM
Java Version: 1.5.0_06-b05
Java Vendor: Sun Microsystems Inc.
OS Name: Windows XP
OS Arch: x86
OS Version: 5.1

An error occured while establishing the connection.
Type: com.mysql.jdbc.CommunicationsException Error Code: 0 SQL State: 08S01
Message:
Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection timed out: connect

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection timed out: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.onseven.dbvis.wrapper.DriverManagerImpl.getConnection(Unknown Source)
at com.onseven.dbvis.sql.M.Į(Unknown Source)
at com.onseven.dbvis.sql.M.access$200(Unknown Source)
at com.onseven.dbvis.sql.M$A.execute(Unknown Source)
at se.pureit.util.ThreadCommand.runExecute(ThreadCommand.java:163)
at se.pureit.util.ThreadCommand.run(ThreadCommand.java:143)
at java.lang.Thread.run(Unknown Source)

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.

driver is set properly.

Database url i am using
jdbc:mysql://<host>:<port3306>/<database>

so i'm doing something like
jdbc:mysql//localhost:3306/a2i

host is research.calit2.net

suggestions?

tried jdbc:mysql://research.calit2.net:3306/a2i

still the same error.

i am able to telnet in . ie. it does set up a connection

i usually just ssh into the server

also i do have the extra colon after mysql when i try to connect. i missed it when i typed it in the post to you

Hi,

Open Tools->Driver Manager, select the MySQL driver you are using. What does the Driver Class list show as the current class?

Regards

Roger

Hi,

Thanks.

The error comes from the JDBC driver when it tries to setup the communication with the database. If telneting works fine then I cannot directly see what is wrong. Maybe you should check/ask in the MySQL J/Connector forums.

http://forums.mysql.com/list.php?39

Regards

Roger