Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Transaction is commited when it should not be in the case of multiple exceptions [JDBC95] #133

Closed
firebird-automations opened this issue Jan 12, 2007 · 4 comments

Comments

@firebird-automations
Copy link

Submitted by: Steffen Heil (sh-solutions)

Assigned to: Roman Rokytskyy (rrokytskyy)

Attachments:
TestCase.java

I think I found a strange bug in JayBird or Firebird.
So this may be a firebird issue as well.

I open a connection in non-auto-commit mode. I delete all entries in a table
and insert some new entries. That fails (acutally a bug in my software).
However the database should NOT get corrupted, as the transaction is NEVER
commited.
That works as expected.

If I try again, it fails again (as expected).
However, this time the database IS CORRUPTED, as the transaction seems to
get partially commited.

That effect already destroyed 3 databases of mine.
However I could isolate to problem and build a test case, which shows the
behavior. I'll attach it.

Commits: 96a5332

@firebird-automations
Copy link
Author

Modified by: Steffen Heil (sh-solutions)

Attachment: TestCase.java [ 10221 ]

@firebird-automations
Copy link
Author

Commented by: Roman Rokytskyy (rrokytskyy)

Fixed in HEAD

@firebird-automations
Copy link
Author

Modified by: Roman Rokytskyy (rrokytskyy)

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: Jaybird 2.2 [ 10053 ]

@firebird-automations
Copy link
Author

Modified by: Roman Rokytskyy (rrokytskyy)

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant