|
Home > Archive > PostgreSQL JDBC > November 2005 > Problem when upgrade PostgreSQL 7.3.3 to PostgreSQL 8.0.3
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problem when upgrade PostgreSQL 7.3.3 to PostgreSQL 8.0.3
|
|
| Tjioe Ai Xin 2005-11-17, 8:24 pm |
| Dear all,
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?
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.
What should I do to fix these error?
Best Regards,
Xin Xin
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
| |
| Kris Jurka 2005-11-18, 1:23 pm |
|
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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
| |
| Tjioe Ai Xin 2005-11-21, 3:23 am |
| Dear Kris,
Thank you for your answer. It helps me a lot.
Best Regards,
Xin Xin
On Saturday 19 November 2005 01:25, you wrote:
>
> On Fri, 18 Nov 2005, Tjioe Ai Xin wrote:
>
>
>
> 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.
>
>
> 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
>
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
|
|
|
|
|