Re: Values not inserting into MySQL Database table

[Shan Abdussalam]

I do raise exceptions for all errors and as such, the transaction should roll back I think?

But the point is that, why does this query fail in inserting data at a particular time, but when executed later manually seem to work fine. There is nothing wrong with the query as such, what I would like to know is if there could be something happening in the database at that instance that prevented the record insertion from taking place. And if so, what is the best way to find and rectify this.

I use Innodb engine by the way.