Reputation: 1
How to get the id of which database transaction?
I have a java web app that create two database transaction about the same time.
Bit somehow the 2nd db truncation is actually using back the first db transaction connection.
How can I get the id of which database transaction is being used and investigate further?
Upvotes: 0
Views: 227
Answers (1)
Reputation: 128899
At the JDBC level, a simple transaction only consists of getting a Connection, turning autocommit off, creating and executing some Statements, and committing. If you try to run "two transactions" on the same connection in this manner, they'll obviously step on each other. Your question is vague, but it sounds like you might be experiencing something like this. Give more detail, and someone might be able to help you out more.
Upvotes: 1
Related Questions
- How to get the insert ID in JDBC?
- Getting id after insert within a transaction (Oracle)
- How to get the current database transaction id using JDBC or Hibernate?
- Fetching id field of an entity in the SQL Transaction
- How to get Oracle db transaction id (replace Postgres txid_current())
- How to inspect data within a database transaction?
- GET the id of the inserted record
- Hibernate Transaction Id
- Java JDBC Retrieve ID After Insert
- Get all insert ids in a transaction