From: rakesh at rakeshv.org (Rakesh Vidyadharan)
Date: Mon, 17 Oct 2005 12:38:57 -0500
Subject: [Pljava-dev] Passing custom java object to PL/Java
Message-ID: <1B4E0340-B59B-4152-B6AF-3862B5EF1845@rakeshv.org>

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