0 Replies Latest reply on Jan 9, 2004 5:03 AM by kamwingpang

    Jboss - Mysql Connection failure

    kamwingpang Newbie

      Hi all,

      We are deveoping an application using Spring Framework, where the application (using Struts) calls an EJB business method which in turns calls the DAO layer that access a Mysql Database. All this is deployed on Jboss 3.2.1 (with tomcat 4.1.24).

      It works fine most of the time but once in a while after a few redeployment of the application in the running application server, we get a strange error which requires JBoss to be restarted before the application can run again.

      Does anyone know what is happening here and where we should look to solve this problem?

      If you require any more information, let me know.

      Cheers,

      Kam
      ******************


      13:52:35,994 ERROR [Engine] ----- Root Cause -----
      javax.ejb.EJBException: Unexpected Error
      java.lang.NoClassDefFoundError: com/mysql/jdbc/Connection
      at com.mysql.jdbc.TimeUtil.changeTimezone(TimeUtil.java:987)
      at com.mysql.jdbc.PreparedStatement.setTimestampInternal(PreparedStatement.java:2068)
      at com.mysql.jdbc.PreparedStatement.setTimestamp(PreparedStatement.java:1168)
      at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:871)
      at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:937)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setObject(WrappedPreparedStatement.java:607)
      at org.springframework.jdbc.core.PreparedStatementCreatorFactory$PreparedStatementCreatorImpl.createPreparedStatement(PreparedStatementCreatorFactory.java:120)
      at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:426)
      at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:408)
      at org.springframework.jdbc.object.SqlUpdate.update(SqlUpdate.java:125)
      at com.p2h.application.operationsaccount.support.jdbc.MysqlJdbcStaffDAO$SetPassword.doSetPassword(MysqlJdbcStaffDAO.java:234)