File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "java.sql. question" Watch "java.sql. question" New topic

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?
PreparedStatement stmt = conn.prepareStatement(query);
Cindy Glass
"The Hood"

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

"JavaRanch, where the deer and the Certified play" - David O'Meara
I agree. Here's the link:
subject: java.sql. question
It's not a secret anymore!