[B]Hi there
I am using several insert statements in a method in Java.
If the connection fails in between I want to roll back the inserted rows.
I cant use con.rollback(), because there is no connection.
How to handle such situation?
Thanks in advance.[/B]
tapas.chand
0
Newbie Poster
Recommended Answers
Jump to PostHave you tried setting the autocommit to false. If you don't even if you had the connection, the rollback wouldn't work.
All 2 Replies
javaAddict
900
Nearly a Senior Poster
Team Colleague
Featured Poster
Have you tried setting the autocommit to false. If you don't even if you had the connection, the rollback wouldn't work.
tapas.chand
0
Newbie Poster
Have you tried setting the autocommit to false. If you don't even if you had the connection, the rollback wouldn't work.
Thank a lot for your answer.:)
That is what i was missing.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.