Hello. H2 is not different from others, JDBC has java.sql.Blob interface that should be used, use Collection.createBlob() to allocate a BLOB instance, use one of its methods to put your data into it, and use PreparedStatement.setBlob() to pass this BLOB to the command. There are also an alternative PreparedStatement.setBlob() methods that take a java.io.InputStream as a parameter. If you data is small enough, you can use the byte[] with PreparedStatement.setBytes().
If you can build H2 from its current sources, you can use the JSON data type instead of BLOB, but it is not designed for really large JSON documents. If you need to store large JSON data in H2, please let us know. -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/6a8a057f-e96b-4e83-8025-0a632aae4243%40googlegroups.com.
