Recommendation? MySQL and Transactions

[hardaur]

Hello all,

  I'm experiencing a bit of a problem.  I need good database transactions, but due to using MySQL and auto-increment IDs (@Id @GeneratedValue(strategy=IDENTITY)) I'm unable to maintain data consistency. 

  How have some of you more experienced folks got around this?  There's got to be a reasonable way, but I can't seem to find it ; )

Thanks,
G

[damianharvey.damianharvey.gmail.com]

Are you experiencing this issue

Cheers,

Damian.