Re: Problem when upgrade PostgreSQL 7.3.3 to PostgreSQL 8.0.3

[Kris Jurka <books(at)ejurka(dot)com>]

On Fri, 18 Nov 2005, Tjioe Ai Xin wrote:

> I have web application which is run using PostgreSQL 7.3.3 and JDBC 
> Driver pg3jdbc3.jar. But when I try to update to PostgreSQL 8.0.3 and 
> using JDBC Driver postgresql-8.0-314.jdbc3.jar, I got error messages:

> 1. Cannot change transaction isolation level in the middle of a transaction.
> 	--> Does changing transaction isolation level in the middle of a 
> transaction no longer supported?

This was never supported, but simply did not report the error in the past. 
Transaction isolation must be set before the first statement of the 
transaction is executed.  The server must know in advance what type of 
snapshot it must take when the transaction starts.  It cannot go back and 
time and retake it if the isolation level changes mid-transaction.

> 2. ERROR: operator does not exist: bigint / character varying
> 	--> I don't understand this error message because all my query 
> statements runs well in the shell.
> 	     But when I call my query statement, I got the message.

I'm guessing you are using PreparedStatement.setString for a numeric 
value.  Do you have a query like "WHERE colname / ? " ?  You need to use a 
different setXXX method that takes a numeric value.

Kris Jurka