Test Connection to Target Database Fails
Posted by: Dan Blows
Date: November 06, 2005 01:05AM

Hi all

What I'm trying to do: I am using an Access database on my machine, which I often need to update offline as I do a lot of work where there is no internet connection. Therefore I need a solution to synchronise my offline Access database with my online MySQL database.

I have installed MySQL server and set up Access as a front end to that database. However, what I can't do is synchronise the offline MySQL with the online version.

When I use the toolkit, it finds the source database, but the online version comes up wtih the following error:

Initializing JDBC driver ...
Driver class MySQL JDBC Driver 3.1
Opening connection ...
Connection jdbc:mysql://blowski.com:2082/?user=<my username>&password=<my password>&useServerPrepStmts=false
The connection to the target database could not be established (error: 0).
ReverseEngineeringMysqlJdbc.getVersion :Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1903)
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:483)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:965)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2544)
at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
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.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(Unknown Source)
at com.mysql.grt.modules.ReverseEngineeringGeneric.getVersion(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.mysql.grt.Grt.callModuleFunction(Unknown Source)


** END NESTED EXCEPTION **



Last packet sent to the server was 47 ms ago.
Details:
com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:554)
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:965)
com.mysql.jdbc.Connection.createNewIO(Connection.java:2544)
com.mysql.jdbc.Connection.<init>(Connection.java:1474)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.getVersion(Unknown Source)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)

This is probably a fairly obvious error, but I am very much a noob to all this. Any pointers would be greatly appreciated :)

Many thanks
Dan

Options: ReplyQuote


Subject
Written By
Posted
Test Connection to Target Database Fails
November 06, 2005 01:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.