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

    JBossMQ: ORA-01000: maximum open cursors exceeded

    mtf1965 Newbie

      Hi,

      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 8.1.7.0.0 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...