5 Replies Latest reply on Apr 4, 2003 10:25 PM by Adrian Brock

    JBossMQ: ORA-01000: maximum open cursors exceeded

    mtf1965 Newbie


      We encounterd a problem while testing a simple MDB example. It's just a client writing messages to a queue and a message driven bean receiving these messages.
      If we now start sending messages in the beginning all works fine, but after some hundred messages jboss reports the following java exception:

      org.jboss.mq.SpyJMSException: Could not store message: 1028; - nested throwable: (java.sql.SQLException: ORA-01000: maximum open cursors exceeded)

      We use Jboss3.0.2, Oracle8i Enterprise Edition Release together with jdbc2 PersistenceManager for the queue. Oracle is configured to 350 cursors.

      Does anybody know whether this is a configuration problem or a bug? And how to solve the problem?

      thanks in advance...