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 t</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 resul</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.ref</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 objec</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</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 t</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.</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.DATAVERBALIZZAZION</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(LifecycleImp</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