4 Replies Latest reply on Nov 14, 2001 10:13 PM by Todd

    Database disconnect during night

    Rune Hamnvik Newbie

      Hi
      If my application is idle for some time, the connection to my database is lost, and the first request for persistant data will fail. The second one is allways ok. I am not sure how long the idle period must be for this error to occur, but the first request in the morning does allways fail.

      I'am using JBoss 2.4.1 on Redhat Linux 7.1, MySql 3.23.36 with JDBC driver mm.mysql-2.0.4-bin.jar.

      My data source configuration in jboss.jcml is like this:

      DefaultDS
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      jdbc:mysql:///<db name>
      mymobile
      test

      1200000
      10
      false
      false
      false
      true
      120000
      1800000
      false
      false
      1.0
      0


      Hope anyone can help, because this is the last issue before we can go online with a commercial service using JBoss.

      Rune Hamnvik
      Mobinor AS
      Norway