jQuery in Action, 2nd edition*
The moose likes JDBC and the fly likes How many(maximum) place holders/bind variables can a preparestatement handle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How many(maximum) place holders/bind variables can a preparestatement handle" Watch "How many(maximum) place holders/bind variables can a preparestatement handle" New topic
Author

How many(maximum) place holders/bind variables can a preparestatement handle

KiranKumar Mateti
Greenhorn

Joined: Mar 28, 2009
Posts: 7
Hi ALL,


I need 2 clarifications.

1) How many maximum placeholdres/bind variables can preparedstatement can handle. Is there any maximum number for bind varaibles for preapared statement.

2) How much long query(length of the query) can handle by preparedstatement .Is there any query length limit for preparedstatement

Please provide information as soon as possible, possible post the links and documents if any.

Thanks in advance.


Thanks & Regard,
Kiran Kumar Mateti.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

I'm guessing number on is probably database dependent and number two certainly is. Have a look at your database documentation, there will probably be somethign in there about maximum statement size. One thing is for sure though, if you are going anywhere near a maximum you can pretty much guarentee you are doing something wrong.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How many(maximum) place holders/bind variables can a preparestatement handle
 
Similar Threads
In PreparedStatement table name can vary
Dealing with locks with JDBC
How ResultSet works? PreparedStatment handicaps?
Setting bind variables in prepareModel
PreparedStatement