You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Mani Afschar Yazdi <ma...@jq-consulting.de> on 2011/06/06 09:46:57 UTC
SQLSTATE: X0Y32Statement 'getProcedureColumns'
Beschreibung des Problems (optional):
Hi,
Derby run out of memory and I killed the process because it did not
respond at all for more than 10 min, no CPU activity. After starting
derby, when trying to connect to a database I get th following error
message. Can you help? I can provide the whole database if necessary.
Thanks & regards
Mani
jq.io.RemoteException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040,
SQLERRMC: Die Datenbank 'ess_casch' konnte nicht mit dem
Klassenladeprogramm sun.misc.Launcher$AppClassLoader@7d772e gestartet
werden. Details können Sie der nächsten Ausnahme entnehmen.::SQLSTATE:
X0Y32Statement 'getProcedureColumns' ist bereits in Schema 'SYS'
vorhanden. (SQLException)
java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040,
SQLERRMC: Die Datenbank 'ess_casch' konnte nicht mit dem
Klassenladeprogramm sun.misc.Launcher$AppClassLoader@7d772e gestartet
werden. Details können Sie der nächsten Ausnahme entnehmen.::SQLSTATE:
X0Y32Statement 'getProcedureColumns' ist bereits in Schema 'SYS'
vorhanden.
at
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at jq.io.Connection.getConnection(Connection.java:368)
at jq.io.Connection.setAutoCommit(Connection.java:222)
at jq.edc.task.DBAction.getConnection(DBAction.java:94)
at jq.edc.task.DBSelect.execute(DBSelect.java:555)
at jq.task.AbstractTask.run(AbstractTask.java:55)
at jq.server.ServerBase.executeTask(ServerBase.java:205)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at jq.server.RMIServerImpl.execute(RMIServerImpl.java:93)
at jq.server.RMIServerImpl_Skel.dispatch(RMIServerImpl_Skel.java:98)
at sun.rmi.server.UnicastServerRef.oldDispatch(UnicastServerRef.java:386)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:250)
at sun.rmi.transport.Transport$1.run(Transport.java:159)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error:
SQLCODE: -1, SQLSTATE: XJ040, SQLERRMC: Die Datenbank 'ess_casch'
konnte nicht mit dem Klassenladeprogramm
sun.misc.Launcher$AppClassLoader@7d772e gestartet werden. Details
können Sie der nächsten Ausnahme entnehmen.::SQLSTATE: X0Y32Statement
'getProcedureColumns' ist bereits in Schema 'SYS' vorhanden.
at org.apache.derby.client.am.Connection.completeSqlca(Unknown Source)
at
org.apache.derby.client.net.NetConnectionReply.parseRdbAccessFailed(Unknown
Source)
at
org.apache.derby.client.net.NetConnectionReply.parseAccessRdbError(Unknown
Source)
at
org.apache.derby.client.net.NetConnectionReply.parseACCRDBreply(Unknown
Source)
at
org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(Unknown
Source)
at
org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(Unknown
Source)
at
org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(Unknown
Source)
at
org.apache.derby.client.net.NetConnection.flowUSRIDONLconnect(Unknown
Source)
at org.apache.derby.client.net.NetConnection.flowConnect(Unknown Source)
at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
at org.apache.derby.client.net.NetConnection40.<init>(Unknown Source)
at
org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(Unknown
Source)
... 25 more
(RemoteException)
jq.io.RemoteException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040,
SQLERRMC: Die Datenbank 'ess_casch' konnte nicht mit dem
Klassenladeprogramm sun.misc.Launcher$AppClassLoader@7d772e gestartet
werden. Details können Sie der nächsten Ausnahme entnehmen.::SQLSTATE:
X0Y32Statement 'getProcedureColumns' ist bereits in Schema 'SYS'
vorhanden. (SQLException)
java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040,
SQLERRMC: Die Datenbank 'ess_casch' konnte nicht mit dem
Klassenladeprogramm sun.misc.Launcher$AppClassLoader@7d772e gestartet
werden. Details können Sie der nächsten Ausnahme entnehmen.::SQLSTATE:
X0Y32Statement 'getProcedureColumns' ist bereits in Schema 'SYS'
vorhanden.
at
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at jq.io.Connection.getConnection(Connection.java:368)
at jq.io.Connection.setAutoCommit(Connection.java:222)
at jq.edc.task.DBAction.getConnection(DBAction.java:94)
at jq.edc.task.DBSelect.execute(DBSelect.java:555)
at jq.task.AbstractTask.run(AbstractTask.java:55)
at jq.server.ServerBase.executeTask(ServerBase.java:205)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at jq.server.RMIServerImpl.execute(RMIServerImpl.java:93)
at jq.server.RMIServerImpl_Skel.dispatch(RMIServerImpl_Skel.java:98)
at sun.rmi.server.UnicastServerRef.oldDispatch(UnicastServerRef.java:386)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:250)
at sun.rmi.transport.Transport$1.run(Transport.java:159)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error:
SQLCODE: -1, SQLSTATE: XJ040, SQLERRMC: Die Datenbank 'ess_casch'
konnte nicht mit dem Klassenladeprogramm
sun.misc.Launcher$AppClassLoader@7d772e gestartet werden. Details
können Sie der nächsten Ausnahme entnehmen.::SQLSTATE: X0Y32Statement
'getProcedureColumns' ist bereits in Schema 'SYS' vorhanden.
at org.apache.derby.client.am.Connection.completeSqlca(Unknown Source)
at
org.apache.derby.client.net.NetConnectionReply.parseRdbAccessFailed(Unknown
Source)
at
org.apache.derby.client.net.NetConnectionReply.parseAccessRdbError(Unknown
Source)
at
org.apache.derby.client.net.NetConnectionReply.parseACCRDBreply(Unknown
Source)
at
org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(Unknown
Source)
at
org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(Unknown
Source)
at
org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(Unknown
Source)
at
org.apache.derby.client.net.NetConnection.flowUSRIDONLconnect(Unknown
Source)
at org.apache.derby.client.net.NetConnection.flowConnect(Unknown Source)
at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
at org.apache.derby.client.net.NetConnection40.<init>(Unknown Source)
at
org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(Unknown
Source)
... 25 more
at jq.server.Log.logError(Log.java:330)
at jq.server.RMIServerImpl.execute(RMIServerImpl.java:110)
at jq.server.RMIServerImpl_Skel.dispatch(RMIServerImpl_Skel.java:98)
at sun.rmi.server.UnicastServerRef.oldDispatch(UnicastServerRef.java:386)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:250)
at sun.rmi.transport.Transport$1.run(Transport.java:159)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
at jq.server.RMIServerImpl_Skel.dispatch(RMIServerImpl_Skel.java:121)
at sun.rmi.server.UnicastServerRef.oldDispatch(UnicastServerRef.java:386)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:250)
at sun.rmi.transport.Transport$1.run(Transport.java:159)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
at
sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(Unknown
Source)
at sun.rmi.transport.StreamRemoteCall.executeCall(Unknown Source)
at sun.rmi.server.UnicastRef.invoke(Unknown Source)
at jq.server.RMIServerImpl_Stub.execute(Unknown Source)
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 jq.io.Communication.a(Unknown Source)
at jq.io.Communication.executeTask(Unknown Source)
at jq.task.AbstractTask.run(Unknown Source)
at jq.edc.io.PersistorEDC.getData(Unknown Source)
at jq.model.ModelList.refresh(Unknown Source)
at jq.model.h.init(Unknown Source)
at jq.edc.gui.action.c.execute(Unknown Source)
at jq.gui.a.e.actionPerformed(Unknown Source)
at jq.edc.PanelMain.treeItemAction(Unknown Source)
at jq.gui.panel.PanelTree$1.execute(Unknown Source)
at jq.gui.a.e.actionPerformed(Unknown Source)
at jq.gui.panel.PanelTree.fireItemAction(Unknown Source)
at jq.gui.panel.PanelTree.do(Unknown Source)
at jq.gui.panel.PanelTree.do(Unknown Source)
at jq.gui.panel.PanelTree.do(Unknown Source)
at jq.gui.panel.PanelTree.do(Unknown Source)
at jq.gui.panel.PanelTree.mousePressed(Unknown Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source)
at
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Mani Afschar Yazdi
JNet Quality Consulting GmbH
Geschäftsführer
Wilhelm-Riehl-Str. 13
80687 München
Tel: 0179 / 7880969
mani.afschar@jq-consulting.de
www.jq-consulting.de
www.sell-force.de
****************************************************************************************
JNet Quality Consulting GmbH, Sitz: München, Amtsgericht München HR B
13 51 82.
Geschäftsführer: Mani Afschar Yazdi
Der Inhalt dieser E-Mail oder eventueller Anhänge ist ausschließlich für den
bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene
Adressat dieser
E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte, dass
jede Form
der Kenntnisnahme, Veröffentlichung, Vervielfältigung oder Weitergabe des
Inhalts dieser E-Mail unzulässig ist. Wir bitten Sie, sich in diesem Fall mit
dem Absender der E-Mail in Verbindung zu setzen.
The information contained in this email is intended solely for the
addressee. If
you are not the intended recipient, any form of disclosure, reproduction,
distribution or any action taken or refrained from in reliance on it, is
prohibited and may be unlawful. Please notify the sender immediately.
****************************************************************************************
------------------------------------------------------------
This mail has been sent through netpilot.net webmail service
Spam protected by http://www.clean-mx.de by netpilot GmbH
------------------------------------------------------------
Re: SQLSTATE: X0Y32Statement 'getProcedureColumns'
Posted by Knut Anders Hatlen <kn...@oracle.com>.
Mani Afschar Yazdi <ma...@jq-consulting.de> writes:
> Derby run out of memory and I killed the process because it did not
> respond at all for more than 10 min, no CPU activity. After starting
> derby, when trying to connect to a database I get th following error
> message. Can you help? I can provide the whole database if necessary.
Hi Mani,
The error seems to have happened on the database server, whereas the
stack traces you posted come from the client. Do you still have the
server's derby.log file? Does it show any exceptions?
(If you can't find the exception on the server, you may need to set the
derby.stream.error.logSeverityLevel system property to 0 in the server
process to get it to log all exceptions.)
--
Knut Anders