Hi!

I attempted to update entries in a table without a primary key while
using torque 3.0 and mysql 4.0.17. I tried

object.save()
ObjectPeer.doUpdate( object ), and
ObjectPeer.doUpdate( criteria )

but none of these attempts even resulted in an update event in the
database log, nor in any java application log. As soon as I added a
primary key to the table, object.save() began working as expected.

I made the experience that Torque does not handle tables without a primary key very well because most operations are based on the pk. Deleting from one of those tables won't work as well, you'll get some KeyDefNotFoundException.


Since I didn't have the time to examine this behaviour any further, I now add a primary key to every table, even if it doesn't need one, just to keep Torque working.

> Is this a bug, or am I missing something obvious?

See also last entry here:

http://wiki.apache.org/db-torque/TorqueProjectPages/FAQ

It's a conceptual problem.

--
Mit freundlichen Gr��en / Kind regards

Hendrik Busch - Senior Developer

LexisNexis Deutschland GmbH
http://www.lexisnexis.de
Feldstiege 100
D-48161 M�nster
phone +49 (0) 2533-9300-455
fax +49 (0) 02533-9300-50
[EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to