Received: from holmes.infopro.spb.su (holmes.infopro.spb.su [195.242.2.2]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA99584 for ; Sat, 6 May 2000 14:54:45 -0400 (EDT) (envelope-from avm@webclub.ru) Received: from barrymore.peterlink.ru (barrymore.peterlink.ru [195.242.2.8]) by holmes.infopro.spb.su (8.9.1/8.9.1) with ESMTP id WAA21872 for ; Sat, 6 May 2000 22:54:44 +0400 (MSD) Received: from turtle.interforge.ru (interforge.dialup.peterlink.ru [195.242.31.96]) by barrymore.peterlink.ru (8.9.1/8.9.1) with ESMTP id WAA01354 for ; Sat, 6 May 2000 22:54:43 +0400 (MSD) Date: Sat, 6 May 2000 22:57:53 +0400 From: "Alexey V. Meledin" X-Mailer: The Bat! (v1.36) S/N F29DEE5D / Educational Reply-To: "Alexey V. Meledin" Organization: InterForge Developers Group, Spb X-Priority: 3 (Normal) Message-ID: <11956.000506@webclub.ru> To: pgsql-interfaces@postgresql.org Subject: How to abstract fully from database with JDBC? Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200005/65 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