1 message in org.postgresql.pgsql-jdbcPostgreSQL array vs. JDBC vs. Hibernate
FromSent OnAttachments
Ricardo Vaz MannrichJul 13, 2006 6:50 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:PostgreSQL array vs. JDBC vs. HibernateActions...
From:Ricardo Vaz Mannrich (rvm@silcom.com.br)
Date:Jul 13, 2006 6:50:18 am
List:org.postgresql.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