I've found a solution
INSERT INTO XXX (
...
"JSON_FILE" ,
...
) VALUES (
...
FILE_READ('classpath:/j1.json') ,
...
) ;
See
https://stackoverflow.com/questions/38353487/insert-blob-from-a-file-into-a-sql-script-to-embed-h2-database
Le mercredi 9 octobre 2019 10:25:38 UTC+2, Philip Roc a écrit :
>
> Hi Eyvgenij,
>
> here's the situation. My colleagues and I are currently working on a
> Spring Boot project that uses Oracle. However, although one of the
> developers has managed to install Oracle 11 on his machine, the 4 others
> haven't,
> probably because of company-wide security policies (who knows). Instead of
> spending precious development time figuring out why Oracle won't install,
> we've decided to use H2 instead for development purposes.
>
> The schema-h2.sql script in ou project creates a table containing a BLOB
> column (when the Spring Boot Profile is "h2").
>
> I would like to store a sample json file (200 lines) in the in-memory DB,
> to test the GET REST request, during development.
>
> For instance,
>
> GET /myservice/<invoice id>
>
> returns
>
> { "id": 2, "invoicename" : "123", etc. }
>
> Cheers,
>
> Phil
>
>
>
>
>
>
>
>
>
> Le mercredi 9 octobre 2019 07:55:17 UTC+2, Evgenij Ryazanov a écrit :
>>
>> 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 = org.h2.tools.Server.createTcpServer(…);
>> tcp.start();
>>
>> Another process should use the remote URL to connect to this server.
>>
>> You can also launch a separate H2 Server process and connect to it from
>> both your applications.
>>
>> If you use Hibernate, you can use Hibernate.getLobCreator(…) I guess. Why
>> you want to mix different methods to deal with the database?
>>
>
--
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/0a63f0cd-9b4e-4a67-b50c-01c7c50178c6%40googlegroups.com.
