aspose file tools
The moose likes JDBC and Relational Databases and the fly likes Can statement be used in multi-thread? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Can statement be used in multi-thread?" Watch "Can statement be used in multi-thread?" New topic
Author

Can statement be used in multi-thread?

William Yan
Ranch Hand

Joined: Sep 26, 2006
Posts: 69
Hi ranchers,
I am new to JDBC,
I wonder if the statement can be used in multi-thread. I mean i create a statement object by Connection. And pass the reference to mutli-thread, then mutli-thread uses the statement to executeQuery, can it work? And can preparedStatement work that way?

I know Connection can be used concurrently by many users, but how many is appropriate?

Thank you in advance,
William.


Java is better and better, yet bitter and bitter.
 
Have you tried LearnNowOnline? http://www.learnnowonline.com/
 
subject: Can statement be used in multi-thread?