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);)
Sure, it does come from the repositories.
Have a look here: https://help.ubuntu.com/community/Repositories/Ubuntu
Also, the package itself has a maintainer, and some metainformations.
Do this in a terminal to get additional informations:
$ apt-cache show tomcat7
You should get something like th
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 see
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 wo
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 wor
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
http://permalink.gmane.org/gmane.comp.db.p
