Hi. I've managed to create a publisher in a debian based server that connects to a Sql server machine
I've also managed to create a subscription in another debian server, using a MySQL database.
I'm using
When I try to pull or snaptshot, I get this error:
Problem in synchronizing data due to -- 'Line 1: Incorrect syntax near 'work'.'.
Can anyone help?
Thanks
Miguel
14:50:20,514 DEBUG [CommonMetaDataInfo] [appendPrimaryConstraints 583] Primary Key (ID )
14:50:20,526 DEBUG [CommonMetaDataInfo] [appendCheckConstraints 683] Primary Key (ID ) , Check ( ID is not null )
14:50:20,559 DEBUG [Publication] [createStructure 539] wrote XMLFile ClientSocket
14:50:40,295 DEBUG [Publication] [checkForLock 1642] locking for subscription::sub2
14:50:40,307 ERROR [SyncXMLCreator] [createXMLFile 243] Line 1: Incorrect syntax near 'work'.
java.sql.SQLException: Line 1: Incorrect syntax near 'work'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1163)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1116)
at org.dbreplicator.replication.xml.SyncXMLCreator.createXMLFile(SyncXMLCreator.java:116)
at org.dbreplicator.replication.Publication.createXMLForClient(Publication.java:844)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:305)
at sun.rmi.transport.Transport$1.run(Transport.java:159)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
org.dbreplicator.replication.RepException:
Problem in synchronizing data due to -- 'Line 1: Incorrect syntax near 'work'.'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1163)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1116)
at org.dbreplicator.replication.xml.SyncXMLCreator.createXMLFile(SyncXMLCreator.java:116)
at org.dbreplicator.replication.Publication.createXMLForClient(Publication.java:844)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:305)
at sun.rmi.transport.Transport$1.run(Transport.java:159)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
14:50:40,346 DEBUG [Publication] [releaseLOCK 1681] isLocked :false
I am also trying to set up a
I am also trying to set up a replication between MS SQL Server 2000 and MySQL version 5.I managed to get it to work in our test envrionment, but it doesn't work when replicating to our customer. I set up an ODBC-connection using MyODBC 3.51 and then enabled it as an ODBC-subscriber in SQL Server. When I create the subscriber, I get an 'Invalid cursor state' error in the distribution agent.
In our test envrionment, I got it to work by dropping the MSRepl7 table that SQL Server creates in the MySQL-database. I don't know why it starts to work, but I don't care ;-) However, when I try the same trick with our customer, it still gives the same error. That it is a bug in the ODBC Driver Manager, but there are also cases in which it works (as in our test case). I tried everything, changing testkings options in MySQL, SQL Server, MyODBC, installing MyODBC 5, but nothing solves this problem. I am running out of ideas, can anyone help me?