agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Limitation in statement parameters
Date: Wed, 11 Aug 2004 11:31:43 +0200
Message-ID: <thhal-0N4H1AWUgWQIOkrdkoAgwLvbiLhgxwo@mailblocks.com> (raw)
In-Reply-To: <I29ZFF$DEC2CCC59406E041D92B4B380D486C24@libero.it>

Hi Mario,
> We are very interested on your pl/java product.
> We've succesfully imported our Oracle java stored procedure into
> Postgresql
> pl/java.
>
Cool. This is good news.
 
> In  SPIconnection the translation from JDBC statement to postgresql
> statement
> can't have  more than 10 paramenters due to the use of single char.
> You will get "$:" instead of "$10" and so on.
>
Ouch! I'll fix that promptly.
 
> Another little thing, in Oracle we use "jdbc:default:connection:" not
> "jdbc:default:connection".
> It's similar but not the same.
>
Ok, it will be easy enough to allow both. I'll fix that too.

> But we commented out the EOXactregister/unregister reference since it was
> unreferenced in  resulting libpljava.so.
> 
Yes, I discovered that yesterday evening. The latest CVS contains work that
is intended for 8.0. I will fix it for 7.4 soon. Meanwhile, if you want to
play around with the latest and greatest, you need a PostgreSQL 8.0 beta.
Using it, you will benefit from new features such as the ability to
configure the JVM from the postgresql.conf or via SET commands (through
custom configuration variables). It also has much improved exception
handling.

> We use  use RH9, Postgresql 7.4.3 and JSDK1.4.2.
> 
> We look forward for the new release and appreciate your good work.
> 
Thanks a lot. It's always encouraging to hear positive news.

Regards,

Thomas Hallgren

view thread (3+ messages)  latest in thread

Message-ID: <thhal-0N4H1AWUgWQIOkrdkoAgwLvbiLhgxwo@mailblocks.com>
Permalink:  ../thhal-0N4H1AWUgWQIOkrdkoAgwLvbiLhgxwo@mailblocks.com/
Also on:    postgresql.org/message-id/thhal-0N4H1AWUgWQIOkrdkoAgwLvbiLhgxwo@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] Limitation in statement parameters
  In-Reply-To: <thhal-0N4H1AWUgWQIOkrdkoAgwLvbiLhgxwo@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