Everything just fine and easy when i setup Oracle to Oracle (Now TIMESTAMP syncron nicely)
with Daffodil v2.1, here is my step when i'm with Daffodil Replicator:
-> Download Daffodil
-> Extract to C:\DaffodilReplicator2_1
-> install Java SDK 1.4
-> Modify SetPath.bat,config.ini
-> Put ojdbc14 or ojdbc5 or ojdbc 6 beside log4j.jar and Replicator.jar
-> Run PubServer.bat
-> Create Publication with some Oracle Table for testing
-> run SubServer.bat
-> Create Subscription
-> Create Snapshot
-> Add Schedule (realtime)
All worked very nicely and easily in Daffodil event previously i have TIMESTAMP error,
but it solved. it caused I am not FULL IMPORT the my oracle dump file, but after I expand
the size of Tablespace then the TIMESTAMP syncronize very well.
But when there is an error when i try get Snapshot table with some Foreign Key.
with notification : Problem ..ORA-02292:integrity constraint ...violated-child record found .why?How to resolve that?
the Daffodil and Java SDK 1.4 and JRE 1.4 still installed, then
i was trying DBReplicator v224 with step same as it with Daffodil:
-> Download DBReplicator
-> Extract to C:\dbreplicator
-> install jakarta-ant 1.5, Java SDK 1.5.017, event java SDK 1.6.011, and those JRE
-> Modify SetPath.jar, in the folder C:\dbreplicator\java like this:
----------------------------------------------------------------------------
SET ANT_HOME=C:\dbreplicator\jakarta-ant-1.5
SET JAVA_HOME=C:\Program Files\Java\jdk1.6.0_11
SET JDBC_CLASSPATH=C:\dbreplicator\java\DBReplicator.jar;ojdbc6.jar;log4j.jar
----------------------------------------------------------------------------
-> Modify all config in C:\dbreplicator\config like this:
-------------------------------------
VendorType=Oracle
DataBaseName=simhrd
Driver=oracle.jdbc.driver.OracleDriver
Url=jdbc:oracle:thin:@localhost:1521:simhrd
UserName=hrd
Password=mysticriver
------------------------
-> Put ojdbc14 or ojdbc5 or ojdbc 6 beside log4j.jar and Replicator.jar
-> Run (doubleclick PubServer.bat)
-> IT DOESN'T work (the window of PubServer.bat comes 1 second and gone..just gone..nothing happened)
-> wanna self compile with Running (doubleclick make.bat)
-> IT DOESN'T work (the window of PubServer.bat comes 1 second and gone..just gone..nothing happened)
P L E A S E H E L P
Thanks
Oki Sugama
Re: Why DBReplicator never works on my Windows XP
You seem to be missing some entries in setpath.bat. I've included the sample from the source tree, just to make sure you have the latest version.
You've got
----------------------------------------------------------------------------------------------
SET ANT_HOME=C:\dbreplicator\jakarta-ant-1.5
SET JAVA_HOME=C:\Program Files\Java\jdk1.6.0_11
SET JDBC_CLASSPATH=C:\dbreplicator\java\DBReplicator.jar;ojdbc6.jar;log4j.jar
----------------------------------------------------------------------------------------------
but it should be more like
----------------------------------------------------------------------------------------------
SET ANT_HOME=C:\dbreplicator\jakarta-ant-1.5
SET JAVA_HOME=C:\Program Files\Java\jdk1.6.0_11
SET JDBC_CLASSPATH=C:\dbreplicator\java\DBReplicator.jar;ojdbc6.jar;log4j.jar
SET SERVER_NAME=<This Host Name, resolvable by hosts file or DNS>
SET XMX="512m"
----------------------------------------------------------------------------------------------
As far as this is concerned:
> But when there is an error when i try get Snapshot table with some Foreign Key.
> with notification : Problem ..ORA-02292:integrity constraint ...violated-child record found .why?How to resolve that?
It sounds like you're trying to replicate a table with a foreign key constraint to a non-replicated table. From the limited error message, it sounds like it's failing to insert a record in the child table because the appropriate foreign key is not present in the parent table. It *SOUNDS* like you've managed to get replicator to replicate a child table without the parent table (which it shouldn't let you do), or you've got a foreign key dependency in the subscriber database that you don't have in the publisher database.
There are several ways to handle this
If that doesn't help, I promise to find my windows machine, dust it off, plug it in and try DBReplicator on XP again.
Compiled Successfully but doesn't work
Dear Brian,
Thanks for your assistant, now i am able to compile successfully, but when i start PubServer it just the same open and disappear.
please specify which java package should i download from sun website, with jdk1.6.0_11 doesnt work...with jdk1.5xx doesnt work too.
you are right in handling multiple FK in tables. still using Daffodil v2.1. but it's work!
Please advise
Thanks
Oki
Re: Compiled Successfully but doesn't work
I'll have a go at running on windows and get back to you.
B