Ora-17001 Internal Error
Contents |
can return. The appendix is organized as follows: General Structure of JDBC Error Messages General JDBC Messages error code 17001 internal error inconsistent catalog view Native XA Messages TTC Messages Each of the message lists is
Internal Error Inconsistent Catalog View Struct
first sorted by ORA number, and then alphabetically. See Also: "Processing SQL Exceptions" General Structure of nested exception is java sql sqlexception internal error inconsistent catalog view JDBC Error Messages The general JDBC error message structure allows run-time information to be appended to the end of a message, following a colon, as follows:
Java.sql.sqlexception: Internal Error: Inconsistent Adt Attribute
and to http://spring.io/questions for a curated list of stackoverflow tags that Pivotal engineers, and the community, monitor. Announcement Announcement Module Collapse No announcement yet. java.sql.SQLException: Internal Error while using oracle.sql.ARRAY.getArray() Page Title Module Move Remove Collapse X Conversation Detail Module Collapse Posts Latest Activity Search Forums Page of 1 Filter Time All Time Today Last Week Last Month Show All Discussions only Photos only Videos only Links https://docs.oracle.com/cd/E11882_01/java.112/e16548/apxermsg.htm only Polls only Filtered by: Clear All new posts annijos Junior Member Join Date: Jul 2006 Posts: 19 #1 java.sql.SQLException: Internal Error while using oracle.sql.ARRAY.getArray() Oct 31st, 2006, 07:13 AM Hello All, Here is the issue description. Our application uses Oracle Object Types and LIST. We deployed our application on QA environment http://forum.spring.io/forum/spring-projects/data/21997-java-sql-sqlexception-internal-error-while-using-oracle-sql-array-getarray which has Oracle 10g. Application runs fine...no issues. Now we moved to UAT. UAT environment is same as QA environment and DBA have created replica of QA database. Now WAR file which works fine with QA database , somehow doesnt work with UAT database. Application throws following exception when code tries to call getArray() on java.sql.Array. We tried to point UAT weblogic to QA database and it worked fine.....but when we point UAT weblogic to UAT database , we get following exception. So we know that this is a database issue. DBA claims that QA env database and UAT env database are same. Can anybody please tell me what wrong here? What setting is not done on UAT database which is done on QA? Code: java.sql.SQLException: Internal Error at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227) at oracle.jdbc.oracore.OracleTypeCOLLECTION.initCollElemTypeName(OracleTypeCOLLECTION.java:975) at oracle.jdbc.oracore.OracleTypeCOLLECTION.getAttributeType(OracleTypeCOLLECTION.java:1005) at oracle.jdbc.oracore.OracleNamedType.getFullName(OracleNamedType.java:96) at oracle.jdbc.oracore.OracleTypeADT.createStructDescriptor(OracleTypeADT.java:1958) at oracle.jdbc.oracore.OracleTypeADT.unpickle81(OracleTypeADT.java:1432) at oracle.jdbc.oracore.OracleTypeUPT.unpickle81UPT(OracleTypeUPT.java:426) at oracle.jdbc.oracore.OracleTypeUPT.unpickle81rec(OracleTypeUPT.java:383) at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81_imgBody_elems(OracleTypeCOLLECTION.java:928) at oracle.jdbc
and to http://spring.io/questions for a curated list of stackoverflow tags that Pivotal engineers, and the http://forum.spring.io/forum/spring-projects/data/121292-trouble-getting-oracle-structs-to-work-with-jdbc-extensions community, monitor. Announcement Announcement Module Collapse No announcement yet. Trouble getting Oracle Structs to work with JDBC Extensions Page Title Module Move Remove Collapse X Conversation Detail Module Collapse Posts Latest Activity Search Forums Page of 1 Filter Time All Time Today Last Week Last Month Show All Discussions only internal error Photos only Videos only Links only Polls only Filtered by: Clear All new posts the_new_mr Junior Member Join Date: Aug 2012 Posts: 5 #1 Trouble getting Oracle Structs to work with JDBC Extensions Sep 25th, 2012, 08:14 AM Hello all. I have tried using the JDBC extensions with Oracle support and internal error inconsistent was able to pass arrays to Oracle but am having trouble getting the STRUCTS to work. I am following the code examples at the following link: http://static.springsource.org/sprin...tatypes.struct I am using RC3 downloaded from here: http://www.springsource.org/download/community I've tried using both techniques (by implementing the SQLData interface and SqlStructValue) and am getting the following errors When using the SQLData technique: Code: org.springframework.jdbc.UncategorizedSQLException : CallableStatementCallback; uncategorized SQLException for SQL [{call MY_SCHEMA_NAME.ADD_ACTOR(?)}]; SQL state [99999]; error code [17001]; Internal Error: Inconsistent catalog view; nested exception is java.sql.SQLException: Internal Error: Inconsistent catalog view null When using the SqlStructValue technique: Code: org.springframework.dao.DataIntegrityViolationException : CallableStatementCallback; SQL [{call MY_SCHEMA_NAME.ADD_ACTOR(?)}]; ORA-01403: no data found ORA-06512: at line 1 ; nested exception is java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 null Below is my Java and SQL code. Any help would be greatly appreciated. Code: create or replace TYPE actor_type AS OBJECT (id NUMBER, name VARCHAR2(50)); C