Subject: [Pljava-dev] support for 8.0.0rc2?
Date: Wed, 29 Dec 2004 10:37:15 +0100
Message-ID: <398EDF12-597D-11D9-8ED8-000A95A6F0DC@cluster9.com> (raw)
Hi,
i am having problems getting pljava 100b6 to run with pgsql 800rc2.
Calling
SELECT
sqlj.install_jar('file:///Users/postgres/pljava-1.0.0b6/build/
examples.jar', 'samples', true);
fails with (i have added some system.out.println to check the
parameters)
jarName = samples
urlString = file:///Users/postgres/pljava-1.0.0b6/build/examples.jar
LOG: Exception
LOG: in thread "main"
java.sql.SQLException: Number of values does not match number of
arguments for prepared plan
at
org.postgresql.pljava.internal.ExecutionPlan._cursorOpen(Native Method)
at
org.postgresql.pljava.internal.ExecutionPlan.cursorOpen(ExecutionPlan.ja
va:112)
at
org.postgresql.pljava.jdbc.SPIStatement.executePlan(SPIStatement.java:
101)
at
org.postgresql.pljava.jdbc.SPIPreparedStatement.execute(SPIPreparedState
ment.java:251)
at
org.postgresql.pljava.jdbc.SPIPreparedStatement.executeUpdate(SPIPrepare
dStatement.java:72)
at
org.postgresql.pljava.management.Commands.installJar(Commands.java:175)
ERROR: java.sql.SQLException: Number of values does not match number
of arguments for prepared plan
When i quit psql and start it again, invoking the same command fails
with this error message:
jarName = samples
urlString = file:///Users/postgres/pljava-1.0.0b6/build/examples.jar
LOG: Exception
LOG: in thread "main"
java.sql.SQLException: Unable to obtain id of 'samples'
at
org.postgresql.pljava.management.Commands.installJar(Commands.java:186)
ERROR: java.sql.SQLException: Unable to obtain id of 'samples'
Any clues? pljava seems to be very interesting for our applications.
regards, David
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 1742 bytes
Desc: not available
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20041229/908b53bf/attachment.bin;
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] support for 8.0.0rc2?
In-Reply-To: <398EDF12-597D-11D9-8ED8-000A95A6F0DC@cluster9.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox