Unix Technical Forum

PostgreSQL array vs. JDBC vs. Hibernate

This is a discussion on PostgreSQL array vs. JDBC vs. Hibernate within the pgsql Interfaces jdbc forums, part of the PostgreSQL category; --> What is the better way to read and write PostgreSQL array columns with JDBC? If I have this table: ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces jdbc

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-16-2008, 12:11 AM
Ricardo Vaz Mannrich
 
Posts: n/a
Default PostgreSQL array vs. JDBC vs. Hibernate

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:25 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com