How to abstract fully from database with JDBC? - Mailing list pgsql-interfaces

From Alexey V. Meledin
Subject How to abstract fully from database with JDBC?
Date
Msg-id 11956.000506@webclub.ru
Whole thread Raw
List pgsql-interfaces
Hi!

I need to make my interface compatible with PostgreSQL 6.5.3. and
MSSQL 7.0 with possible little changes in interface source code.

So (verify me, please):
1. For simple SELECT - I use VIEWs
2. When I use function .... Hmmm... What to do in this CASE.

PL/pgsql defines function call as SELECT function(), but MSSQL defines
it like "exec procedure".
Documentation on JDBC PostgreSQL driver says, that I need to use
Postgres Specific code to call a function...

So my interface will be incompatible?

Regards, Alexey V. Meledin
InterForge Developers Group, Saint-Petersburg




pgsql-interfaces by date:

Previous
From: Joe Shevland
Date:
Subject: Re: Slow Recordset
Next
From: "Oscar Serrano"
Date:
Subject: postgres crash. HELP