[Pljava-dev] support for 8.0.0rc2?

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>

Responses

Browse pljava-dev by date

  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"