PostgreSQL array vs. JDBC vs. Hibernate

From: Ricardo Vaz Mannrich <rvm_l1(at)silcom(dot)com(dot)br>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: PostgreSQL array vs. JDBC vs. Hibernate
Date: 2006-07-13 13:50:41
Message-ID: 44B64FB1.3010802@silcom.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

What is the better way to read and write PostgreSQL array columns with JDBC?

If I have this table:

CREATE TABLE test (
test_id INTEGER NOT NULL PRIMARY KEY,
test_arr VARCHAR[]
);

How can I use PreparedStatements to write test_arr column? What is the
better way to read it?

And most important: how can I do this with Hibernate? I tryed to use a
single Strind column. It's possible to read but I cant write. I'm using
8.1.3.

Thanks.

--
Ricardo

Browse pgsql-jdbc by date

  From Date Subject
Next Message Markus Schaber 2006-07-13 14:58:36 Re: CLASS EXCEPTION org.postgresql.Driver
Previous Message Folorunsho, Abayomi 2006-07-13 10:14:49 CLASS EXCEPTION org.postgresql.Driver