Hi Chris,
Le 18/04/2014 20:44, Christopher Schultz a écrit :
Every database I've ever used accepts SELECT 1 FROM DUAL because
Oracle did it first. You could try that.
Well, Postgresql does not (although you can of course create table
dual(id integer primary key); insert 1 into dual(id);).
On Tue, Apr 22, 2014 at 01:58:56PM +0200, Franck Routier wrote:
[snip]
That said, I was hit by another (related) problem this week-end, with
Oracle.
The validation query was configured as 'select 1 from dual;'. Notice the
semi-column: this broke everything with intermittent ORA-12516 errors.
Hi,
Le 18/04/2014 20:44, Christopher Schultz a écrit :
Every database I've ever used accepts SELECT 1 FROM DUAL because
Oracle did it first. You could try that.
Well, Postgresql does not.But you can omit the from if you want, as in
'select 1'
That said, using rollbackOnReturn=true seemed
Hi,
we recently switched to tomcat-jdbc-pool as our connection pool, and
have since encountered performance problems with Postgresql.
The problem is due to the fact that postgres is having hard time
vacuuming, due to always ongoing idle transactions.
See
On Apr 18, 2014, at 5:05 AM, Franck Routier franck.rout...@axege.com wrote:
Hi,
we recently switched to tomcat-jdbc-pool as our connection pool, and
have since encountered performance problems with Postgresql.
The problem is due to the fact that postgres is having hard time
vacuuming, due
Hi,
Le 18/04/2014 13:53, Daniel Mikusa a écrit :
Another option you might try would be to set “rollbackOnReturn to
“true”. That is supposed to instruct the pool to rollback an open
transactions when the connection is returned to the pool. I haven’t
tried it, but it seems like it would work
On Fri, 2014-04-18 at 11:05 +0200, Franck Routier wrote:
property name=validationQuery value=select 1 from rtelre/
Is is possible the select just needs to be terminated with a semi-colon?
-
To unsubscribe, e-mail:
Le 18/04/2014 13:53, Daniel Mikusa a écrit :
Another option you might try would be to set “rollbackOnReturn to “true”.
That is supposed to instruct the pool to rollback an open transactions when
the connection is returned to the pool. I
haven’t tried it, but it seems like it would work
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Dan,
On 4/18/14, 7:53 AM, Daniel Mikusa wrote:
On Apr 18, 2014, at 5:05 AM, Franck Routier
franck.rout...@axege.com wrote:
Hi,
we recently switched to tomcat-jdbc-pool as our connection pool,
and have since encountered performance
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Franck,
On 4/18/14, 5:05 AM, Franck Routier wrote:
we recently switched to tomcat-jdbc-pool as our connection pool,
and have since encountered performance problems with Postgresql.
The problem is due to the fact that postgres is having hard
10 matches
Mail list logo