Re: EJBQL client-side challenge

From: Lachlan Deck (lachlan.dec..mail.com)
Date: Thu Jan 28 2010 - 23:54:35 EST

  • Next message: Andrus Adamchik: "Re: Restart RC2?"

    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



    This archive was generated by hypermail 2.0.0 : Thu Jan 28 2010 - 23:55:21 EST