File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
What is the maximum limit of data can be send to the sever using GET method???
Limit of data on a jsp page??
Maximum length of a string???
Multiple session objects for multiple login user in the same/ new browser window
code too long