Question

”java.sql.SQLException: 内部错误“这是什么错误？怎么解决？

java.sql.SQLException: 内部错误
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:207)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.initCollElemTypeName(OracleTypeCOLLECTION.java:1073)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.getAttributeType(OracleTypeCOLLECTION.java:1106)
at oracle.jdbc.oracore.OracleNamedType.getFullName(OracleNamedType.java:80)
at oracle.jdbc.oracore.OracleNamedType.getFullName(OracleNamedType.java:67)
at oracle.sql.TypeDescriptor.initSQLName(TypeDescriptor.java:237)
at oracle.sql.TypeDescriptor.getName(TypeDescriptor.java:198)
at oracle.sql.StructDescriptor.getClass(StructDescriptor.java:1104)
at oracle.sql.STRUCT.toJdbc(STRUCT.java:574)
at oracle.jdbc.oracore.OracleTypeUPT.unpickle81UPT(OracleTypeUPT.java:501)
at oracle.jdbc.oracore.OracleTypeUPT.unpickle81rec(OracleTypeUPT.java:455)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81ImgBodyElements(OracleTypeCOLLECTION.java:1010)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81ImgBody(OracleTypeCOLLECTION.java:951)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81(OracleTypeCOLLECTION.java:763)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unlinearizeInternal(OracleTypeCOLLECTION.java:242)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unlinearize(OracleTypeCOLLECTION.java:216)
at oracle.sql.ArrayDescriptor.toJavaArray(ArrayDescriptor.java:890)
at oracle.sql.ARRAY.getArray(ARRAY.java:314

代码：
前面代码调用存储过程

cst.registerOutParameter(9, OracleTypes.ARRAY, "YBTUAT.TABLE_AGGR_RESULT");
cst.execute();
Array array = cst.getArray(9);
if (array != null) {
Object[] objects = (Object[]) array.getArray();
后面一些其他的处理，报错行为 Object[] objects = (Object[]) array.getArray();

请问这是什么错误，在线等！！多谢！

Answer 1

jdbc连接oracle数据库，sql语句中表名包含'$'符号，执行报错：
sql语句如下：“select * from v$session”
错误信息如下：
java.sql.SQLException: ORA-00600: 内部错误代码，参数: [ttcgcshnd-1], [0], [], [], [], [], [], []
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1681)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:737)
at components.netdevice.DatabaseReport.getConnAmount(DatabaseReport.java:52)
at components.netdevice.DatabaseReport.main(DatabaseReport.java:35)

后来证实是驱动的问题。别的jar包包含了oracle驱动，两包冲突，替换之后就解决了。

Answer 2

jar包导入了吗？应该是连接问题