agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] Re: postgresql jdbc driver
Date: Thu, 24 Feb 2005 21:03:49 +0100
Message-ID: <421E3325.6080008@mailblocks.com> (raw)
In-Reply-To: <421E20CA.8000001@cbm.on.ca>
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>
<421E20CA.8000001@cbm.on.ca>
Bart,
> So why do you also need the jdbc3-810 driver?
>
I realize that I might have misread what you asked for. But if the
requirements that he listed was an answer to "why they use the jdbc3-810
driver as a complement (or instead of?) the PLJava driver", then his
answer just make no sense at all:
> # Full support of ANSI SQL 99 (CASE, all JOIN types, ..)
Neither of the JDBC drivers are concerned with this.
> # Support of Views and Views on Views
Neither of the JDBC drivers are concerned with this.
> # Support of User Defined Functions
> (preferably via SQLJ - Java running in the database)
PLJava *is* user defined functions and it's JDBC driver allows you to
call other JDBC driver functions through SQL. Neither of the JDBC
drivers are concerned with SQLJ.
> # Inline Views (e.g. SELECT ... FROM (SELECT xx FROM yy) ..)
> # JDBC 3.0 Support (especially RowSet)
>
As stated before, RowSet's just makes no sense at all in the PLJava
domain, i.e. inside of a user defined function running inside the
database backend.
A final note and I'm not at all sure it's in any way applicable:
Using the client jdbc driver inside of PLJava is a *very* bad idea since
it would result in a new remote connection to the backend and hence, not
only severely degraded performance but also a different transaction. The
PLJava jdbc driver runs within the transaction that was started by the
caller of the user defined function. Virtually everything will break if
your violate transaction boundaries.
Regards,
Thomas Hallgren
view thread (3+ messages)
Message-ID: <421E3325.6080008@mailblocks.com>
Permalink: ../421E3325.6080008@mailblocks.com/
Also on: postgresql.org/message-id/421E3325.6080008@mailblocks.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] Re: postgresql jdbc driver
In-Reply-To: <421E3325.6080008@mailblocks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox