• Post Reply Bookmark Topic Watch Topic
  • New Topic

Limit on number of ?s in Prepared statements  RSS feed

 
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: 1084
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: 36659
475
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!