Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

is any solution to [SQL0904] Resource limit exceeded.

843859Mar 27 2008 — edited Mar 27 2008

I got the below error while connecting with DB2
java.sql.SQLException: [SQL0904] Resource limit exceeded.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:650)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:621)
at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1506)
at com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStatement.java:185)
at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1903)
at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1726)
at com.dst.hps.mhsbenefits.DBLoader.getMappingCount(DBLoader.java:1135)
at com.dst.hps.mhsbenefits.DBLoader.countAllItems(DBLoader.java:772)
at com.dst.hps.mhsbenefits.DBLoader.doLoadWorker(DBLoader.java:432)
at com.dst.hps.mhsbenefits.DBLoader.access$1(DBLoader.java:357)
at com.dst.hps.mhsbenefits.DBLoader$1.run(DBLoader.java:2996)
Database connection closed.

Is there any solution from java programming side to resolve this issue.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 24 2008

Added on Mar 27 2008

#java-database-connectivity-jdbc

1 comment

3,731 views