Subject: [Pljava-dev] Passing custom java object to PL/Java
Date: Mon, 17 Oct 2005 12:38:57 -0500
Message-ID: <1B4E0340-B59B-4152-B6AF-3862B5EF1845@rakeshv.org> (raw)
Is it possible to pass custom Java objects to PL/Java (the reverse of
passing from PL/Java to client programs? The error I get seems to
indicate that the custom data type I defined in the deployment
descriptor is not recognised when I do the setType on PGobject.
I tried to do so as shown in the following files:
http://www.rakeshv.org/tmp/test.java - wrapper program that does the
JDBC invocation from client code.
http://www.rakeshv.org/tmp/RecurrenceTest.java - The PL/Java utility
class
http://www.rakeshv.org/tmp/Recurrence.java - The custom data that is
passed from client to server.
http://www.rakeshv.org/tmp/DeploymentDescriptor.ddr - The deployment
descriptor
The following is the stack trace from the program:
org.postgresql.util.PSQLException: Unknown type testType.
at org.postgresql.jdbc2.AbstractJdbc2Statement.setPGobject
(AbstractJdbc2Statement.java:1480)
at org.postgresql.jdbc2.AbstractJdbc2Statement.setObject
(AbstractJdbc2Statement.java:1616)
at org.postgresql.jdbc3.AbstractJdbc3Statement.setObject
(AbstractJdbc3Statement.java:1436)
at org.postgresql.jdbc2.AbstractJdbc2Statement.setObject
(AbstractJdbc2Statement.java:1627)
at test.main(test.java:26)
Rakesh
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] Passing custom java object to PL/Java
In-Reply-To: <1B4E0340-B59B-4152-B6AF-3862B5EF1845@rakeshv.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox