Re: query string on a prepared statement

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Roger Niederland <roger(at)niederland(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: query string on a prepared statement
Date: 2004-11-24 22:33:20
Message-ID: 41A50C30.9000108@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Xavier Poinsard 2004-11-24 22:45:14 Re: CTS 1.3.1 results
Previous Message Kris Jurka 2004-11-24 22:31:12 Re: CTS 1.3.1 results