Re: Looking for approach for database independence

Try perl with the DBI library.

srajeev_at_my-dejanews.com wrote:

> 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 Mon Mar 22 1999 - 07:13:56 CST