Cayenne, MySQL and PK generation strategies

2010-07-26 Thread Marek Stanisław Wawrzyczny
Hi all, It has been a while since I last posted in this forum. First, a bit of a background. We have an existing MySQL schema that was driven by a number of WebObjects applications. These obviously rely on EOF to handle PK generation. We have decided to refactor the schema in a new database. Th

Re: cayenne.xml not found

2010-07-26 Thread Jeffrey Black
For what it's worth -- I am in the process of upgrading a project which presently uses DBUtils to Cayenne. After adding the Cayenne Jars to the project I placed the cayenne.xml along with the supporting XML files into the default package and it worked as beautifully. Of course I plan to ref

Re: cayenne.xml not found

2010-07-26 Thread Hans Pikkemaat
Hi, I've seen this issue before with Eclipse. Sometimes it happens that resource files disappear from the classes directory. A clean project usually helps as this rebuilds the whole project (if autobuilding is on). tx HPI On 7/26/10 12:25 PM, masjab wrote: Ok, it´s working. The problem wa

Re: cayenne.xml not found

2010-07-26 Thread masjab
Ok, it´s working. The problem was the source path but strange... When I checked the source path, src/java/res...was added already. I finally deleted it and added it again, everything looked the same, but now it´s working. Many THX! Now I can go on... -- View this message in context: http:/

Re: Using SQL ABS

2010-07-26 Thread Andrus Adamchik
Unfortunately neither SelectQuery nor EJBQLQuery support functions in the ORDER BY clause (something we should probably address in 3.1). You have a few choices: * Use SQLTemplate * Map an extra attribute in RiscoTotal DbEntity as "ABS(VARIACAO)", then an attribute in ObjEntity connected to

Re: cayenne.xml not found

2010-07-26 Thread Andrus Adamchik
I think you need to follow Michael's advice. "src/main/resources" must be setup as a *source* folder in Eclipse. E.g.: http://cayenne.apache.org/doc30/tutorial-starting-project.data/eclipse-xmlfiles.png To do that, right-click on the project, select "Properties > Java Build Path > Source > A