http://blog.gmane.org/gmane.comp.java.cayenne.user hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://comments.gmane.org/gmane.comp.java.cayenne.user/14602 <pre>Sorry guys, I am posting this bugger again. But it has turned out to be a bummer for me. I am using NetBeans 7.1.1 JDK 1.7 cayenne files are in the folder - "/WEB-INF/config/cayenne-files". Total three files cayenne.xml, map and node files. Error: "[v.3.0.2 Jun 11 2011 09:26:09] Error during Configuration initialization. [v.3.0.2 Jun 11 2011 09:26:09] [org.apache.cayenne.conf.DefaultConfiguration] : Domain configuration file "cayenne.xml" is not found." My XML File section for cayenne: " &lt;filter&gt; &lt;filter-name&gt;CayenneFilter&lt;/filter-name&gt; &lt;filter-class&gt;org.apache.cayenne.conf.WebApplicationContextFilter&lt;/filter-class&gt; &lt;/filter&gt; &lt;filter-mapping&gt; &lt;filter-name&gt;CayenneFilter&lt;/filter-name&gt; &lt;url-pattern&gt;/*&lt;/url-pattern&gt; &lt;/filter-mapping&gt; &lt;context-param&gt; &lt;param-name&gt;cayenne.configuration.path&lt;/param-name&gt; &lt;param-value&gt;/WEB-INF/config/cayenne-files&lt;/param-value&gt; &lt;/context-param&gt; " Thanks in Advance I have searched this where I can - but not able to find a solution. Thanks KM </pre> Kanwar Manish 2012-05-24T07:13:27 http://comments.gmane.org/gmane.comp.java.cayenne.user/14600 <pre>Hi all, I'm trying to use the query cache of Cayenne 3.0. My code snippet for the typical query is: private List query(Expression qualifier) { DataContext context = config.getDomain("MyDomain").createDataContext(); SelectQuery select = new SelectQuery(MyClass.class, qualifier); select.setCacheStrategy(QueryCacheStrategy.SHARED_CACHE); return context.performQuery(select); } With this code, if I call my query() method in the following way List b is empty: Expression qualifier = ... //my filters List a = query(qualifier); DataContext context = config.getDomain("MyDomain").createDataContext(); //this is another context with respect to the one used in query() MyClass newObj = context.newObject(MyClass .class); // set props of newObj context.commitChanges(); List b = query(qualifier); //the same qualifier resulting in List a The problem seems related to the fact that committing the changes regarding the newly created object doesn't result in a refresh of the Cayenne cache, and so the very same result retrieved for List a is returned also for List b. Is there any setting or configuration that I need to enable? Is there any command that I need to issue in order to invalidate the preiovus results of the cache in this example? Thank you very much Best cghersi -- View this message in context: http://cayenne.195.n3.nabble.com/Cayenne-cache-strategy-tp4008506.html Sent from the Cayenne - User mailing list archive at Nabble.com. </pre> cghersi 2012-05-23T12:07:48 http://comments.gmane.org/gmane.comp.java.cayenne.user/14598 <pre> I'm trying to implement a Spring Security Authentication using Cayenne. The problem is that when the spring security gets called, there's no context associated with the thread. So this method: BaseContext.getThreadObjectContext(); Throws an exception. I'm just not sure at this point how to set up the context and start the process of doing fetches. Tony</pre> Tony Giaccone 2012-05-23T05:36:20 http://comments.gmane.org/gmane.comp.java.cayenne.user/14591 <pre>Hello, I am a newbie with in cayenne and in english too. I am using cayenne 3.0.2 Here is my probleme I have two tables let say *table1 (id1, name, surname)* and *table2(id2, title, amount)* with oracle database And my query is like this select name, title, amount from table1, table2 where id1=id2 Now my question : Would you show me , how can I end up with it (concrete example please)? (I mean my result must be objetcs []). I did not see anything in the cayenne doc that meet my needs. Thank you very much for your help -- View this message in context: http://cayenne.195.n3.nabble.com/Queries-with-multiple-tables-and-results-tp4006413.html Sent from the Cayenne - User mailing list archive at Nabble.com.</pre> pk_cayenne 2012-05-22T10:54:48 http://comments.gmane.org/gmane.comp.java.cayenne.user/14585 <pre>I've been slowing migrating my apps to 3.1M3. I was working on one yesterday and tweaked the data model. When I went to use the "Migrate" tool, I hit the exception listed below. FWIW, I'm running the modeler via cayenne-modeler:run (the maven plugin). I've seen this now with 2 different projects/models. Both are connecting to a MySQL database. Has anybody else seen this? I'll take a look at tracking it down, but I'm pretty swamped for the next week or so. Robert java.lang.NullPointerException at org.apache.cayenne.merge.AbstractToDbToken.executeSql(AbstractToDbToken.java:54) at org.apache.cayenne.merge.AbstractToDbToken.execute(AbstractToDbToken.java:45) at org.apache.cayenne.modeler.dialog.db.MergerOptions.generateSchemaAction(MergerOptions.java:427) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:491) at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:785) at ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:61) at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:819) at ognl.ASTMethod.getValueBody(ASTMethod.java:75) at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170) at ognl.SimpleNode.getValue(SimpleNode.java:210) at ognl.Ognl.getValue(Ognl.java:333) at ognl.Ognl.getValue(Ognl.java:413) at ognl.Ognl.getValue(Ognl.java:395) at org.apache.cayenne.swing.BindingBase.getValue(BindingBase.java:168) at org.apache.cayenne.swing.ActionBinding.fireAction(ActionBinding.java:80) at org.apache.cayenne.swing.ActionBinding$1.actionPerformed(ActionBinding.java:42) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2028) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2351) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.Component.processMouseEvent(Component.java:6375) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6140) at java.awt.Container.processEvent(Container.java:2083) at java.awt.Component.dispatchEventImpl(Component.java:4737) at java.awt.Container.dispatchEventImpl(Container.java:2141) at java.awt.Component.dispatchEvent(Component.java:4565) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4619) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4280) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4210) at java.awt.Container.dispatchEventImpl(Container.java:2127) at java.awt.Window.dispatchEventImpl(Window.java:2482) at java.awt.Component.dispatchEvent(Component.java:4565) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:684) at java.awt.EventQueue.access$000(EventQueue.java:85) at java.awt.EventQueue$1.run(EventQueue.java:643) at java.awt.EventQueue$1.run(EventQueue.java:641) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98) at java.awt.EventQueue$2.run(EventQueue.java:657) at java.awt.EventQueue$2.run(EventQueue.java:655) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:654) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:205) at java.awt.Dialog$1.run(Dialog.java:1044) at java.awt.Dialog$3.run(Dialog.java:1096) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1094) at java.awt.Component.show(Component.java:1584) at java.awt.Component.setVisible(Component.java:1536) at java.awt.Window.setVisible(Window.java:841) at java.awt.Dialog.setVisible(Dialog.java:984) at org.apache.cayenne.modeler.dialog.db.MergerOptions.startupAction(MergerOptions.java:230) at org.apache.cayenne.modeler.action.MigrateAction.performAction(MigrateAction.java:67) at org.apache.cayenne.modeler.util.CayenneAction.actionPerformed(CayenneAction.java:162) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2028) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2351) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.AbstractButton.doClick(AbstractButton.java:389) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:809) at com.apple.laf.AquaMenuItemUI.doClick(AquaMenuItemUI.java:137) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:850) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.Component.processMouseEvent(Component.java:6375) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6140) at java.awt.Container.processEvent(Container.java:2083) at java.awt.Component.dispatchEventImpl(Component.java:4737) at java.awt.Container.dispatchEventImpl(Container.java:2141) at java.awt.Component.dispatchEvent(Component.java:4565) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4619) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4280) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4210) at java.awt.Container.dispatchEventImpl(Container.java:2127) at java.awt.Window.dispatchEventImpl(Window.java:2482) at java.awt.Component.dispatchEvent(Component.java:4565) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:684) at java.awt.EventQueue.access$000(EventQueue.java:85) at java.awt.EventQueue$1.run(EventQueue.java:643) at java.awt.EventQueue$1.run(EventQueue.java:641) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98) at java.awt.EventQueue$2.run(EventQueue.java:657) at java.awt.EventQueue$2.run(EventQueue.java:655) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:654) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) </pre> Robert Zeigler 2012-05-17T18:39:11 http://comments.gmane.org/gmane.comp.java.cayenne.user/14579 <pre>We need to fetch objects from a second database. (That is, query an entity in a second domain.) I've tried a couple of quick things -- putting two domains in one cayenne.xml project -- but I've been unable to make it work, in Cayenne 3.0.2 anyway. I found CAY-1318 which says, "Multi-datadomain runtime configurations offer no advantage over multiple configurations with a single domain each. So going to change the project structure to only support a single DataDomain." It says it was fixed in 3.1. So if we upgrade to 3.1 will we have an easier time? Are there any examples of querying from multiple configurations? Thanks, Bryan Lewis </pre> Bryan Lewis 2012-05-17T12:06:12 http://comments.gmane.org/gmane.comp.java.cayenne.user/14576 <pre>Hi all, i'm just in the process of creating a web application bound to cayenne in the backend. I'm using external transactions (XA with multiple databases) and basically start/commit/rollback a transaction whenever i have something to change inside the databases. While this is working fine i'm trying to understand the way cayenne behaves regarding the object context lifecycle. Imagine the following use case: startTX(); List&lt;Object&gt; objects = querySomeObjectsViaTheObjectContext(); commitTX(); or rollbackTX(); If i understand correctly relationships are not necessary resolved directly but lazy when accessed through an object. My question now is how does the object context behave when it has to fetch some additional objects due to relationships that have to be resolved on access? I mean obviously the object context is no longer valid (?) as potentially the external transaction manager might have closed it's correspodning datasource and returned it back to the connection pool. However the objects in my list are still available in memory and can be used although cannot be modified easily or be committed in the next transaction as they of course don't belong to the newly created object context. So what i'm doing right now (and i'm sure i'm missing some important facsts as this is a really hack solution) is to create a new transaction, requery all the objects i modified and transfer all modified attributes to the ones i just got back from the query. I'd really appreciate some explanation on how you guys approach stuff like, i mean it's obvious that i have to store the objects in a user interface (showing them in a table or whatever) but cannot keep and transaction ongoing as long as the user interface is waiting for some interaction. Cheers, Daniel </pre> Daniel Scheibe 2012-05-16T20:47:35 http://comments.gmane.org/gmane.comp.java.cayenne.user/14574 <pre>This is an follow-up to a question I asked previously. **** To re-cap In the context of a web-app (i.e. you don't know who your users are, or what kind of absurd 'give me everything and let me sort' actions they might take), I need to be able to support real-time sorting of perhaps large result sets. So the recommendation was to prefer the DBMS sort over Cayenne in-memory sort (which would fault all of the result-set dataobjects). I can sort of understand the rational that it is better to re-submit the query with a new sort-by request, as this will ultimately be more memory efficient. Requirements Also, I have some fairly advanced pre-built search methods that support often-used searches. It is the results of these searches that may be sorted several times and in several different ways by the user. **** Interesting Side-effect In order to implement the 'let the DBMS do it' pattern, I created a SearchFactory class that stores the pre-built Cayenne SelectQuery, so that I can resubmit it to Cayenne with a user chosen sort-by specification. Here are some questions: 1. I have to store the SelectQuery in a custom session object. This *seems* like a good idea but since I have never done this, I was wondering if storing a query might not be memory-efficient. i.e. does this object hold on to any result sets? 2. This pattern essentially makes some of the very cool Cayenne ORM features useless. i.e. I can no longer simply request the Vendor's associated product list by doing a Cayenne 'vendor.getProductList()', since I can't store the query (as I need to do in order to re-submit the query with a new Ordering object). This is all working, but since I have to make a *lot* of changes in my code, I want to make sure it is the best solution with Cayenne. Does all of this sound reasonable, or am I missing some simpler way of implementing this solution? Thanks Joe </pre> Joe Baldwin 2012-05-16T17:47:02 http://comments.gmane.org/gmane.comp.java.cayenne.user/14572 <pre> So here's my situation. I'm building a framework, where I'd like to let my development team choose to use either sql light or postgres on a shared server as the persistent store. Using SQLite lets them do development locally with out having to install Postgress on each workstation and or be dependent on a central shared postgres server. My first thought was to create two different models and then pick one in the web.xml file. I'm sure this would work, but the model name would have to be different for each model, so as to avoid file name collision. I'm not really keen on that idea, because the models are the same and vary only in the values in the data node. And then I thought I could put them in different folders, which represented the datanode file. resources/sqlite/myCayenneModel.xml resources/postgres/myCayenneModel.xml But it's not clear to me, how that is handled in the web.xml file. The filter name is the name of the model, no? How do you manage that if the model is not at the top level of the classpath? After thinking about it, it seems to me the best solution is to ask you all. Just to be pedantic here's the problem. I have two different data models which essentially different only in the value of the data node. I want to be able to choose one model at compile time. I don't want to have to change any java code to make the choice. I'd prefer to just edit the web.xml file. Anyone have a solution? Tony Giaccone </pre> Tony Giaccone 2012-05-15T21:59:19 http://comments.gmane.org/gmane.comp.java.cayenne.user/14565 <pre>Hi, I am trying to figure some way to get the number or queries and time elapsed in a DataContext, or something similar, I want to get agregate data about DB performance and be able to find where we should try to reduce the number of DB queries. I thought I could use some kind of ServletFilter to get the data and post back as headers or something like that, but I don't se anywhere how I can get this information, the best I can see is that all that information is logged but not agregated, so maybe I could create a custom QueryLogger, but I can not see any way to inject a custom QueryLogger either so I am lost. Maybe this is a marginal use case but I think this is a interesting feature for everyone using Cayenne in production enviroments to gather information without having to parse the logs. Ramiro Aparicio </pre> Ramiro Aparicio 2012-05-09T17:28:13 http://comments.gmane.org/gmane.comp.java.cayenne.user/14564 <pre>Hi, I have a bunch of named queries in my application.map.xml... And cayenne does not seems to be escaping the parameter values when these queries are executed Is there a way I can SWITCH ON escaping for these named queries in cayenne or is there no way and I will have to manually escape the parameter values passed to these queries ?? Thanks </pre> Simran Narula 2012-05-07T03:45:48 http://comments.gmane.org/gmane.comp.java.cayenne.user/14542 <pre>Hi,I have a relation Applicant in which all user details are stored. I want to give user an option of updating his details so i want to know how to update Applicant relation in cayenne. Its quite similar like MERGE in JPA where old date has been replaced if any new changes have been made to the existing one.Now i want to do this in cayenne.. Thanks in advance -- View this message in context: http://cayenne.195.n3.nabble.com/Merge-operation-tp3954774.html Sent from the Cayenne - User mailing list archive at Nabble.com. </pre> yunus 2012-05-02T10:29:05 http://comments.gmane.org/gmane.comp.java.cayenne.user/14521 <pre>Hello, I'm French so I'm sorry if I make some mistakes. I have created a database and I have generated classes thanks to Cayenne. Driver used : org.apache.derby.jdbc.EmbeddedDriver URL : jdbc:derby:database I have created a "main" class to insert and delete some informations from the database (it's not a memory database). It works perfectly and this, from a remote client. Now I want to connect more than one client on the database at the same time. So in CayenneModeler I change the driver and the URL : Driver used : org.apache.derby.ClientDriver URL : jdbc:derby://localhost/database After' I launch the jetty server (port 8080) and the derby server (port 1527) from Eclipse. I run the main class in the client machine and I obtain an error : /26-Apr-2012 10:25:15 org.apache.cayenne.access.QueryLogger logConnectFailure INFO: *** Connecting: FAILURE. java.sql.SQLException: Can not load JDBC driver named 'org.apache.derby.jdbc.ClientDriver': org.apache.derby.jdbc.ClientDriver at org.apache.cayenne.conn.DriverDataSource.loadDriver(DriverDataSource.java:59) at org.apache.cayenne.conn.DriverDataSource.setDriverClassName(DriverDataSource.java:253) at org.apache.cayenne.conn.DriverDataSource.&lt;init&gt;(DriverDataSource.java:98) at org.apache.cayenne.conn.DriverDataSource.&lt;init&gt;(DriverDataSource.java:84) at org.apache.cayenne.conn.PoolManager.&lt;init&gt;(PoolManager.java:89) at org.apache.cayenne.conf.DriverDataSourceFactory.getDataSource(DriverDataSourceFactory.java:82) at org.apache.cayenne.conf.RuntimeLoadDelegate.shouldLoadDataNode(RuntimeLoadDelegate.java:334) at org.apache.cayenne.conf.ConfigLoader$NodeHandler.init(ConfigLoader.java:345) at org.apache.cayenne.conf.ConfigLoader$DomainHandler.startElement(ConfigLoader.java:222) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at org.apache.cayenne.conf.ConfigLoader.loadDomains(ConfigLoader.java:78) at org.apache.cayenne.conf.DefaultConfiguration.initialize(DefaultConfiguration.java:152) at org.apache.cayenne.remote.service.BaseRemoteService.initCayenneStack(BaseRemoteService.java:207) at org.apache.cayenne.remote.service.BaseRemoteService.initService(BaseRemoteService.java:76) at org.apache.cayenne.remote.hessian.service.HessianService.init(HessianService.java:65) at org.apache.cayenne.remote.hessian.service.HessianServlet.init(HessianServlet.java:76) at org.mortbay.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:440) at org.mortbay.jetty.servlet.ServletHolder.getServlet(ServletHolder.java:339) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:938) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:842) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) 26-Apr-2012 10:25:15 org.apache.cayenne.conf.RuntimeLoadDelegate shouldLoadDataNode INFO: Error: DataSource load failed java.sql.SQLException: Can not load JDBC driver named 'org.apache.derby.jdbc.ClientDriver': org.apache.derby.jdbc.ClientDriver at org.apache.cayenne.conn.DriverDataSource.loadDriver(DriverDataSource.java:59) at org.apache.cayenne.conn.DriverDataSource.setDriverClassName(DriverDataSource.java:253) at org.apache.cayenne.conn.DriverDataSource.&lt;init&gt;(DriverDataSource.java:98) at org.apache.cayenne.conn.DriverDataSource.&lt;init&gt;(DriverDataSource.java:84) at org.apache.cayenne.conn.PoolManager.&lt;init&gt;(PoolManager.java:89) at org.apache.cayenne.conf.DriverDataSourceFactory.getDataSource(DriverDataSourceFactory.java:82) at org.apache.cayenne.conf.RuntimeLoadDelegate.shouldLoadDataNode(RuntimeLoadDelegate.java:334) at org.apache.cayenne.conf.ConfigLoader$NodeHandler.init(ConfigLoader.java:345) at org.apache.cayenne.conf.ConfigLoader$DomainHandler.startElement(ConfigLoader.java:222) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at org.apache.cayenne.conf.ConfigLoader.loadDomains(ConfigLoader.java:78) at org.apache.cayenne.conf.DefaultConfiguration.initialize(DefaultConfiguration.java:152) at org.apache.cayenne.remote.service.BaseRemoteService.initCayenneStack(BaseRemoteService.java:207) at org.apache.cayenne.remote.service.BaseRemoteService.initService(BaseRemoteService.java:76) at org.apache.cayenne.remote.hessian.service.HessianService.init(HessianService.java:65) at org.apache.cayenne.remote.hessian.service.HessianServlet.init(HessianServlet.java:76) at org.mortbay.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:440) at org.mortbay.jetty.servlet.ServletHolder.getServlet(ServletHolder.java:339) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:938) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:842) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) 26-Apr-2012 10:25:15 org.apache.cayenne.conf.RuntimeLoadDelegate initAdapter INFO: no adapter set, using automatic adapter. 26-Apr-2012 10:25:15 org.apache.cayenne.conf.RuntimeLoadDelegate shouldLinkDataMap INFO: loaded map-ref: DomainMap. 2012-04-26 10:25:15.859:WARN:/tutorial:unavailable org.apache.cayenne.CayenneRuntimeException: [v.3.0.2 Jun 19 2011 09:29:50] Error starting Cayenne at org.apache.cayenne.remote.service.BaseRemoteService.initCayenneStack(BaseRemoteService.java:211) at org.apache.cayenne.remote.service.BaseRemoteService.initService(BaseRemoteService.java:76) at org.apache.cayenne.remote.hessian.service.HessianService.init(HessianService.java:65) at org.apache.cayenne.remote.hessian.service.HessianServlet.init(HessianServlet.java:76) at org.mortbay.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:440) at org.mortbay.jetty.servlet.ServletHolder.getServlet(ServletHolder.java:339) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:938) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:842) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) 2012-04-26 10:25:15.859:WARN::/tutorial/cayenne-service org.apache.cayenne.CayenneRuntimeException: [v.3.0.2 Jun 19 2011 09:29:50] Error starting Cayenne at org.apache.cayenne.remote.service.BaseRemoteService.initCayenneStack(BaseRemoteService.java:211) at org.apache.cayenne.remote.service.BaseRemoteService.initService(BaseRemoteService.java:76) at org.apache.cayenne.remote.hessian.service.HessianService.init(HessianService.java:65) at org.apache.cayenne.remote.hessian.service.HessianServlet.init(HessianServlet.java:76) at org.mortbay.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:440) at org.mortbay.jetty.servlet.ServletHolder.getServlet(ServletHolder.java:339) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:938) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:842) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) / One project on the server, with all generated classes (CayenneModeler). One Database on the server. One project on the client with all generated classes and one main class which connect to the server. I launch two servers : Jetty Server and Derby Server. I tried to do the same things but on the same computer, and I have the same error. I tried to enter an unknown driver and I have the same error. I verify in the library if the driver is here : http://http://www.hostingpics.net/viewer.php?id=139903untitled.png http://www.hostingpics.net/viewer.php?id=139903untitled.png Thanks Tadrierion -- View this message in context: http://cayenne.195.n3.nabble.com/Can-not-load-JDBC-driver-named-org-apache-derby-jdbc-ClientDriver-tp3950272.html Sent from the Cayenne - User mailing list archive at Nabble.com. </pre> Tadrierion 2012-04-30T09:09:51 http://comments.gmane.org/gmane.comp.java.cayenne.user/14518 <pre>Hi, i have problem..I want to fetch data from two tables which are inter related through primary key Scenario is: I have table Applicant in which there are attribute "name" &amp; "ration_Id" and other table is Certificate which include attribute "status".Now i want to fetch data from both tables on the basis of "EnrolmentId" which is primary key of Applicant table and foreign key for Certificate and (then validation will be applied on obtained list ) how to store that list i.e*.list type* In Sql..it can be like this "Select a.name,a.ration_Id,c.status from Applicant a,Certificate c where a.enrolmentI=c.enrolmentId" But i want to know how to write it in Cayenne. -- View this message in context: http://cayenne.195.n3.nabble.com/Fetching-data-from-two-related-tables-simultaneoulsy-tp3943892p3943892.html Sent from the Cayenne - User mailing list archive at Nabble.com. </pre> yunus 2012-04-27T10:01:45 http://comments.gmane.org/gmane.comp.java.cayenne.user/14516 <pre>Hi everyone, recentlty i add to rework on a project that used Cayenne 3.0.1 . I did two modification: - upgrade to cayenne 3.0.2 ( worked fine ) - i had to change (by dba request ) one of my relationship join, adding another field in the relationship from RICORSI_PENDENTI to VER_CDS ( field CODENTE) When i access one side of the relation ship from RICORSI_PENDENTI to VER_CDS i get this exception. 10:06:32,952 INFO QueryLogger - SELECT t0.AKEY, t0.CODENTE, t0.NUMEROSOGGETTI, t0.DATARUOLO, t0.DATAACCERTAMENTO, t0.ORAVERBALIZZAZIONE, t0.TARGA, t0.ID_VERBALIZZ1, t0.DATANOTIFICAINGIUNZIONE, t0.ID_VERBALIZZ2, t0.LUOGO_VERB, t0.NUMEROBOLLETTA, t0.TIPOTARGA, t0.RACCOMANDATAVERBALE, t0.SPESEAMMVE, t0.TIPOSUPPLEMENTARE, t0.DATAVERBALE, t0.FLAG_VARI, t0.VERBALIZZANTE1, t0.VERBALIZZANTE2, t0.ID_STRADA2, t0.VERBALIZZANTE3, t0.ID_STRADA1, t0.USOMEZZO, t0.LOCATARIO, t0.SPESEALTRE, t0.TIPOMEZZO, t0.NUMEROCIVICO, t0.PROTOCOLLOVERBALE, t0.DATARICORSO, t0.CODICESINISTRO, t0.DATAVERBALIZZAZIONE, t0.TIPOV, t0.NUMEROREGISTRO, t0.TIPOVERBALE, t0.TIPO_VIOLAZ, t0.STRADA1, t0.STRADA2, t0.DATASPEDIZIONEVERBALE, t0.MODELLO, t0.AUSILIARIO, t0.IMPORTOSANZIONI, t0.NAZIONE, t0.DATATRASMISSIONE, t0.TELAIO, t0.ORAACCERTAMENTO, t0.SPESEPOSTALI, t0.DATATRASMISSIONERICORSO, t0.ID_LUOGO_VERB, t0.ANNOVERBALE, t0.NOMEOPERATORE, t0.KILOMETRO, t0.DATANOTIFICAVERBALE, t0.MARCA, t0.VALUTA, t0.AGENTE2, t0.AGENTE1, t0.STATOVERBALE, t0.ID_SINISTRO, t0.SUBSTATO, t0.DATAARCHIVIAZIONE, t0.RIMOSSO FROM piemme.VER_CDS t0 WHERE (t0.AKEY = ?) AND (t0.CODENTE = ?) [bind: 1:200019405, 2:'H211'] 10:06:32,968 INFO QueryLogger - === returned 1 row. - took 18 ms. 10:06:32,972 INFO QueryLogger - +++ transaction committed. [Click] [error] handleException: org.apache.cayenne.FaultFailureException: [v.3.0.2 apr 20 2012 16:13:44] Error resolving fault for ObjectId: &lt;ObjectId:VerCds, AKEY=200019405, CODENTE=H211&gt; and state (hollow). Possible cause - matching row is missing from the database. at org.apache.cayenne.BaseContext.prepareForAccess(BaseContext.java:171) at org.apache.cayenne.CayenneDataObject.readProperty(CayenneDataObject.java:219) at com.sapidata.piemme.domain.VerCds.getAnagrafiche(VerCds.java:50) at com.sapidata.piemme.domain.VerCds.getAnagrafeNotificata(VerCds.java:61) at com.sapidata.ricorsi.web.user.InfoPage.onInit(InfoPage.java:71) at net.sf.click.ClickServlet.processPage(ClickServlet.java:509) at net.sf.click.ClickServlet.handleRequest(ClickServlet.java:331) at net.sf.click.ClickServlet.doGet(ClickServlet.java:250) at javax.servlet.http.HttpServlet.service(HttpServlet.java:627) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at net.sf.click.extras.cayenne.DataContextFilter.doFilter(DataContextFilter.java:238) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:662) It seems to me that the object VerCds( VER_CDS ) gets fetched from Cayenne, but for some reason i get a Fault where accessing property "anagrafiche" which in turn is a relationship. if i get back to a single field relathionship from RICORSI_PENDENTI to VER_CDS i don't get the fault and all the relationship of VER_CDS get correctly fetched: 12:21:23,124 INFO QueryLogger - SELECT t0.AKEY, t0.CODENTE, t0.NUMEROSOGGETTI, t0.DATARUOLO, t0.DATAACCERTAMENTO, t0.ORAVERBALIZZAZIONE, t0.TARGA, t0.ID_VERBALIZZ1, t0.DATANOTIFICAINGIUNZIONE, t0.ID_VERBALIZZ2, t0.LUOGO_VERB, t0.NUMEROBOLLETTA, t0.TIPOTARGA, t0.RACCOMANDATAVERBALE, t0.SPESEAMMVE, t0.TIPOSUPPLEMENTARE, t0.DATAVERBALE, t0.FLAG_VARI, t0.VERBALIZZANTE1, t0.VERBALIZZANTE2, t0.ID_STRADA2, t0.VERBALIZZANTE3, t0.ID_STRADA1, t0.USOMEZZO, t0.LOCATARIO, t0.SPESEALTRE, t0.TIPOMEZZO, t0.NUMEROCIVICO, t0.PROTOCOLLOVERBALE, t0.DATARICORSO, t0.CODICESINISTRO, t0.DATAVERBALIZZAZIONE, t0.TIPOV, t0.NUMEROREGISTRO, t0.TIPOVERBALE, t0.TIPO_VIOLAZ, t0.STRADA1, t0.STRADA2, t0.DATASPEDIZIONEVERBALE, t0.MODELLO, t0.AUSILIARIO, t0.IMPORTOSANZIONI, t0.NAZIONE, t0.DATATRASMISSIONE, t0.TELAIO, t0.ORAACCERTAMENTO, t0.SPESEPOSTALI, t0.DATATRASMISSIONERICORSO, t0.ID_LUOGO_VERB, t0.ANNOVERBALE, t0.NOMEOPERATORE, t0.KILOMETRO, t0.DATANOTIFICAVERBALE, t0.MARCA, t0.VALUTA, t0.AGENTE2, t0.AGENTE1, t0.STATOVERBALE, t0.ID_SINISTRO, t0.SUBSTATO, t0.DATAARCHIVIAZIONE, t0.RIMOSSO FROM piemme.VER_CDS t0 WHERE t0.AKEY = ? [bind: 1:200019405] 12:21:23,130 INFO QueryLogger - === returned 1 row. - took 7 ms. 12:21:23,130 INFO QueryLogger - +++ transaction committed. 12:21:23,131 INFO QueryLogger - --- will run 1 query. 12:21:23,131 INFO QueryLogger - --- transaction started. 12:21:23,134 INFO QueryLogger - SELECT DISTINCT t0.CODICENOTIFICAING, t0.CODICECONTRIBUENTE, t0.LUOGORESIDENZA, t0.LUOGORILASCIODOCUMENTO, t0.CODFISCOMUNENASCITA, t0.DATANOTIFICAINGIUNZIONE, t0.ANNONASCITA, t0.PROVRESIDENZA, t0.DATAPASSAGGIOPROPRIETA, t0.DATAIDENTIFICAZIONE, t0.SESSO, t0.SPESEPT, t0.CODICEFISCALE, t0.NUMERODOCUMENTO, t0.SOCIETA, t0.CODENTE, t0.LUOGONASCITA, t0.INDIRIZZORESIDENZA, t0.PARTITAIVA, t0.TIPOANAGRAFICA, t0.PARENTPROP, t0.PARENT, t0.DATANOTIFICARUOLO, t0.DOCUMENTO, t0.DATANOTIFICAVERBALE, t0.COGNOME, t0.PROT_REINTEST, t0.SPESEAM, t0.TIPODOCUMENTO, t0.QUINTOC, t0.ORIGINEDATI, t0.DATAAGGDATI, t0.NUMEROREGISTRO, t0.DATADOCUMENTO, t0.ANNO, t0.DATANASCITA, t0.CAPRESIDENZA, t0.NOME, t0.CODICENOTIFICA, t0.AKEY FROM piemme.ANA_CDS t0 JOIN piemme.VER_CDS t1 ON (t0.PARENT = t1.AKEY AND t0.CODENTE = t1.CODENTE) WHERE t1.AKEY = ? [bind: 1:200019405] 12:21:23,140 INFO QueryLogger - === returned 1 row. - took 9 ms. 12:21:23,140 INFO QueryLogger - +++ transaction committed. 12:21:23,141 INFO QueryLogger - --- will run 1 query. 12:21:23,141 INFO QueryLogger - --- transaction started. 12:21:23,144 INFO QueryLogger - SELECT DISTINCT t0.DATAREVOCA, t0.ESISTERICORSO, t0.IMPORTOORIGINALE, t0.PROTOCOLLO, t0.DATANOTIFICAINGIUNZIONE, t0.IMPORTOINGIUNZIONE, t0.NUMEROBOLLETTA, t0.SPESENOTINGORIG, t0.DATASTAMPA, t0.SPESENOTIFICAINGIUNZIONE, t0.NUM_RG_RICORSO, t0.PROTRICORSO, t0.NOTE, t0.ESITORICORSOING, t0.CODENTE, t0.ANNOVERBALE, t0.ANNOINGIUNZIONE, t0.SPESEINGIUNZIONE, t0.PARENT, t0.NUMEROINGIUNZIONE, t0.NUMEROREGISTRO, t0.SPEDIRE, t0.DATARICORSOING, t0.DATAINGIUNZIONE, t0.DATAESITORICING, t0.DATASOSPENS, t0.AKEY FROM piemme.CINGIUNZ t0 JOIN piemme.VER_CDS t1 ON (t0.PARENT = t1.AKEY AND t0.CODENTE = t1.CODENTE) WHERE t1.AKEY = ? [bind: 1:200019405] 12:21:23,147 INFO QueryLogger - === returned 0 rows. - took 5 ms. 12:21:23,147 INFO QueryLogger - +++ transaction committed. 12:21:23,148 INFO QueryLogger - --- will run 1 query. 12:21:23,148 INFO QueryLogger - --- transaction started. 12:21:23,153 INFO QueryLogger - SELECT DISTINCT t0.GP_MANDDTBENE, t0.CONTRODEDUFFICIO, t0.DTRIMB_SPESEACC, t0.GP_MANDDTRICH, t0.RIFERIMENTI_RIMB, t0.GP_DTDISPOS, t0.GP_TIPOSOSP, t0.GP_NUMRG, t0.NUMEROBOLLETTA, t0.DTRICOUT, t0.GP_DTSOSPFIN, t0.DATA_RIC_PREF, t0.PROTRICOUT, t0.DESCNOPROCED, t0.GP_DISPFL1, t0.GP_ISSPESE, t0.GP_PROTRICOUT, t0.DT_OPERATORE, t0.GP_DISPFL2, t0.GP_DTUDIENZEDONE, t0.DATATRASMPREFETTO2, t0.CATEGORIARICORSO, t0.DATATRASMPREFETTO3, t0.RIFRIMB_SPESEACC, t0.GP_DTTRASMATTI, t0.GP_GGVALPAGA, t0.NOME_OPERATORE, t0.DATA_RICHIESTARIMB, t0.GP_DTUDIENZANEXT, t0.DATARICORSO, t0.PARENT, t0.GP_DTSOSPIN, t0.MOTIVAZIONI, t0.CODENTE, t0.GP_IMPSPES, t0.NUMEROREGISTRO, t0.OBBL_CDEDAGENT, t0.DATASTCONTROD, t0.CODPAG, t0.DATA_BENESTARERRIMB, t0.DISPONIBILE, t0.GP_NOTE_MOTIVAZ, t0.GP_DISPDT2, t0.GP_NOMEGP, t0.GP_DISPDT1, t0.GP_DTVALINI, t0.GP_IMPSANZ, t0.GP_DTRICOUT, t0.AKEY, t0.RICEVUTA, t0.RICORSOTARDIVO, t0.IMPRIMB_SPESEACC, t0.GP_IMPSANZRUO, t0.AUDIZIONE_TIPO, t0.NOTE, t0.AUTORITAGIUDIZIARIA, t0.GP_DISPCHAR3, t0.PROT_RIC_PREF, t0.GP_SPESEPROC, t0.GP_DISPCHAR1, t0.ANNOVERBALE, t0.CONTRODEDUZIONE, t0.GP_DISPCHAR2, t0.PROTOCOLLORICORSO, t0.GP_PROTSPESE, t0.GP_PROTDISPOS, t0.PROTOCOLLOPREFETTO, t0.PROCOTOLLOPREFETTO2, t0.VALUTA, t0.GP_MANDNUM, t0.ESITORICORSO, t0.GP_IMPSPESRUO, t0.PROTOCOLLOPREFETTO3, t0.ANNORICORSO, t0.DATAESITO, t0.DATATRASMPREFETTO, t0.AUDIZIONE, t0.GP_DTSPESE FROM piemme.CRICORSI t0 JOIN piemme.VER_CDS t1 ON (t0.PARENT = t1.AKEY AND t0.CODENTE = t1.CODENTE) WHERE t1.AKEY = ? [bind: 1:200019405] 12:21:23,162 INFO QueryLogger - === returned 1 row. - took 14 ms. 12:21:23,162 INFO QueryLogger - +++ transaction committed. 12:21:23,167 INFO QueryLogger - --- will run 1 query. 12:21:23,167 INFO QueryLogger - --- transaction started. 12:21:23,173 INFO QueryLogger - {? = call piemme.GIORNONONFESTIVONEGATIVO(?, ?)} [bind: 1:'[OUT]', 2:'2008-02-11 00:00:00.0', 3:-10] 12:21:23,196 INFO QueryLogger - === returned 1 row. - took 0 ms. 12:21:23,197 INFO QueryLogger - +++ transaction committed. 12:21:23,202 INFO QueryLogger - --- will run 1 query. 12:21:23,202 INFO QueryLogger - --- transaction started. 12:21:23,204 INFO QueryLogger - SELECT DISTINCT t0.CODENTE, t0.PREF_RIFCONF, t0.ANNOVERBALE, t0.PROTOCOLLO, t0.AKEY, t0.CODICECAUSALE, t0.PARENT, t0.PREF_RIFTRASM, t0.NUMEROBOLLETTA, t0.PREF_DTTRASM, t0.NUMEROARCHIVIAZIONE, t0.DATASTAMPA, t0.NUMEROREGISTRO, t0.PREF_DTCONF, t0.DATAST_LETTERA, t0.ANNOORDINANZA, t0.DATAARCHIVIAZIONE, t0.CAUSALEARCHIVIAZIONE FROM PIEMME.CARCHIV t0 JOIN piemme.VER_CDS t1 ON (t0.PARENT = t1.AKEY AND t0.CODENTE = t1.CODENTE) WHERE t1.AKEY = ? [bind: 1:200019405] 12:21:23,207 INFO QueryLogger - === returned 0 rows. - took 5 ms. 12:21:23,207 INFO QueryLogger - +++ transaction committed. 12:21:23,208 INFO QueryLogger - --- will run 1 query. 12:21:23,209 INFO QueryLogger - --- transaction started. 12:21:23,212 INFO QueryLogger - SELECT V.* FROM PIEMME.VER_CDS V,PIEMME.T180PP T WHERE T.PARENT2_180_8 = 200019405 AND T.CODENTE = ? AND T.PARENT = V.akey AND T.CODENTE = V.CODENTE [bind: 1:'H211'] 12:21:23,222 INFO QueryLogger - === returned 0 rows. - took 10 ms. 12:21:23,223 INFO QueryLogger - +++ transaction committed. 12:21:23,223 INFO QueryLogger - --- will run 1 query. 12:21:23,224 INFO QueryLogger - --- transaction started. 12:21:23,225 INFO QueryLogger - SELECT V.* from PIEMME.VER_CDS V, PIEMME.T180 T WHERE T.PARENT2_180_8 = 200019405 AND T.CODENTE = ? AND T.PARENT = V.akey AND T.CODENTE = V.CODENTE [bind: 1:'H211'] 12:21:23,229 INFO QueryLogger - === returned 0 rows. - took 4 ms. 12:21:23,230 INFO QueryLogger - +++ transaction committed. I think i'm missing somthing in the modeler or my absution of simply adding a filed to the RICORSI_PENDENTI --&gt; VER_CDS relationship is wrong. I hope i've expressed my problem with enough clarity ..... Can somebody please provide some hint to put me in the rigth direction ? Of cource i can fetch Data Rows wrinting an SQLTemplate script for resolving relatiohns on the DB and then manage relathioship programatically, but i would like to use SelectQuery with prefetch instead. Thanks, Marco </pre> Marco Gattei 2012-04-24T10:29:18 http://comments.gmane.org/gmane.comp.java.cayenne.user/14512 <pre>Hi, we are working with Cayenne in a small team. Each of the team members has its own local environment as well as we do have a staging and a production server - again having it's own environments. Ideally, I would want to have only one DataDomain with one DataMap and multiple DataNodes of which I can select the right one at run time. Is this doable? Currently, multiple Cayenne configurations each having one DataDomain with one DataMap and one DataNode which is quite unfortable to handle. Gruß/Regards, Tobias. *Adternity GmbH* Kennedydamm 1 40476 Düsseldorf Tonhallenstraße 16 47051 Duisburg Tel.: +49 203 298685 37 eMail: wolff&lt; at &gt;adternity.net Web: http://www.adternity.net Geschäftsführer: Thomas Servatius, Jörn Mika, Tobias Wolff Amtsgericht: Düsseldorf, HRB 60031 Steuer-Nr.: DE238773677 </pre> Tobias Wolff 2012-04-23T16:14:50 http://comments.gmane.org/gmane.comp.java.cayenne.user/14507 <pre>Hi All I am using Cayenne Modeller version 3.0.2. I am using PostgreSQL 9.1 installed locally. Environment is windows XP. I have defined my data map and added all the tables required in the DB. I have also defined some relationships. I am able to generate the database schema and the tables are being successfully created in the PostgreSQL. However the relationships are not getting created in the DB. I am not getting any errors. Any ideas? Thanks in Advance KM </pre> Kanwar Manish 2012-04-23T13:03:44 http://comments.gmane.org/gmane.comp.java.cayenne.user/14503 <pre>Hi, I have a table in which two attributes are primary key i.e composite.I am trying to access to match it with the user entered values but i am not able to fetch it. So can anyone tell me how to fetch composite key from database using cayenne? -- View this message in context: http://cayenne.195.n3.nabble.com/Finding-composite-key-using-cayenne-tp3925618p3925618.html Sent from the Cayenne - User mailing list archive at Nabble.com. </pre> yunus 2012-04-20T10:12:19 http://comments.gmane.org/gmane.comp.java.cayenne.user/14501 <pre>Hi...i am using JSF for presentation with Maven project and cayenne for persistence...but when i enter the data in jsp page and press action button it gives the following error...please tell me how to solve this... SEVERE: java.lang.NoClassDefFoundError: org/apache/cayenne/query/Query javax.faces.el.EvaluationException: java.lang.NoClassDefFoundError: org/apache/cayenne/query/Query at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102) at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102) at javax.faces.component.UICommand.broadcast(UICommand.java:387) at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:475) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:756) at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82) at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100) at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.NoClassDefFoundError: org/apache/cayenne/query/Query at org.cayenne.Manager.RegisterManager.addRegister(RegisterManager.java:18) at org.cayenne.managedBean.RegisterBean.register(RegisterBean.java:142) 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 org.apache.el.parser.AstValue.invoke(AstValue.java:152) at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276) at org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:68) at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88) ... 20 more Caused by: java.lang.ClassNotFoundException: org.apache.cayenne.query.Query at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1360) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1206) ... 30 more Apr 12, 2012 4:52:03 PM com.sun.faces.lifecycle.InvokeApplicationPhase execute WARNING: #{registerBean.register}: java.lang.NoClassDefFoundError: org/apache/cayenne/query/Query javax.faces.FacesException: #{registerBean.register}: java.lang.NoClassDefFoundError: org/apache/cayenne/query/Query at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:118) at javax.faces.component.UICommand.broadcast(UICommand.java:387) at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:475) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:756) at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82) at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100) at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) Caused by: javax.faces.el.EvaluationException: java.lang.NoClassDefFoundError: org/apache/cayenne/query/Query at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102) at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102) ... 19 more Caused by: java.lang.NoClassDefFoundError: org/apache/cayenne/query/Query at org.cayenne.Manager.RegisterManager.addRegister(RegisterManager.java:18) at org.cayenne.managedBean.RegisterBean.register(RegisterBean.java:142) 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 org.apache.el.parser.AstValue.invoke(AstValue.java:152) at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276) at org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:68) at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88) ... 20 more Caused by: java.lang.ClassNotFoundException: org.apache.cayenne.query.Query at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1360) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1206) ... 30 more Apr 12, 2012 4:52:03 PM com.sun.faces.lifecycle.Phase doPhase SEVERE: JSF1054: (Phase ID: INVOKE_APPLICATION 5, View ID: /Registration.jsp) Exception thrown during phase execution: javax.faces.event.PhaseEvent[source=com.sun.faces.lifecycle.LifecycleImpl&lt; at &gt;d24e3f] Apr 12, 2012 4:52:03 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet Faces Servlet threw exception java.lang.ClassNotFoundException: org.apache.cayenne.query.Query at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1360) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1206) at org.cayenne.Manager.RegisterManager.addRegister(RegisterManager.java:18) at org.cayenne.managedBean.RegisterBean.register(RegisterBean.java:142) 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 org.apache.el.parser.AstValue.invoke(AstValue.java:152) at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276) at org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:68) at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88) at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102) at javax.faces.component.UICommand.broadcast(UICommand.java:387) at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:475) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:756) at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82) at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100) at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) -- View this message in context: http://cayenne.195.n3.nabble.com/Error-while-using-JSF-with-Maven-and-Cayenee-for-persistence-tp3905125p3905125.html Sent from the Cayenne - User mailing list archive at Nabble.com. </pre> yunus 2012-04-12T11:30:25 http://comments.gmane.org/gmane.comp.java.cayenne.user/14485 <pre>hi, I am using two databases for my web project...Oracle and MySql In Oracle i have created my database and it is working fine with it. But in MySql..i want to access database which is already created and there is no need to create using cayenne... So how can i provide the connection and fetch the data from the database.What will be the required step like to create DataMap,Datanode?Please tell me the steps. -- View this message in context: http://cayenne.195.n3.nabble.com/fetching-data-through-cayenne-tp3896560p3896560.html Sent from the Cayenne - User mailing list archive at Nabble.com. </pre> yunus 2012-04-09T11:24:52 http://comments.gmane.org/gmane.comp.java.cayenne.user/14483 <pre>hi! my OS is Windows 7 64bit,can not to run cayenne modeler, use java -jar CayenneModeler.jar is OK,but can not generating CLASS. why? it is work normal in Windows 32bit. </pre> shinesoft 2012-04-08T13:49:33 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.java.cayenne.user