Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Limit on number of ?s in Prepared statements

 
Chit Ming Chong
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there a limit of bound variables (or bind variable, whatever) in a PreparedStatement object?
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am not sure but if I would guess , since in PreparedStament.setXXX() method argument is of int type so limit should be max value of int i.e. 2147483647. but its too much can it be .



but there must be a role of database

Shailesh
[ April 14, 2005: Message edited by: Shailesh Chandra ]
 
Chit Ming Chong
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks, good point there about the type being an int.

So there is no practical limit on the number of ?s.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Chit Ming Chong:
Thanks, good point there about the type being an int.

So there is no practical limit on the number of ?s.

Correct.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic