Continuent Community

Hi!

Wiil this software work with Oracle in the future? I am especially interested in the connector and router software.

Also interested in being able to rewrite SQL as to schema specifiers. For example I need to be able to change this SQL:
select * from aaa.table TO: select * from aaa01.table, etc.

Thanks!

Dave Venus

Hi!

Have I posted this to the wrong place? Is it answered some place else (faq, etc.)?

Any help (even flames!), hints, suggestions, etc. gratefully appreciated.

Thanks!

Dave Venus

Hi Dave,

Sorry for the delay--it's been a busy week! At this point it's a bit difficult to get either component to work with Oracle. Here's why.

1.) The router in theory works with Oracle, as it's a wrapper on JDBC. However, it's currently fairly dependent on the Tungsten manager to get status on the databases to which you are connecting. If you are handy with Java and JMX you can make it work.

2.) The connector cannot work with Oracle because you would have to parse the Oracle wire protocol, which is parsed. This tends to invalidate support agreements, so that is a problem. Also, it would be really hard to get it working reliably.

You can read more about both in the docs posted on www.continuent.com. We updated them recently and they have a pretty good description of how things work.

Cheers, Robert