[wakeup]

I work with struts
I have a page that has been taking enough seconds in loading since for many consultations with data. When executing never it gives it problems but if I at the same time send it from two browsers ones almost always they cracks randomly giving one of these two errors.
java.sql.SQLException: No operations allowed after connection closed.
java.sql.SQLException: Operation not allowed after ResultSet closed.

Using mysql-connector-java-3.1.7-bin.jar

Usando un pool de conexiones.
Configuración de la BD
<data-source type=”org.apache.commons.dbcp.BasicDataSource”>
<set-property property=”driverClassName” value=”org.gjt.mm.mysql.Driver” />
<set-property property=”url” value=”jdbc:mysql://localhost:3306/supervisiondb” />
<set-property property=”username” value=”acastro” />
<set-property property=”password” value=”acastro” />
<set-property property=”maxActive” value=”30″ />
<set-property property=”maxIdle” value=”5″ />
<set-property property=”minIdle” value=”2″ />
<set-property property=”minEvictableIdleTimeMillis” value=”20000″ />
<set-property property=”timeBetweenEvictionRunsMillis” value=”60000″ />
<set-property property=”maxWait” value=”15000″ />
<set-property property=”defaultAutoCommit” value=”true” />
<set-property property=”defaultReadOnly” value=”false” />
<set-property property=”validationQuery” value=”SELECT * FROM CLIENTES” />
<set-property property=”testOnBorrow” value=”true” />
<set-property property=”testWhileIdle” value=”true” />
<set-property property=”removeAbandoned” value=”true” />
<set-property property=”removeAbandonedTimeout” value=”60″ />
<set-property property=”logAbandoned” value=”true” />
</data-source>

THanksss

http://hhdirecto.webcindario.com

[Riyad Kalla]

Moving to OT > Soft Dev.

[Author]

Posts