Hi, We have an application that uses JBoss 2.4.3 as an app server and mysql 3.23.36 as the database. All the database tables are of type "BerkeleyDB" .
All our DB updations are done within a session bean, our application executes approx. 1000 db updations per minute for a period of 10 minutes. This process is repeated every hour , and this is where our problem starts. The first set of updations happen smoothly but when the next set starts we get the following error. [Default] java.sql.SQLException: General error: Got error -30996 from table handler [Default] at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497) [Default] [Default] at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550) [Default] [Default] at org.gjt.mm.mysql.Connection.execSQL(Connection.java:885) [Default] [Default] at org.gjt.mm.mysql.PreparedStatement.executeUpdate(PreparedStatement.java:389) [Default] [Default] at org.jboss.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementI nPo ol.java:82) [Default] [Default] at com.mms.util.DbManager.executeUpdate(DbManager.java:124) [Default] [Default] at com.mms.process.LogManagerImpl.writeMessageDetails(LogManagerImpl.java:317) [Default] [Default] at com.mms.process.LogManagerImpl.onSend(LogManagerImpl.java:29) [Default] [Default] at com.chalomumbai.process.MessageFactoryImpl.formMessage(MessageFactoryImpl.ja va: 104) [Default] [Default] at com.mms.process.InputHandler.onEvent(InputHandler.java:51) [Default] [Default] at com.mms.ejb.MessagingEJB.onEvent(MessagingEJB.java:37) [Default] [Default] at java.lang.reflect.Method.invoke(Native Method) [Default] [Default] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Stateles sSe ssionContainer.java:543) [Default] [Default] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSe ssi onInstanceInterceptor.java:87) [Default] [Default] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133) [Default] [Default] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT. jav a:307) [Default] Does anyone understand this particular error.? Regards Ganesh --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php