java oracle游标_Java oracle 超出打开游标的最大数

Java代码在执行conn.createStatement

和conn.prepareStatement

时候

实际上都是相当和在数据库中打开了

个cursor

不要放在这两个方法不要放在循环中

java.sql.SQLException: ORA-00604: 递归 SQL 级别 1 出现错误

ORA-01000: 超出打开游标的最大数

ORA-01000: 超出打开游标的最大数

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)

at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)

at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)

at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1264)

at com.eastmoney.hdfs.DBUtil.Execute(DBUtil.java:62)

at com.eastmoney.hdfs.SyncJob.Paging(SyncJob.java:366)

at com.eastmoney.hdfs.SyncJob.Import(SyncJob.java:312)

at com.eastmoney.hdfs.SyncJob.main(SyncJob.java:499)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:58)

Exception in thread "main" java.lang.reflect.InvocationTargetException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:58)

Caused by: java.lang.NullPointerException

at com.eastmoney.hdfs.SyncJob.Import(SyncJob.java:315)

at com.eastmoney.hdfs.SyncJob.main(SyncJob.java:499)

... 5 more