Thread: switching from 7.4.1 to 8.0-311 jdbc driver

switching from 7.4.1 to 8.0-311 jdbc driver

From
Dennis Sacks
Date:
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



Re: switching from 7.4.1 to 8.0-311 jdbc driver

From
Kris Jurka
Date:

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

Re: switching from 7.4.1 to 8.0-311 jdbc driver

From
Dennis Sacks
Date:
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