Hi,
We are using Jive-Messenger with Oracle 8.1.7.4 and we have this error after few hours:
2004.06.14 14:18 com.jivesoftware.xmpp.user.spi.DbUserManager.deleteUser(DbUserManager.java:256)
java.sql.SQLException: ORA-01000: Nombre maximum de curseurs ouverts atteint
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1330)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:757)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1313)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1232)
at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java:1353 )
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1760)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:18 07)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatemen t.java:332)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java :376)
at com.jivesoftware.xmpp.user.spi.DbUserManager.deleteUser(DbUserManager.java:253)
at com.jivesoftware.xmpp.user.spi.DbUserManager.deleteUser(DbUserManager.java:271)
at com.jivesoftware.xmpp.handler.IQRegisterHandler.handleIQ(IQRegisterHandler.java :111)
at com.jivesoftware.xmpp.spi.IQHandler.handleMessages(IQHandler.java:48)
at com.jivesoftware.xmpp.spi.BasicChannel$ChannelWorker.run(BasicChannel.java:340)
We use Oracle thin java client (classe_12.zip) with Jive-Messenger 1.0.8 and our max opened cursor limit is 400. It seems some ressources not released by the jdbc client.
Any Idea ?
Thanks,
LC
Message was edited by: ipsystem