Re: Easily Import/Export tables

2009-09-08 Thread open.pumpkin
> Which version of Cayenne do you have? I use 2.0.4. I'll try to test with 3.0. > it's trivial to write ant tasks to export and import data I agree. I'm writing a java class to generate dynamic dumps (sql script) of my tables. It's not so longer I thought. Thanks for help ! 2009/9/8 Mike Kienen

Re: Question about key path expression

2009-09-08 Thread Reinout van Schouwen
Hi Michael, Op dinsdag 08-09-2009 om 12:22 uur [tijdzone -0400], schreef Michael Gentry: > Then you should use that in your expression: > > Expression.fromString("names.familyName like '$name'") Thanks, after I removed the unnecessary single quotes, this worked. :-) -- Reinout van Schouwen

Re: Easily Import/Export tables

2009-09-08 Thread Mike Kienenberger
As an alternative: I find it far easier to use DBUnit to export and import data in a database-independent format. If you use Eclipse, you can install the QuantumDB plugin and export/import directly from eclipse (for small tables). Otherwise, it's trivial to write ant tasks to export and import

Re: Question about key path expression

2009-09-08 Thread Michael Gentry
Then you should use that in your expression: Expression.fromString("names.familyName like '$name'") mrg On Tue, Sep 8, 2009 at 11:58 AM, Reinout van Schouwen wrote: > Hi Michael, > > 2009/9/8 Michael Gentry : >> Also, what is the name of your relationship from Person to PersName? > > It is 'nam

Re: Question about key path expression

2009-09-08 Thread Reinout van Schouwen
Hi Michael, 2009/9/8 Michael Gentry : > Also, what is the name of your relationship from Person to PersName? It is 'names'. -- Reinout van Schouwen

Re: Question about key path expression

2009-09-08 Thread Michael Gentry
Also, what is the name of your relationship from Person to PersName? On Tue, Sep 8, 2009 at 11:19 AM, Reinout van Schouwen wrote: > Hi, > > I have a table Person and a table PersName. I've created a relation > between PersName and Person so that each PersName links to a Person. In > other words,

Re: Question about key path expression

2009-09-08 Thread Michael Gentry
Try this instead: final Expression queryTemplate = Expression.fromString("persname.familyName like '$name'"); Map queryParams = Maps.newHashMapWithExpectedSize(1); queryParams.put("name", "A%"); // TODO "A" from parameter I believe the wildcard (%) has to go into the map and not the expression

Question about key path expression

2009-09-08 Thread Reinout van Schouwen
Hi, I have a table Person and a table PersName. I've created a relation between PersName and Person so that each PersName links to a Person. In other words, a Person may have multiple PersNames. Is it possible to do a query like this: // find all Persons whose family name starts with A final E

Question about key path expression

2009-09-08 Thread Reinout van Schouwen
Hi, Is it possible to do a query like this:

Re: DataContext cache WICKET

2009-09-08 Thread Reinout van Schouwen
Hi Arnaud, Op dinsdag 08-09-2009 om 09:31 uur [tijdzone +0200], schreef Arnaud Garcia: > many thanks .. I start with cayenne and wicket... so it is a bit hard to > start.. Take a look at Databinder (www.databinder.net) - it provides a glue layer between Wicket and Cayenne. It's not without its

Re: Easily Import/Export tables

2009-09-08 Thread Andrus Adamchik
Looks like this bug to me: https://issues.apache.org/jira/browse/CAY-1170 It is fixed in 3.0M6. Which version of Cayenne do you have? Andrus On Sep 8, 2009, at 10:27 AM, open.pumpkin wrote: The trace : /.../build.xml:20: Error porting data: null at org.apache.cayenne.tools.DataPortTask

Re: Easily Import/Export tables

2009-09-08 Thread open.pumpkin
Missing. Sorry. Here the headers of the stack trace : Apache Ant version 1.7.1 compiled on November 10 2008 Buildfile: build.xml Detected Java version: 1.5 in: /usr/lib/jvm/java-1.5.0-sun-1.5.0.18/jre Detected OS: Linux parsing buildfile /myPath/build.xml with URI = file:/myPath/build.xml Project

Re: Easily Import/Export tables

2009-09-08 Thread open.pumpkin
The trace : /.../build.xml:20: Error porting data: null at org.apache.cayenne.tools.DataPortTask.execute(DataPortTask.java:108) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.Nativ

Re: Easily Import/Export tables

2009-09-08 Thread Andrus Adamchik
On Sep 8, 2009, at 3:24 AM, open.pumpkin wrote: Line #20 is : srcNode="Dev_WKN_Node" destNode="Local_WKN_Node" /> Connections to databases are correct (if I stop one DB, I receive a Connection refused exception). Node names are correct. But I'm not familiar with ant. Can you enlighten me?

Re: Cloning DataDomain

2009-09-08 Thread Michael Gentry
Hi Mirko, it looks to me like you are copying the DataNode, which means they'll all have the same DB connection. mrg On Mon, Sep 7, 2009 at 3:10 AM, Mirko Teran Ravnikar wrote: > Hello. > > I've been looking trough similar problems here but can't seem to find > a solution that would work so I'm

Re: DataContext cache WICKET

2009-09-08 Thread Andrey Razumovsky
Hi Arnaud, Have a look at recent discussion: http://cayenne.markmail.org/message/3zcm4dw2ttbfjqwq?q=list:org.apache.cayenne.user&page=6#query:list%3Aorg.apache.cayenne.user+page:6+mid:3zcm4dw2ttbfjqwq+state:results 2009/9/8 Arnaud Garcia > Thank you Andrey, > > 1/ hmmm, so that means that when

Re: DataContext cache WICKET

2009-09-08 Thread Arnaud Garcia
Thank you Andrey, 1/ hmmm, so that means that when I use in a webapp a Datacontext like: ctxt = DataContext.createDataContext() The DataContext is destroy at the end of the request ? this is why I do not my cache working 2/ To bind the DataContext to the user session I need to use the filt

Re: Easily Import/Export tables

2009-09-08 Thread open.pumpkin
Thanks for reply. I'm considering the ant method but I have a problem and some questions. Here the error I receive during execution of my ant script : Buildfile: build.xml exportTask: [cdataport] log4j:WARN No appenders could be found for logger (org.apache.cayenne.conf.DefaultConfiguration). [c