From: gen_mgr at cbm.on.ca (Bart Bremmers)
Date: Thu, 24 Feb 2005 13:45:30 -0500
Subject: [Pljava-dev] postgresql jdbc driver
In-Reply-To: <thhal-0k9T3AqPYxicqnRYG9AviDakRnHkMDj@mailblocks.com>
References: <ICCLWN$0040A8FD36E7EE4B959BA9914F0E5656@uol.com.br>
	<421C3C10.2070005@mailblocks.com>
	<thhal-0ktT3Ap/YxichWbt4tRose+2vMMw/sH@mailblocks.com>
	<thhal-0ktT3AqHYxiclynf8nRR0PpkdURjG6u@mailblocks.com>
	<thhal-0k9T3AqPYxicqnRYG9AviDakRnHkMDj@mailblocks.com>
Message-ID: <421E20CA.8000001@cbm.on.ca>

Hi Thomas
I asked the person working on Compiere with PLJava the following:

The PLJava web site says it comes with:
"An embedded, high performance, JDBC driver utilizing the internal 
PostgreSQL SPI routines."
So why do you also need the jdbc3-810 driver?

His answer:

       Yes, I know PLJAVA has a JDBC Native, the main problem is 
Compiere 252 has the following requirements:

       # Full support of ANSI SQL 99 (CASE, all JOIN types, ..)
       # Support of Views and Views on Views
       # Support of User Defined Functions
       (preferably via SQLJ - Java running in the database)
       # Inline Views (e.g. SELECT ... FROM (SELECT xx FROM yy) ..)
       # JDBC 3.0 Support (especially RowSet)

       http://www.compiere.org/technology/database/index.html

Can you comment Thomas?


BTW, I noticed that the reply-to defaults to the senders email, not 
pljava-dev at gborg.postgresql.org. So if you are not careful, not all 
messages will be seen by everyone on the list.

=========================
Bart Bremmers, Gen. Mgr.
Craft-Bilt Materials Ltd.
Markham, Ontario