I prefer one connection per request, with read-only/read-write state
depending on the request. I use the pool to manage the connections,
and keep no connection open after the request is processed.
2012/9/13 papp.zoltan_at_mondoka.hu <papp.zoltan_at_mondoka.hu>:
> Which preferred by you?
>
> 1. One Read-only database connection per web application with more short rw
> transactional connections
> 2. One Read-only database connection per web session with more short rw
> transactional connections
>
> Glassfish 3.1.2.2
> MySQL 5.1.63
> hibernate-core-4.1.6
> mysql-connector-java-5.1.6-bin.jar
> jdk1.7.0_05