大家好,又见面了,我是你们的朋友全栈君。如果您正在找激活码,请点击查看最新教程,关注关注公众号 “全栈程序员社区” 获取激活教程,可能之前旧版本教程已经失效.最新Idea2022.1教程亲测有效,一键激活。
Jetbrains全系列IDE稳定放心使用
I have multiple threads trying to update a MySQL database? is executeUpdate method thread-safe to use?
解决方案
No, it is not thread-safe to use.
In fact, if some other thread uses a statement, and then another thread calls executeUpdate(), then the other thread’s ResultSets, if any, will be closed. JavaDoc for java.sql.Statement (of which PreparedStatement is a subtype) “All execution methods in the Statement interface implicitly close a statment’s current ResultSet object if an open one exists.”
Furthermore, it’s unlikely that a given implementation of executeUpdate() would be written to be mulit-thread safe.
You should either syncrhonize all use of the statement and resulting result sets, or make multiple connections so that each thread uses its own JDBC Connection to the database.. I would recommend the latter.
发布者:全栈程序员-用户IM,转载请注明出处:https://javaforall.cn/179940.html原文链接:https://javaforall.cn
【正版授权,激活自己账号】: Jetbrains全家桶Ide使用,1年售后保障,每天仅需1毛
【官方授权 正版激活】: 官方授权 正版激活 支持Jetbrains家族下所有IDE 使用个人JB账号...