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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/008246ef-a44b-42f1-95bf-8f1fdb2d6b65%40googlegroups.com.
