[Pljava-dev] support for 8.0.0rc2?

[David Teran]

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://pgfoundry.org/pipermail/pljava-dev/attachments/20041229/908b53bf/attachment.bin