aspose file tools*
The moose likes JDBC and the fly likes Postgres Arrays Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Postgres Arrays" Watch "Postgres Arrays" New topic
Author

Postgres Arrays

Jon Parise
Ranch Hand

Joined: Jul 03, 2007
Posts: 81
Hey everyone,

I was wondering if anyone could help me figure out Postgres arrays with JDBC.

I have a connection to the database and I can put Data into the text array, but I can't seem to get it back out.

I'm also not sure I am even storing it properly. It is an array of text or text[] type. To store it I build a string in the following format:

"{"VALUE1","VALUE2","VALUE3"}"

That seems to be the way the postgres documentation indicates to store it. Is this the correct way to store a text[] type?

Also, how do I read it out. I see ResultSet has a getArray method, and I tried the following:

List list= Arrays.asList(rs.getArray("COLUMNNAME").getArray());

Then if I do list.get(0) I get something like [Ljava.lang.String;@1e1962d which seems to be a reference to an array object of Type String.

Some help with this would be great!

Thanks,

Jon
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Postgres Arrays
 
Similar Threads
size of 2D array
Dynamic NxN matrix
how to get data from a db into an array?
arrays
Cast Object to Object[]