Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 843830, 1 year ago
Error occured while executing sql.select * from TBD_HOUSE_INFO where FLAG != 1or FLAG is NULL
javax.jbi.messaging.MessagingException: Error occured while executing sql.select * from TBD_HOUSE_INFO where FLAG != 1or FLAG is NULL at org.glassfish.openesb.databasebc.InboundMessageProcessor.executeInboundSQLSelect(InboundMessageProcessor.java:484) at org.glassfish.openesb.databasebc.InboundMessageProcessor.processInOnly(InboundMessageProcessor.java:388) at org.glassfish.openesb.databasebc.InboundMessageProcessor.execute(InboundMessageProcessor.java:308) at org.glassfish.openesb.databasebc.InboundMessageProcessor.run(InboundMessageProcessor.java:231) at java.lang.Thread.run(Thread.java:619)Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1490) at org.glassfish.openesb.databasebc.InboundMessageProcessor.executeInboundSQLSelect(InboundMessageProcessor.java:480) ... 4 more