RE: next() and PreparedStatement

i believe that when you close the stmt, the rs is automatically closed. you
have to leave the stmt open until you're done with the rs.

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Mano lito
Sent: Tuesday, August 28, 2001 7:14 AM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] next() and PreparedStatement

Hi!

We are developing a project using PostgreSQL 7.1.2 and JDBC drivers to
exchange information with the database. Here is a piece of code to explain
our problem:

---------------------------
PreparedStatement pstmt;
Connection connection;
ResultSet rs = null;
String query = new String( "SELECT count(*) FROM foo_table WHERE
foo_code=?;" );
pstmt = connection.prepareStatement( query );
pstmt.setString( 1, foo );
rs = pstmt.executeQuery( query );

pstmt.close();

return rs.next();
--------------------------

the next() method will cause a java.lang.NullPointerException
when the ResultSet comes from a PreparedStatement!!! Is this problem
originated by the JDBC driver? We downloaded it from jdbc.fastcrypt.com
but this error occurs again and again and in jdbc.postgresql.org we see
7.0.x drivers available but none 7.1 nor 7.1.2 exists...

We'd appreciate any help you could give us.If your address is not the
correct place to ask this questions please tell us.

Thanks in advance.

_________________________________________________________________
Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org