Dear Brian,
Now :THANK YOU
1. I Can Compile and Make Replicator JAR
2. Then I Can Run It with Sample Table
3. The Problem was only the use of ojdbc version, and the use of version Java. The 2.2.3 and 2.2.4 works fine.
Here is the solution:
1. Uninstall All Java SDK and JRE and restart PC
2. Install Java SDK v.1.5x to C:\jdk1.5.0 not to C:\Program File\Java..bla.bla, put ojdbc5 or ojdbc14 in JAVA directory, setpath.bat modification to those path. then Compile! PAWWWW!!! 8 Second created Replicator.jar
3. Setting all conf to Database Server properties,
4. Then Run PubServer.bat.. BAANNNGG!! IT is running.
4. I am success to sync, pull, push, snapshot with some sample table.
5. BUT when i try to Snapshot about 137 Table with Transaction Data approx 500-900 row, it work for some Reference table but it fail to take Snapshot from Table with 2 or more Contraints, but IT'still able to do Pull or Push. Strange isn't it?. Please advise
6. I wonder ...Can we do Create Publication with first Emptying the database,then Snapshot it, then we create the schedule..then we import all data. Rather than do Snapshot with full data exist in tables.
6. And what is the best way, to put "servername" or "IP Number" or "Localhost" in configuration? Please Advise
Thank you Mr. Brian
Best Regards
Oki Sugama
facing the same problem as you
hi
i am trying to get dBReplicator in my win XP system and i get the same error message that you have posted.
"main"class not found
I am using dBReplicator2.2.4
java version installed in C:/ drive not in program files. J2sdk 1.4.2
and version 1.7 placed in the dbReplicator folder.
I am using a mysql.jar file to connect to a mySQL database
i have checked the class path and externally apart from dBreplicator java is working fine and here is my setpath variables
@echo off
@REM Copyright (c) 2008 Regiscope Digital Imaging Co., LLC All rights reserved.
@REM set JAVA_HOME and JDBC_CLASSPATH variables here and remove the REM
@REM For compiling only, path to where ANT is installed
SET ANT_HOME=C:/dbreplicator/ant/bin
@REM The path to where the java installation is
Rem SET JAVA_HOME= C:/java
@REM the classpath, to include any jdbc jar files
Rem SET JDBC_CLASSPATH=C:/dbreplicator/java/DBReplicator.jar;log4j.jar;mysql.jar
@REM The name of this host, as used by others to connect to it
Rem SET SERVER_NAME=my system ip address
@REM The max memory for dbreplicator to use
SET XMX="512m"
when i tried to run the make .bat file i get a message that ant.jar not found and then asking for any key if i press the key it throws ot a couple of status messages
if you can post me the solution it would be greatful for me
thankyou
karthick
some improvement
hi
i have read your previous post and followed the instruction.
When i run the PubServer.bat through cmd prompt i get an error system could not find the file path
i have tried with new installation of java and dbreplicator.I am able to run the ant and create the DBReplicator.jar but after that when i try the pubserver.bat same error in console "main " class not found
thaks for any help
Re:some improvement
Dear Beloved karthie,
I'm sure my conf file below will help you as reference:
---------------------------
@echo off
@REM Copyright (c) 2008 Regiscope Digital Imaging Co., LLC All rights reserved.
@REM set JAVA_HOME and JDBC_CLASSPATH variables here and remove the REM
@REM For compiling only, path to where ANT is installed
SET ANT_HOME="C:\jakarta-ant-1.5"
@REM The path to where the java installation is
SET JAVA_HOME="C:\jdk1.5.0_17"
@REM the classpath, to include any jdbc jar files
SET JDBC_CLASSPATH="DBReplicator.jar;ojdbc14.jar;log4j.jar"
@REM The name of this host, as used by others to connect to it
SET SERVER_NAME="10.10.10.4"
@REM The max memory for dbreplicator to use
SET XMX="512m"
------------------------------------------
rgds
Oki