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? The error seems to be occuring with Mysql.

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.ja va:987)
at com.mysql.jdbc.PreparedStatement.setTimestampInter nal(PreparedStatement.java:2068)
at com.mysql.jdbc.PreparedStatement.setTimestamp(Prep aredStatement.java:1168)
at com.mysql.jdbc.PreparedStatement.setObject(Prepare dStatement.java:871)
at com.mysql.jdbc.PreparedStatement.setObject(Prepare dStatement.java:937)
at org.jboss.resource.adapter.jdbc.WrappedPreparedSta tement.setObject(WrappedPreparedStatement.java:607 )
at org.springframework.jdbc.core.PreparedStatementCre atorFactory$PreparedStatementCreatorImpl.createPre paredStatement(PreparedStatementCreatorFactory.jav a: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(S qlUpdate.java:125)
at com.p2h.application.operationsaccount.support.jdbc .MysqlJdbcStaffDAO$SetPassword.doSetPassword(Mysql JdbcStaffDAO.java:234)