[EMAIL PROTECTED] ("Martin Matusiak") wrote:
> Would it be possible to create some sort of transparent API based on
> ODBC to be used with PostgreSQL and Oracle? I know there exists a
> JDBC - ODBC bridge for java.If you wrote your application exclusively using JDBC using functions existing in both PostgreSQL and Oracle, you'd certainly have a "lowest common denominator" that would satisfy this requirement. You would be taking advantage neither of PostgreSQL's strengths nor of Oracle's strengths, which is considerably wasteful on both sides of the coin. You would have to design your application so that it does not use either system's stored procedure systems, because they are not totally interoperable. You would have to ensure that your access patterns were concurrently compatible with Oracle rollback buffers and PostgreSQL MVCC. At the end of all this, you more than likely have an application that will perform questionably in both places... -- If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne> rate me http://www3.sympatico.ca/cbbrowne/lsf.html Would-be National Mottos: USA: "There oughta' be a law!" ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
