When i run my java application which accesses a MySQL database sometimes when the application terminates with an exception a couple rows of my table i was working with are deleted. I am only using SELECT on the table in my code. What could cause this to happen? Connection leak? If so whats the best way to diagnose and fix the problem?
Asked
Active
Viewed 36 times
0
-
Have you checked what queries were run last on MySQL? – matcheek Aug 07 '14 at 15:41
-
No. Using Navicat for my DB manager. Not exactly sure how to do that. – wwoodal1 Aug 07 '14 at 15:52
-
http://stackoverflow.com/questions/650238/how-to-show-the-last-queries-executed-on-mysql – matcheek Aug 07 '14 at 15:58
-
Yeah i found out how. Will report back next time it happens. – wwoodal1 Aug 07 '14 at 15:59
-
Sounds like a transaction rollback, where those rows inserted by the application and not yet committed? – Mark Rotteveel Aug 08 '14 at 09:36
-
Nope all i do from this database table is select the rows and process them. Never insert back into the db the entire row. I do however update a column in the row. I think this is where my error is happening. – wwoodal1 Aug 08 '14 at 18:53