Thank you. 2 GB should be plenty for my kind of data. The reason I ask is because I remember Oracle (or something else) used to have a limit of 1000 records per request, maybe still has.
Well, thanks again! On Wednesday, October 9, 2013 3:04:14 PM UTC-4, Thomas Mueller wrote: > > Hi, > > The only limit I know is that in Java, Strings have s size limit of 2 GB. > > By the way, I should use a prepared statement and parameters (bind > variables). Inserting multiple rows at a time might make sense if you use > the server mode; if not, I would simply use one row at a time. > > Regards, > Thomas > > > On Wed, Oct 9, 2013 at 4:35 PM, <[email protected] <javascript:>>wrote: > >> Hello, >> >> Is there a limit on the number of rows I can insert with one statement, >> i.e. like this: INSERT INTO table VALUES (.., .., ...), (.., .., ...), ... >> (.., .., ...); ? >> >> Thank you. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
