RAR5074
hello,
I deployed an webapp created by Java Studio Creatro 2. After approx 40hr i cant use this app anymore. that is any action that requires access to the DB, the app gets stuck. I have looked every where no idea whats wrong.
I checked the error code in the *error message reference doc*
I check the the MYsql DB it was never restarted.
Please help. Blow are the config info.
OS: Solaris 10 3/05 s10_74L2a SPARC
appserver: Sun Java System Application Server Platform
Edition 8.2.
dbserver:mysql server 4.0.24
jdbc driver:mysql-connector-java-3.1.12-bin.jar
entry in the log file
**********************
[#|2006-04-29T12:44:34.552+0700|SEVERE|sun-appserver-pe8.2|javax.enterprise.res ource.resourceadapter|_ThreadID=18;|RAR5074 : Exception while executing prepared statement|#]
[#|2006-04-29T12:44:34.559+0700|SEVERE|sun-appserver-pe8.2|javax.enterprise.res ource.resourceadapter|_ThreadID=18;|jdbc.re|#]
the connection pool settings are
general settings
********************
datesource class: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
resource type: javax.sql.connectionPoolDataSource
pool settings
****************
init min pool size: 8
max pool size: 32
resize qnt: 2
idel timeout: 300
max wait time: 60000
connection validation
*************************
validation: required
validation method: table
tablename: validation table
on failure: close all connetion
trans isolation
*****************
isolation: read-uncomitted
level: Guaranteed
