Hi all, let's hope that this is more or less the right forum for this question.
My setup: JBoss-Tomcat 2.4.1/3.2.3, Mysql 3.23.36, mm.mysql-2.0.4.
My Scenario: I connect to Mysql through a lookup to a connection defined i jboss.jcml like so:
aDS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:mysql://my-server/my-db
my-user
0
my-pwd
false
false
120000
1800000
false
true
1
My problem is this: Every now and then I get java.sql.SQLException ->"lost connection during query". If I try the action again it usually fails one more time, then works like a charm. It never fails for more than two times in a row, though.
Anybody know why this happens? Is it a mysql problem? a jdbc problem? Is my jboss.jcml incorrecly configured?
I really have no clue, and would greatly appreciate any pointers.
Cheers,
/Jonas Eklöf