Two Laptop Bag*
The moose likes Beginning Java and the fly likes java.sql. question 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 » Java » Beginning Java
Bookmark "java.sql. question" Watch "java.sql. question" New topic
Author

java.sql. question

Alok Pota
Ranch Hand

Joined: Mar 07, 2001
Posts: 185
Is there a limit to the number of PreparedStatements I create out of a single connection? i.e., can I all the below in a loop
of say 50 and then close them all?
i.e.,
PreparedStatement stmt = conn.prepareStatement(query);
Cindy Glass
"The Hood"
Sheriff

Joined: Sep 29, 2000
Posts: 8521
How would you sort out the ResultSet?

"JavaRanch, where the deer and the Certified play" - David O'Meara
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: java.sql. question