From: | david(dot)teran at cluster9(dot)com (David Teran) |
---|---|
To: | |
Subject: | [Pljava-dev] support for 8.0.0rc2? |
Date: | 2004-12-29 09:37:15 |
Message-ID: | 398EDF12-597D-11D9-8ED8-000A95A6F0DC@cluster9.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
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>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Hallgren | 2004-12-29 10:08:46 | [Pljava-dev] support for 8.0.0rc2? |
Previous Message | Thomas Hallgren | 2004-12-16 23:25:02 | [Pljava-dev] ERROR: must be superuser to examine "dynamic_library_path" |