aspose file tools*
The moose likes JDBC and the fly likes Using statement object for multiple queries Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Using statement object for multiple queries" Watch "Using statement object for multiple queries" New topic
Author

Using statement object for multiple queries

Nilesh Yawale
Greenhorn

Joined: Dec 16, 2003
Posts: 11
Hi All,
Can I use Statement object for multiple queries in different threads?..kindly explain.

Thanks in advance for your support.


Nilesh<br />SCJP<br />IBM certified for OOAD using UML
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61434
    
  67

Welcome to the Ranch "Nilesh Y"!
You'll find this forum a great place to seek help on JDBC, and there aren't many rules you'll have to worry about, but one is that proper names are required. Please take a look at the JavaRanch Naming Policy and change your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
Thanks!
bear
JDBC Forum Bartender


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Dana Hanna
Ranch Hand

Joined: Feb 28, 2003
Posts: 227
You could - but the results would be crazy.
Keep a Statement local to a thread!
Have each thread use a different connection and statement!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using statement object for multiple queries