0 Replies Latest reply on Dec 18, 2001 2:37 AM by Jonas Eklöf

    MySQL connection issue

    Jonas Eklöf Newbie

      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