On 28/01/2010, at 2:45 PM, Lachlan Deck wrote: > On 27/01/2010, at 2:03 AM, Andrus Adamchik wrote: > >> So do you have a stack trace of the error BTW? > > Yep - apologies for the delay. See below.
Woops, looks like this was from a NamedQuery. > with regards, > -- > > Lachlan Deck > > ObjEntity.name: AttachmentInfo > DbEntity.name: BinaryInfo > > --- from client --- > ERROR ish.oncourse.cayenne.CayenneContext :453 - A fatal error has occurred > in onCourse. > [java] org.apache.cayenne.CayenneRuntimeException: [v.3.0RC1 Dec 27 2009 > 11:39:09] [v.3.0RC1 Dec 27 2009 11:39:09] Exception processing message > org.apache.cayenne.remote.QueryMessage of type Query > [java] at > org.apache.cayenne.remote.service.BaseRemoteService.processMessage(BaseRemoteService.java:167) > [java] at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source) > [java] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > [java] at java.lang.reflect.Method.invoke(Method.java:597) > [java] at > com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java:180) > [java] at > com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java:109) > [java] at > com.caucho.hessian.server.HessianServlet.service(HessianServlet.java:396) > [java] at > org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) > [java] at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) > [java] at > ish.oncourse.server.SecurityFilter.doFilter(SecurityFilter.java:111) > [java] at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) > [java] at > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) > [java] at > org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) > [java] at > org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) > [java] at > org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) > [java] at > org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) > [java] at > org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) > [java] at > org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) > [java] at org.mortbay.jetty.Server.handle(Server.java:326) > [java] at > org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) > [java] at > org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:938) > [java] at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:842) > [java] at > org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) > [java] at > org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) > [java] at > org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) > [java] at > org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) > [java] Caused by: java.lang.Exception: Table/View 'ATTACHMENTINFO' does > not exist. > [java] at > org.apache.cayenne.remote.service.BaseRemoteService.processMessage(BaseRemoteService.java:160) > [java] ... 25 more > > --- from server --- > INFO org.apache.cayenne.remote.service.BaseRemoteService :156 - error > processing message > [java] java.sql.SQLSyntaxErrorException: Table/View 'ATTACHMENTINFO' does > not exist. > [java] at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown > Source) > [java] at > org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > [java] at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > [java] at > org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown > Source) > [java] at > org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > [java] at > org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > [java] at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) > [java] at > org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source) > [java] at > org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source) > [java] at > org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source) > [java] at > org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source) > [java] at > org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) > [java] at > org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) > [java] at > org.apache.cayenne.conn.ConnectionWrapper.prepareStatement(ConnectionWrapper.java:281) > [java] at > org.apache.cayenne.conn.ConnectionWrapper.prepareStatement(ConnectionWrapper.java:287) > [java] at > org.apache.cayenne.access.TransactionConnectionDecorator.prepareStatement(TransactionConnectionDecorator.java:186) > [java] at > org.apache.cayenne.access.jdbc.SQLTemplateAction.execute(SQLTemplateAction.java:155) > [java] at > org.apache.cayenne.access.jdbc.SQLTemplateAction.performAction(SQLTemplateAction.java:134) > [java] at > org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87) > [java] at > org.apache.cayenne.access.DataNode.performQueries(DataNode.java:269) > [java] at > org.apache.cayenne.access.DataDomainQueryAction.runQuery(DataDomainQueryAction.java:418) > [java] at > org.apache.cayenne.access.DataDomainQueryAction.access$000(DataDomainQueryAction.java:65) > [java] at > org.apache.cayenne.access.DataDomainQueryAction$2.transform(DataDomainQueryAction.java:391) > [java] at > org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:850) > [java] at > org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(DataDomainQueryAction.java:388) > [java] at > org.apache.cayenne.access.DataDomainQueryAction.execute(DataDomainQueryAction.java:117) > [java] at > org.apache.cayenne.access.DataDomain.onQuery(DataDomain.java:743) > [java] at > org.apache.cayenne.util.ObjectContextQueryAction.runQuery(ObjectContextQueryAction.java:333) > [java] at > org.apache.cayenne.util.ObjectContextQueryAction.execute(ObjectContextQueryAction.java:96) > [java] at > org.apache.cayenne.access.DataContext.onQuery(DataContext.java:1278) > [java] at > org.apache.cayenne.access.ClientServerChannelQueryAction.runQuery(ClientServerChannelQueryAction.java:119) > [java] at > org.apache.cayenne.access.ClientServerChannelQueryAction.execute(ClientServerChannelQueryAction.java:65) > [java] at > org.apache.cayenne.access.ClientServerChannel.onQuery(ClientServerChannel.java:81) > [java] at > org.apache.cayenne.remote.service.DispatchHelper.dispatch(DispatchHelper.java:39) > [java] at > org.apache.cayenne.remote.service.BaseRemoteService.processMessage(BaseRemoteService.java:152) > [java] at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source) > [java] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > [java] at java.lang.reflect.Method.invoke(Method.java:597) > [java] at > com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java:180) > [java] at > com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java:109) > [java] at > com.caucho.hessian.server.HessianServlet.service(HessianServlet.java:396) > [java] at > org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) > [java] at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) > [java] at > ish.oncourse.server.SecurityFilter.doFilter(SecurityFilter.java:111) > [java] at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) > [java] at > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) > [java] at > org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) > [java] at > org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) > [java] at > org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) > [java] at > org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) > [java] at > org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) > [java] at > org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) > [java] at org.mortbay.jetty.Server.handle(Server.java:326) > [java] at > org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) > [java] at > org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:938) > [java] at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:842) > [java] at > org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) > [java] at > org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) > [java] at > org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) > [java] at > org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) > [java] Caused by: java.sql.SQLException: Table/View 'ATTACHMENTINFO' does > not exist. > [java] at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > [java] at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown > Source) > [java] ... 60 more > [java] Caused by: ERROR 42X05: Table/View 'ATTACHMENTINFO' does not exist. > [java] at > org.apache.derby.iapi.error.StandardException.newException(Unknown Source) > [java] at > org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown > Source) with regards, -- Lachlan Deck
