ResultSet not closed when connection closed?

by

One problem with ONLY closing the connection and not the result set, is that if your connection management code is using connection pooling, the connection.close() would just put the connection back in the pool. Additionally, some database have a cursor resource on the server that will not be freed properly unless it is explicitly closed.

More Related Contents:

  1. Connect Java to a MySQL database
  2. How to get the insert ID in JDBC?
  3. Is java.sql.Timestamp timezone specific?
  4. java.util.Date vs java.sql.Date
  5. MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement
  6. How to connect to Oracle using Service Name instead of SID
  7. Java ResultSet how to check if there are any results
  8. Retrieve column names from java.sql.ResultSet
  9. JDBC connection failed, error: TCP/IP connection to host failed
  10. How can I get the SQL of a PreparedStatement?
  11. java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0) [closed]
  12. Switch without break
  13. Is java.sql.Connection thread safe?
  14. Can I connect to SQL Server using Windows Authentication from Java EE webapp?
  15. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  16. java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver
  17. How does Java’s PreparedStatement work?
  18. Create a jTDS connection string
  19. How to get all table names from a database?
  20. JDBC Pagination
  21. Should I use java.util.Date or switch to java.time.LocalDate
  22. java error (No suitable driver found)
  23. Cannot use a LIKE query in a JDBC PreparedStatement?
  24. How can I abort a running JDBC transaction?
  25. PreparedStatement with Statement.RETURN_GENERATED_KEYS
  26. How to get row count using ResultSet in Java?
  27. Converting mysql table to spark dataset is very slow compared to same from csv file
  28. Why do we use a DataSource instead of a DriverManager?
  29. Do I need to close ‘PreparedStatement’? [closed]
  30. java.sql.SQLException: No database selected – why?

Leave a Comment