sounds like you aren't using InnoDB and therefore there's really no transaction in place at all. The (often default) MyISAM engine of MySQL doesn't support transactions.
On Sep 20, 2012, at 7:19 AM, kampy wrote: > Hi all , > > I am trying bulk data into mysql database through sqlalchemy. In the table > there may be primary key values before. If we get the same primary key values > we get Integrity Error so I am using transaction management here. But while > inserting bulk data the rows inserted before this error werent get rolled > back only the row where error is got is rolled back. Can anyone please help > me out in gettin gout this issue. > > Thanks in advance > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/sqlalchemy/-/mxq1e7yJoOQJ. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
