Could you post your mapping file please? My first thought is that
Product is dependent on Category, but if this were true you should get
an error thrown. I think however, if you change
db.begin();
db.update(p);
db.commit();
To
db.begin();
db.update(c);
db.commit();
Your code should work as expected (I think). More detail would be nice
though. :)
-Nick
-------Original Message-----
--From: Henning Voss [mailto:[EMAIL PROTECTED]
--Sent: Wednesday, June 23, 2004 2:04 PM
--To: [EMAIL PROTECTED]
--Subject: [castor-user] long transaction and many-to-many relationships
--
--
--hi,
--
--i am having trouble with long transactions and many-to-many
--relationsships.
--i am using castor 0.9.5.3 and the example application against
--mysql and oracle. in the example application there is a many
--to many relationship between products and categories.
--
--sample1:
db.begin();
Product p = (Product)db.load(Product.class, new Integer(44));
Category c = (Category)db.load(Category.class, new Integer(6));
p.addCategories(c);
db.commit();
--
--sample1 runs perferctly ok, a new record is inserted into the
--many-to-many table.
--
--sample2:
db.begin();
Product p = (Product)db.load(Product.class, new Integer(44));
Category c = (Category)db.load(Category.class, new Integer(6));
db.commit();
--
p.addCategories(c);
--
db.begin();
db.update(p);
db.commit();
--
--sample2 does not report any errors but no new record is
--inserted into the many-to-many table.
--
--
--can someone please expain why the second sample does not work ?
--
--Thanks,
--Henning
--
--
--
-------------------------------------------------------------
--If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
-- unsubscribe castor-user
--
--
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-user
