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/008246ef-a44b-42f1-95bf-8f1fdb2d6b65%40googlegroups.com.
