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: 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: 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: 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

Re: Easily Import/Export tables

2009-09-07 Thread Andrus Adamchik
Hi there, Cayenne may not have built in data migration tools that would fit every scenario, although there's been some attempts to write them [1]. At the same time Cayenne is a good *platform* for writing such tools based on either objects (de)serialization, or direct migration [1], and l

Easily Import/Export tables

2009-09-07 Thread open.pumpkin
Hello, Is it possible to export tables using a dedicated cayenne function ? I would like to export one or more tables (and data), specified by the user of my application, to import them in another environment (for example from development to production). The ideal thing would be a SQL script gen