代码方面没问题,在公司的时候都可以用,我在公司的时候链接的是服务器的,没连接本地的,今天回到宿舍加班,结果网络被限制,链接不上服务器,然后就用本地的,一直报这个错:
java.sql.SQLException: ORA-22905: cannot access rows from a non-nested table item
ORA-06512: at "COLDMANAGER.AUTOUPDATECOLDREG", line 79
ORA-06512: at line 1
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
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:1034)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3857)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at com.jiangnan.listener.JiangNanListener$1.run(JiangNanListener.java:64)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
还不断地显示......求大师赐教啊
ps:本地用户拥有同样的权限
------解决方案--------------------
没连上数据库。???
数据库里数据查出来是空的,导致画面嵌套层错误??
我猜的。