Noel, Thanks for the feedback. My Strings are already in memory, because they are sent via a web post. So, setStringa and setCharacterStream do not affect how the data is stored in H2, but the steam allows you to prevent having the whole thing in memory at insertion time, but after that it is all the same. correct?
Thanks, -Adam On Wednesday, May 28, 2014 10:04:23 AM UTC-4, Noel Grandin wrote: > > > > On 2014-05-27 17:24, Adam McMahon wrote: > > > > I would like to use the Clob data type for my variable length strings > that average around 300 characters. I see in the > > doc that I should use " |PreparedStatement.setCharacterStream| to store > values". Instead I am simply using > > PreparedStatment.setString(). This seems to work. Is there any > advantage to using setCharacterStream? This may be > > more of a JDBC question than an H2 question, but I thought I would start > in this group with the question. > > > > At that size it makes no difference. > > setCharacterStream() is there for the case where the CLOB is large enough > that you don't want to keep the whole thing in > memory at once. > -- 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/d/optout.
