[Zope-dev] HELP NEEDED!!!

[Rajesh s shiggaon]

An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope-dev/attachments/20040212/98275759/attachment.html
-------------- next part --------------
Hi everyone,

    I am getting an error Error Type: OperationalError
Error Value: (1205, 'Lock wait timeout exceeded; Try restarting transaction')


i am trying to insert vaules into 2 tables (MYSQL). In the first table i make a new record and get the unique id for tht using THE MYSQL FUNCTION  . but when it try to insert a record for the next table for which i am using this id....it gives an error. but  when i try to give a static id for the second table....it is not giving any error.

so i guess it is bcoz of transactions of zope...

how to overcome this problem...any sugesstions are welcome!!!!!

Regards,
Rajesh

Rajesh Shiggaon