This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Is there a limit to data in Insert queries? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Is there a limit to data in Insert queries?" Watch "Is there a limit to data in Insert queries?" New topic
Author

Is there a limit to data in Insert queries?

Sam Drake
Ranch Hand

Joined: Jun 05, 2003
Posts: 33
Hi,
Is there a possible limit to the data given as parameters to the PreparedStatement's executeUpdate method?
Please reply.
regards,
Sam.
Ken Robinson
Ranch Hand

Joined: Dec 23, 2003
Posts: 101
I've had up to 30-40 placeholders (the ?s) without a problem. As the JDBC API is mainly a set of interfaces, it may be defined by the underlying driver implementation.
Try writing some quick test code and you should find your answer.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Is there a limit to data in Insert queries?
 
Similar Threads
code too long
What is the maximum limit of data can be send to the sever using GET method???
Maximum length of a string???
Limit of data on a jsp page??
Multiple session objects for multiple login user in the same/ new browser window