agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] support for 8.0.0rc2?
4+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] support for 8.0.0rc2?
@ 2004-12-29 09:37
0 siblings, 2 replies; 4+ messages in thread
From: @ 2004-12-29 09:37 UTC (permalink / 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;
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] support for 8.0.0rc2?
@ 2004-12-29 10:08
parent:
1 sibling, 0 replies; 4+ messages in thread
From: @ 2004-12-29 10:08 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] support for 8.0.0rc2?
@ 2004-12-29 10:58
parent:
1 sibling, 1 reply; 4+ messages in thread
From: @ 2004-12-29 10:58 UTC (permalink / raw)
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
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] support for 8.0.0rc2?
@ 2004-12-30 09:49
parent:
0 siblings, 0 replies; 4+ messages in thread
From: @ 2004-12-30 09:49 UTC (permalink / raw)
David,
I'll look into this soon, hopefully over the weekend. I don't have
access to a MacOS X based machine though.
- thomas
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-12-30 09:49 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-29 09:37 [Pljava-dev] support for 8.0.0rc2?
2004-12-29 10:08 `
2004-12-29 10:58 `
2004-12-30 09:49 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox