resultset « postgresql « Java Database Q&A

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

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    stackoverflow.com

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

pStmt = conn.prepareStatement(qry);

pStmt = conn.prepareStatement(qry,ResultSet.TYPE_SCROLL_INSENSITIVE);

3. Setting PostgreSQL enums using a JDBC ResultSet    stackoverflow.com

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?    stackoverflow.com

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 ...