From: | Roshan Nair <roshan(at)netcore(dot)co(dot)in> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Passing an array or record to a stored procedure through jdbc |
Date: | 2005-12-09 06:59:45 |
Message-ID: | 43992B61.8030503@netcore.co.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi all,
I'm using Postgresql 8.1 with driver postgresql-8.1-404.jdbc3.jar . Our
project depends a lot on stored procedures(pl/pgsql). We need to pass
arrays, records and in some cases array of records as a parameter to
the stored procedure. I've searched the mailing lists and googled a lot
but found no solution. For now, we are passing a varchar of
comma-separated values and parsing this in the stored procedure. But
this solution becomes non-trivial when we are using array of records.
I would like to know if we can pass/return arrays and records using jdbc
to/from postgres stored procedures. I guess even multidimensional arrays
are fine, if we cant have records.
Is it possible to implement and add our own array types or record types
easily?(I'm a beginner-intermediate jdbc user).
The jdbc.postgres home page seems to say array support is a feature for
8.2, but the 8.1-404 jdbc driver already contains array type.
Regards,
Roshan Nair
----------------------------------------------------------
Netcore Solutions Pvt. Ltd.
Website: http://www.netcore.co.in
Spamtraps: http://cleanmail.netcore.co.in/directory.html
Support FAQ : http://support.netcore.co.in/
----------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paesold | 2005-12-09 09:41:41 | Re: Problem with 8.1 driver |
Previous Message | Kishore Kolli | 2005-12-08 21:58:51 | org.postgresql.util.PSQLException: An I/O error has occured while flushing the output |