Re: query string on a prepared statement - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: query string on a prepared statement
Date
Msg-id 41A50C30.9000108@opencloud.com
Whole thread Raw
In response to query string on a prepared statement  ("Roger Niederland" <roger@niederland.com>)
List pgsql-jdbc
Roger Niederland wrote:

> Using pg80b1.308.jdbc3.jar got the following: (worked with
> pg74.215.jdbc3.jar)
>
> Code:
> results = stmt.executeQuery("SELECT currval('LoginLog_LoginLogID_seq')");
>
> Stack Trace:
> org.postgresql.util.PSQLException: Can't use query methods that take a
> query string on a PreparedStatement.

As it says, you can't use executeQuery(String) on a PreparedStatement.
Use it on a Statement created via Connection.createStatement() instead.

The JDBC spec requires that PreparedStatement throw an exception in this
case. Older drivers did not follow the spec.

-O

pgsql-jdbc by date:

Previous
From: "Roger Niederland"
Date:
Subject: query string on a prepared statement
Next
From: Kris Jurka
Date:
Subject: Re: CTS 1.3.1 results