Re: oracle listener intercept

On Sep 13, 2006, at 9:46 PM, David Link wrote:
> I'm looking at replacing an Oracle database that only has a few
> tables, but that is accessed by many programs in the company via
> oracle jdbc drivers, oracle odbc drivers and python database
> interface.
>
> Is there a way to intercept the calls to the oracle listener and
> redirect to postgres without changing the calling application?

None that I know of, but all of those should happily be able to point
at a PostgreSQL database (at least jdbc and odbc, since it's what
they're designed for; I'm assuming python can do it too).

A bigger issue you're likely to run into is that unless your programs
are using only the barest, simplest commands you're likely to run
into syntax compatibility issues. If that's the case you'll either
need to port the code (there is a tool out there somewhere that might
help with that), or you can try our (commercial) product.
--
Jim Nasby                                    jimn@enterprisedb.com
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)