I use DBReplicatior 2.2.3 to create Publication that refer to a MySQL Database. I start Pub Server with the following configuration:
Driver: com.mysql.jdbc.Driver
URL: jdbc:mysql://localhost:3306/chendatabase
User Name: my database's user name
Password: my database's user name
IP Address: my machine's IP Address
Server Port No.: 3001
After I started Pub Server, I try to create a publication follow the wizard. But when I after the configruation of publication and press finish button, I got a error message, it is:
org.dbreplicator.replication.RepException:
Could not publish the publication 'Publication 'Comm_PUB' is already published.':{1}
But there isn't any publications. I want to know why, does DBReplicatior can not support MySQL Well, or there are other reasons for this problem? Is there any work arroung method?
Thank you very much
Kelvin Chen
This jar file should fix it
This jar file should fix it for you. I'm still testing before I create a 2.2.4 dbreplicator release.
Error when starting pubserver.bat
Dear Brian, Although all config file has i set already, i wanna make Oracle 9i to Oracle 9i between 2 PC;same database name;same OS windows XP; i m using classes12.jar from Oracle directory C:\oracle\ora90\jdbc\lib; i install JDK 1.4.2 and JRE.;i got error when opening the pubserver windows (as seen in attachment):
Exception in thread “main” java.lang.UnsupportedClassVersionError: org/dbreplicator/repconsole/StartServer (Unsupported major.minor version 49.0)
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:509)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:246)
at java.net.URLClassLoader.access$100(URLClassLoader.java:54)
then the pubserver windows disappear after 1 second and nothing happen.
My Questions are:
1. What is the solution for this?
I was success replicating database using Daffodil Replicator v.2.1 eventhough it's not support TIMESTAMP datatype.
2. is DBReplicator support Oracle DATE datatype for replication?
Please advise
Thanks Brian
Best Regards
Oki Sugama
Re: Error when starting pubserver.bat
If it worked on Daffodil, it should work at least as well with DBReplicator. I haven't tried running on JDK 1.4.2 in a long time. It's compiled on 1.5, so you might start by trying that. If you have a problem with a datatype in Oracle, I'll have a look at it. Should be no problem to support it, but I'd have to check to be sure.
Brian