How can I abort a running JDBC transaction?

by

As mentioned by james, Statement.cancel() will cancel the execution of a running Statement (select, update, etc). The JDBC docs specifically say that Statement.cancel() is safe to run from another thread and even suggests the usage of calling it in a timeout thread.

After canceling the statement, you’re still stuck with the job of rolling back the transaction. That is not documented as being safe to run from another thread. The Connection.rollback() should happen in the main thread doing all the other JDBC calls. You can handle that after the canceled Statement.execute…() call completes with a JDBCException (due to the cancel).

More Related Contents:

  1. having an exception when saving oracle type object in some entity
  2. PreparedStatement IN clause alternatives?
  3. How do I get the size of a java.sql.ResultSet?
  4. Must JDBC Resultsets and Statements be closed separately although the Connection is closed afterwards?
  5. What is the best approach using JDBC for parameterizing an IN clause? [duplicate]
  6. Reusing a PreparedStatement multiple times
  7. MySQL and JDBC with rewriteBatchedStatements=true
  8. How to connect SQLite with Java?
  9. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  10. Getting Database connection in pure JPA setup
  11. Returning a ResultSet
  12. How to change MySQL timezone in a database connection using Java?
  13. How to configure Tomcat to connect with MySQL
  14. PLSQL JDBC: How to get last row ID?
  15. Does the preparedStatement avoid SQL injection? [duplicate]
  16. What is the most recommended way to store time in PostgreSQL using Java?
  17. How to read all rows from huge table?
  18. Native Library sqljdbc_auth.dll already loaded in another classloader
  19. ResultSet: Retrieving column values by index versus retrieving by label
  20. com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed [duplicate]
  21. dll missing in JDBC
  22. Java, looping through result set
  23. How to connect JDBC to tns oracle
  24. The specified DSN contains an architecture mismatch Error
  25. How to Correctly Close Resources
  26. Access denied for user ‘root’@’localhost’
  27. How to use prepared statement for select query in Java?
  28. Oracle JDBC : invalid username/password (ora-01017)
  29. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  30. Iterating a ResultSet using the JDBC for Oracle takes a lot of time about 16s?

Leave a Comment