• Post Reply Bookmark Topic Watch Topic
  • New Topic

Is there a limit to data in Insert queries?

 
Sam Drake
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 101
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!