cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lachlan Deck <lachlan.d...@gmail.com>
Subject Re: EJBQL client-side challenge
Date Thu, 28 Jan 2010 03:45:22 GMT
On 27/01/2010, at 2:03 AM, Andrus Adamchik wrote:

> On Jan 26, 2010, at 4:50 PM, Lachlan Deck wrote:
> 
>> Strictly speaking, yes. But you could also say that one is a derivative of the other.
e.g., upper-casing camel casing and joined via underscore which is a common db mapping (which
perhaps cayenne allows for, especially when reverse engineering).
> 
> No, Cayenne doesn't make any such adhoc conversions. So MT_TABLE and MtTable1 are different
names, and the framework will not attempt a conversion.
> 
> So do you have a stack trace of the error BTW?

Yep - apologies for the delay. See below.

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)
Mime
View raw message