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:23:39 +0200
Message-ID: <I29ZFF$DEC2CCC59406E041D92B4B380D486C24@libero.it> (raw)

Hi Thomas, 

We are very interested on your pl/java product.
We've succesfully imported our Oracle java stored procedure into Postgresql
pl/java.

We found noly some limitation on your code, not very critical  since it
is open-source.

I will get straight to the problem. 
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.

Another little thing, in Oracle we use "jdbc:default:connection:" not
"jdbc:default:connection".
It's similar but not the same.
It wasn't simple to notice this "little" difference due to the  "No suitable
driver" error.

Of course i was using the latest CVS version since we succesfully compiled
and installed it.
But we commented out  the EOXactregister/unregister reference since it was
unreferenced in  resulting libpljava.so.

We use  use RH9, Postgresql 7.4.3 and JSDK1.4.2.

We look forward for the new release and appreciate your good work.


regards

Mario Pandolfi

Octotelematics Srl
Via Veneto, 7 
Rome
Italy

view thread (3+ messages)  latest in thread

Message-ID: <I29ZFF$DEC2CCC59406E041D92B4B380D486C24@libero.it>
Permalink:  ../I29ZFF$DEC2CCC59406E041D92B4B380D486C24@libero.it/
Also on:    postgresql.org/message-id/I29ZFF$DEC2CCC59406E041D92B4B380D486C24@libero.it

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: <I29ZFF$DEC2CCC59406E041D92B4B380D486C24@libero.it>

* 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