query string on a prepared statement

From: "Roger Niederland" <roger(at)niederland(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: query string on a prepared statement
Date: 2004-11-24 20:41:47
Message-ID: 001501c4d266$055d3c30$0c02010a@RogerPortable
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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.
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:203)
at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)

postgresql version: 8.0beta5

Thanks,
Roger

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-11-24 22:31:12 Re: CTS 1.3.1 results
Previous Message Vadim Nasardinov 2004-11-24 20:37:31 CTS 1.3.1 results