This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC and the fly likes reuse java.sql.Statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "reuse java.sql.Statement" Watch "reuse java.sql.Statement" New topic

reuse java.sql.Statement

Abhijeet Gholkar

Joined: Jun 11, 2002
Posts: 25
Hi folks
Can i use same java.sql.Statement object for executing more than one queries at a time. If not please tell me why.
narasimharao konjeti
Ranch Hand

Joined: Apr 26, 2003
Posts: 130
s we can excucute, there is no problem.

"Unwise to sweat petty stuff, wise to pet sweaty stuff."
Dana Hanna
Ranch Hand

Joined: Feb 28, 2003
Posts: 227
If by "at the same time" you mean concurrently from different Threads, I'm going to have to say NO WAY.
I agree. Here's the link:
subject: reuse java.sql.Statement
Similar Threads
Threads and Waiting for DB connection
Special Character Handling
Creating Database
Q: repeatedly execute() on PreparedStatement without close()