#4 Database connection timeout if unused for long time.

[Cristian Romanescu]

Hello, everyone.

I write you since we have this strange problem...

We are using Linux/Tomcat 4.1.18/JRF 2.4 beta,
compiled from sources in combination with MySQL 4.0.13
through "mysql-connector-java-3.0.7-stable-bin.jar" for
a webapp.

The problem arise when the server is not accessed for a
long time. For example after 24 hours, when I try to
access a web page which takes data through JRF from
database, I get all kinds of erros such as
StackOverflowException, Connection to database lost
etc.

I'm not sure where this comes from, but I assume that
connections from the pool timeout?

I don't understand If it's either a configuration problem
or a bug.

Could you help me, please?

I wrote below also the jrf.properties related to MySQL
configuration.

Best regards,
Cristian.

######################################
###################################
## Category A: Policy ---
######################################
###################################

mysql.databasePolicy=net.sf.jrf.dbpolicies.MySQLDatabas
ePolicy

######################################
###################################
## Category B: DataSource behavior properties.
######################################
###################################

mysql.clobsupport=YES
mysql.blobsupport=YES
mysql.setpreparedcharacterstream=NO
mysql.binaryStreamsSupported=YES
mysql.supportBigDecimal=true
mysql.supportPreparedSetBoolean=false
mysql.reuseStatement=false
mysql.useANSIJoins=true
mysql.transactionsForDropAndCreateSupported=true

## Set the following value to false if not using INODB

mysql.commitAndRollbackSupported=false

## MYSQL-specific parameter to denote use of InnoDB

mysql.useInnoDB=false

######################################
###################################
## Category C: Connection Type
######################################
###################################

mysql.conntype=local