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)
This archive was generated by hypermail 2.0.0 : Wed Jan 27 2010 - 22:46:11 EST