[Pljava-dev] support for 8.0.0rc2?

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>

David,
This problem is new to me. Can you give me information about your
platform? What operating system are you on and what JVM are you using?

Regards,
Thomas Hallgren

Hi,

i am using MacOS X Server 10.3.7

output from java -version:

java version "1.4.2_05"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_05-141.3)
Java HotSpot(TM) Client VM (build 1.4.2-38, mixed mode)

pljava 1.0.0b6, build like this:

export PATH=$PATH:/Users/postgres/PostgreSQL/bin
make
sudo make install

jdbc3 driver (pg80b1.308.jdbc3.jar) is installed in
/Library/Java/Extensions

I have had problems using the system classpath settings in the
postgresql.conf file:

# pljava
pljava.classpath = '/Users/postgres/pljava-1.0.0b6/build/pljava.jar'
custom_variable_classes = 'pljava'

I had to use the single quote for pljava.classpath

hope this helps.

regards David

On 29.12.2004, at 11:08, Thomas Hallgren wrote:

> David,
> This problem is new to me. Can you give me information about your
> platform? What operating system are you on and what JVM are you using?
>
> Regards,
> Thomas Hallgren
>
>
>

David,
I'll look into this soon, hopefully over the weekend. I don't have
access to a MacOS X based machine though.

- thomas