BLOB or CLOB values in in-memory database? Bad idea in general, when you
use an in-memory database, it should be small enough.
If you want to connect to the database from another process, you need to
start a TCP Server inside of the process that owns the database.
org.h2.tools.Server tcp =
Hi,
thank you for your suggestions.
Can the prepared statement be run from outside (a standalone Java program) the
(Spring Boot) project that created an in-memory H2 database containing a table
with a BLOB column, or must it run from inside?
> Le 9 oct. 2019 à 03:51, Evgenij Ryazanov a écrit :
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
Hello,
how do you insert text (ex "abc") into a BLOB, in H2 ?
The BLOB field is supposed to contain JSON.
Many thanks.
Cheers,
Philip
--
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
