本文介绍了JDBC 垃圾回收的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!
问题描述
What happens if i don't close resultset or preparedstatements.
Will they be closed and released by the garbage collector.
I'm asking this for local variables inside a function.
Do you know any documentation about this ?
解决方案
If your code does not close ResultSet
s or PreparedStatement
s when done using then, your application will hog scarce resources — like cursors — in the database. See, for example:
- ResultSet not closed when connection closed?
- What happens to the original resultSet when it is returned from a method into a new object?
The garbage collector does not know anything about closing ResultSet
s or PreparedStatement
s, so GC won't automagically take care of that for you. What will? Java 7's try
-with-resources statement!
这篇关于JDBC 垃圾回收的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!
本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!