Hi All,

Our company is in phase of moving from Sybase to oracle, which is very long process.

Currently in our application, heart of our data is in Sybase and some new tables are in oracle.

We have three options right now we are aware of.

Use oracle gateway (we are new to it)
Or use Java two data sources or connection object for oracle and Sybase. We do not have issue of transaction management across two databases currently, so we could go path of java 2 data sources.
or use OR software like hibernate.

As we are new to hibernate and a decision has to be made to go for hibernate, I will appreciate if some body could recommend us best solution.
W will have issues like huge data transfer, transaction management etc in future, as it will take years ot fully migrate from sybase to oracle.


Thanks and Regards,
Jill.