Re: next() and PreparedStatement

Hi Mano,

No the problem is not with jdbc.

I do see a couple of things though

1) the semi-colon isn't necessary, but shouldn't break the code? try
removing it.

2) returning the row that way looks a little dangerous. It is possible
that the statement associated with the row would be gone after
returning.


dave

On Tue, 2001-08-28 at 07:13, Mano lito wrote:
>
>
>   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@postgresql.org
>
>