Hi,

I have a view in oracle which needs to be replicated in Hsqldb through hibernate on
start up of tomcat and at certain specified intervals.

for ex:Consider a oracle_view in oracle
Name City PhNo
ABC Pune 1234
DEF Mumbai 2345

Now on start up of tomcat the hibernate_view in hibernate is empty
so the follwong data from oracle_view in oracle is replicated to
hibernate_view in hibernate.

so hibernate_view consists of

Name City PhNo
ABC Pune 1234
DEF Mumbai 2345

Now consider that the data in oracle_view in oracle is changed as shown
below

Name City PhNo
ABC Pune 1234
DEF Mumbai 5656 <!--this is the changed row-->

Now at the specified time interval this change needs to be replicated in
hibernate_view in hibernate

So i delete the entire data of hibernate_view and copy the data from oracle_view
to the hibernate_view.This works fine if the data to be replicated is small but in
case of huge data ,I need some mechanism through which i need not delete the entire data of
hibernate_view and replicate only the changed row of oracle_view in the
hibernate_view.

Thus in short,
1)I need an efficient mechanism for replicating data the first time i.e on start up of tomcat
2)An efficient way for differential replication i.e replicating only the changed rows at the
specified intervals.

Thanks & Regards,
AKshay

Have a look at the following link. See if it helps.

http://www.hibernate.org/hib_docs/v3/re ... eplicating