Lists: | pgsql-jdbc |
---|
From: | Dennis Sacks <dennis(at)illusions(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | switching from 7.4.1 to 8.0-311 jdbc driver |
Date: | 2005-04-21 15:02:10 |
Message-ID: | 4267C072.1040806@illusions.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
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
From: | Kris Jurka <books(at)ejurka(dot)com> |
---|---|
To: | Dennis Sacks <dennis(at)illusions(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: switching from 7.4.1 to 8.0-311 jdbc driver |
Date: | 2005-04-21 18:24:18 |
Message-ID: | Pine.BSO.4.56.0504211321430.5816@leary.csoft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
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
From: | Dennis Sacks <dennis(at)illusions(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: switching from 7.4.1 to 8.0-311 jdbc driver |
Date: | 2005-04-21 21:59:11 |
Message-ID: | 4268222F.5090606@illusions.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
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(at)illusions(dot)com