Calling Stored Proc From Java with Complex Types

From: Jason Tesser <jasontesser(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Calling Stored Proc From Java with Complex Types
Date: 2010-02-15 15:59:45
Message-ID: 98bbb46a1002150759r7e4bb875pb86c98140894ecd0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I am trying to call a Stored Procedure that takes Complex Types.

For example the function is declared as
FUNCTION person_save(person_to_save person, addresses address[], emails
email[], numbers phone[])

person, address etc... are all tables in Postgres.

How do I do this from Java?

I was trying to use Spring
http://forum.springsource.org/showthread.php?t=84731

Do I need to create a type mapping or is there something in the Driver I can
use?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Richard Rowell 2010-02-15 16:08:46 Re: Timestamp confusion
Previous Message Gregory Kotsaftis 2010-02-15 07:48:27 Re: [BUGS] Possible bug with BYTEA and JDBC