Looking for approach for database independence

From: <srajeev_at_my-dejanews.com>
Date: Sat, 20 Mar 1999 06:52:17 GMT
Message-ID: <7cvgiv$nvk$1@nnrp1.dejanews.com>

Hi,

I am working on a product which works on a classical three-tier architecture. The GUI, application server and database are the three layers. The application server (old code) is written in C and is bound to oracle OCI calls for data access from Oracle. All database objects (stored procedures and triggers) are written using PL/SQL. I use Oracle 7.3.2 for development.

Now it is required to use Sybase/ Informix as databases. One approach is to have different versions of code (application server and database) for each of the data bases. This option is not desirable.

I am looking for an option, where I can have one single application server code. If required, I am ready to have database-specific code for other databases. I am looking at the option of replacing the OCI calls to XA

calls.	As Oracle, Sybase and Informix are XA-compliant databases, can I
access these databases by making XA calls from the application server.	Do I

requrie a middleware such as Tuxedo Transaction Server for this? I do not have to carry out any two phase-commit etc. My requirement is to just execute stored procedures in databases.

I can't afford to re-write the application server code now, because of complex application logic encapsulated in it.

Can anyone give any suggestions?

Thanks in advance
regards
rajeev
srajeev_at_yahoo.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Mar 20 1999 - 00:52:17 CST