This isn't really an answer to your question, but could help you. If your schemas are the same in db1 and db2, I would set up a shared data map and then copy it into the db1 and db2 data domains:
http://cwiki.apache.org/CAY/copying-datamaps.html Easier to maintain, don't need duplicate java classes, etc. Sorry I don't have time right now to provide more thoughts, but hopefully that'll give you something to ponder. :-) /dev/mrg On 4/17/07, jerome moliere <[EMAIL PROTECTED]> wrote:
Hi all, this is my question of the day (waiting for the tip of the day andrus -) ) Let's imagine a database db1 with a catalog1, schema 1 containing table T1 mapped as p1.T1 with Cayenne db2 (catalog2,schema2) containing same T1 table mapped as p2.T1 with Cayenne db1 and db2 live on the same machine I'd like to make copies from some db1 entities to db2 in a transactional fashion without requiring XA transactions.. Is it possible ? I've seen one sample with quite this requirement but I 'd like to be sure for the good practice to do that Concrete usage for this ? Storing an entire database: customizing reference data for any customer or versioning objects... Thanks in advance Jerome -- Jerome Moliere - Mentor/J http://romjethoughts.blogspot.com/ auteur Eyrolles
