|
Home > Archive > PostgreSQL JDBC > April 2005 > switching from 7.4.1 to 8.0-311 jdbc driver
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 |
switching from 7.4.1 to 8.0-311 jdbc driver
|
|
| Dennis Sacks 2005-04-21, 11:24 am |
| Hi,
I am proposing a change to the newer 8.0 jdbc driver - it seems to clear
up some odd things I was seeing logged heavily:
2005-04-19 16:43:03 LOG: 00000: duration: 0.246 ms
LOCATION: exec_simple_query, postgres.c:960
2005-04-19 16:43:03 LOG: 00000: statement: rollback; begin;
LOCATION: pg_parse_query, postgres.c:464
My question is - are there any "gotchas" I need to look out for -
changes in behavior, etc, that might cause problems with this switch?
The java application makes use of autocommit() quite a bit.
I am running postgresql 7.4.2.
Thanks,
Dennis
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql
.org
| |
| Kris Jurka 2005-04-21, 1:24 pm |
|
On Thu, 21 Apr 2005, Dennis Sacks wrote:
> I am proposing a change to the newer 8.0 jdbc driver - it seems to clear
> up some odd things I was seeing logged heavily:
>
> 2005-04-19 16:43:03 LOG: 00000: duration: 0.246 ms
> LOCATION: exec_simple_query, postgres.c:960
> 2005-04-19 16:43:03 LOG: 00000: statement: rollback; begin;
> LOCATION: pg_parse_query, postgres.c:464
This statement is from issuing Connection.rollback() and it will still
happen with the 8.0 driver. The difference is that the 8.0 driver uses
the full V3 protocol which has some logging problems on the server
side, so you just aren't seeing them being executed even though they
are.
Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql
.org
| |
| Dennis Sacks 2005-04-21, 8:24 pm |
| Kris Jurka wrote:
>This statement is from issuing Connection.rollback() and it will still
>happen with the 8.0 driver. The difference is that the 8.0 driver uses
>the full V3 protocol which has some logging problems on the server
>side, so you just aren't seeing them being executed even though they
>are.
>
>
Are there advantages of moving to the 8.0 driver?
Dennis
dennis@illusions.com
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
|
|
|
|
|