Home » Developer & Programmer » JDeveloper, Java & XML » Inconsistent Catalog View by reading Synonyms on Oracle-objects via JDBC
Inconsistent Catalog View by reading Synonyms on Oracle-objects via JDBC [message #92395] Tue, 29 June 2004 02:11 Go to next message
Hannes Cronauer
Messages: 1
Registered: June 2004
Junior Member
Hi,

 

We have implemented the following scenario (Oracle 9.2):

At Schema S1 we created an Oracle-Type T1 and a procedure P1 that works with type T1.

At schema S2 we created synonyms for type S1.T1 -> synonym T2 and for procedure  S1.P1 -> synonym P2.

For All Objects S1 granted the execute-privileg to S2.

Connecting via SQL*PLUS to S1 and invoking P1 the code works.

Also connecting via SQL*PLUS to S2 the Code works on then synonyms.

Connectin via JDBC to S1 the codes works as well on the original objects.

But connecting via JDBC to S2 we always got the error:

Inconsistent Catalog View

I think it may have to do with the synonyms.
It looks that the JDBC-Driver can't get information on the Type-Object from then synonym

Did anybody have an idea, what's wrong with our scenario?

Thanks a lot

Hannes

 

de.volkswagen.ipad.util.exceptions.WrappingException: Interner Fehler: Inconsistent catalog view

java.sql.SQLException: Interner Fehler: Inconsistent catalog view

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.sql.StructDescriptor.initMetaData1_9_0(StructDescriptor.java:1838)

at oracle.sql.StructDescriptor.initMetaData1(StructDescriptor.java:1782)

at oracle.sql.StructDescriptor.isInstantiable(StructDescriptor.java:1027)

at oracle.sql.STRUCT.<init>(STRUCT.java:115)

at oracle.sql.OracleSQLOutput.getSTRUCT(OracleSQLOutput.java:122)

at oracle.sql.STRUCT.toSTRUCT(STRUCT.java:620)

at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:2874)

at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:3015)

at com.ibm.ejs.cm.proxy.PreparedStatementProxy.setObject(PreparedStatementProxy.java:210)

at de.volkswagen.ipad.eai.db.SQLArrayExecuter.executeSPCallWithSQLData(SQLArrayExecuter.java:53)

at de.volkswagen.ipad.eai.db.SQLExecuterTest.testExecuteSPCallWithSQLData(SQLExecuterTest.java:126)

at java.lang.reflect.Method.invoke(Native Method)

at junit.framework.TestCase.runTest(TestCase.java:154)

at junit.framework.TestCase.runBare(TestCase.java:127)

at org.apache.cactus.ServletTestCase.runCactusTest(ServletTestCase.java:295)

at org.apache.cactus.ServletTestCase.runBare(ServletTestCase.java:263)

at org.apache.cactus.server.AbstractWebTestCaller.doTest(AbstractWebTestCaller.java:156)

at org.apache.cactus.server.AbstractWebTestController.handleRequest_aroundBody0(AbstractWebTestController.java:130)

at org.apache.cactus.server.AbstractWebTestController.handleRequest_aroundBody1$advice(AbstractWebTestController.java:158)

at org.apache.cactus.server.AbstractWebTestController.handleRequest(AbstractWebTestController.java)

at org.apache.cactus.server.ServletTestRedirector.doPost_aroundBody2(ServletTestRedirector.java:138)

at org.apache.cactus.server.ServletTestRedirector.doPost_aroundBody3$advice(ServletTestRedirector.java:158)

at org.apache.cactus.server.ServletTestRedirector.doPost(ServletTestRedirector.java)

at org.apache.cactus.server.ServletTestRedirector.doGet_aroundBody0(ServletTestRedirector.java:109)

at org.apache.cactus.server.ServletTestRedirector.doGet_aroundBody1$advice(ServletTestRedirector.java:158)

at org.apache.cactus.server.ServletTestRedirector.doGet(ServletTestRedirector.java)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)

at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)

at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)

at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)

at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)

at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)

at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)

at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:665)

at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:331)

at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:117)

at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:124)

at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:218)

at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)

at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:106)

at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:125)

at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:315)

at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)

at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:323)

at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:252)

at com.ibm.ws.util.CachedThread.run(ThreadPool.java:137)
Re: Inconsistent Catalog View by reading Synonyms on Oracle-objects via JDBC [message #92724 is a reply to message #92395] Tue, 21 December 2004 04:29 Go to previous messageGo to next message
Howard
Messages: 4
Registered: April 2002
Junior Member
One of my software vendors has just hit this problem. have you fixed this yet ? Will let you know what we discover.
Re: Inconsistent Catalog View by reading Synonyms on Oracle-objects via JDBC [message #112367 is a reply to message #92724] Thu, 24 March 2005 12:44 Go to previous messageGo to next message
lviyer
Messages: 1
Registered: March 2005
Junior Member
Hi,

We've hit the same problem. Any solutions yet?

Thanks,
Re: Inconsistent Catalog View by reading Synonyms on Oracle-objects via JDBC [message #112422 is a reply to message #112367] Fri, 25 March 2005 02:52 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Check out metaLink Note: 3643391.8.

Basically it tells you to upgrade to the latest patchset of 9i (9.2.0.6) or 10g (10.1.0.4). Nothing new here, that's what Oracle support will tell you anyway.

Patches can be found at MetaLink too.
MHE

Previous Topic: JDBC and Oracle 10g
Next Topic: System error 1114
Goto Forum:
  


Current Time: Thu Mar 28 17:54:43 CDT 2024