resultset « postgresql « Java Database Q&A

1. Updating ResultSets with SQL Array types in JDBC / PostgreSQL

I'm trying to use a SQL Array type with PostgreSQL 8.4 and the JDBC4 driver. My column is defined as follows:

nicknames           CHARACTER ...

2. Scrollable ResultSet JDBC Postgresql

When I create a prepared statement like this in java (using JDBC):

pStmt = conn.prepareStatement(qry);
everything works ok. However when I want a scrollable resultset and use this:
pStmt = conn.prepareStatement(qry,ResultSet.TYPE_SCROLL_INSENSITIVE);
I get a syntax ...

3. Setting PostgreSQL enums using a JDBC ResultSet

I'm trying to copy data from a MySQL database to an equivalent PostgreSQL database, doing a load/insert through Java using JDBC. I get this error whenever I try to copy an ...

4. How to use Multiple resultsets with POSTGRES JDBC?

I am using JDBC on a PostgreSQL database. When I query for an entity in a resultset, it returns 5 rows. Related to that entity is another entity, for which I query while ...