Castor will try to get the parent and all the child objects defined in your mapping within a BEGIN TRAN ... COMMIT TRAN block. So this isn't possible. However, if your db supports distributed transactions, then you can create a view to the other db to get the child table you want. That works just fine. -richard
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: September 15, 2003 7:36 AM To: [EMAIL PROTECTED] Subject: [castor-dev] Can Castor map objects across different db servers? Hi. I have a simple question. Can I have an object whose table resides on database server 1 be associated with an object whose table resides on database server 2? Has anyone done this? If yes, would it be possible to explain how or show me an example? Much appreciated. Isaac ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
