Re: [h2] Re: Best Practice using H2

2021-03-23 Thread andreas
Mike.For our own software we test if the h2 port is open. If not we start the h2 server per java api and stop it when the software exits.When the port is found open we assume the h2 servers has been started externally and act as a client strictly.This may not been best practise but works like a

Re: [h2] Re: Best Practice using H2

2021-03-23 Thread Mike Bray
Thanks, I will do it as a file, the console is really only for debugging purposes. The user will not know about h2 and so shouldn’t need to access the db. Regards Mike On Tue, 23 Mar 2021 at 10:17, Evgenij Ryazanov wrote: > If you need the H2 Console only, you can embed it as a servlet into your

[h2] Re: Best Practice using H2

2021-03-23 Thread Evgenij Ryazanov
If you need the H2 Console only, you can embed it as a servlet into your application: https://h2database.com/html/tutorial.html#usingH2ConsoleServlet Don't forget to configure the security constraints to prevent access to it from untrusted and unauthorized users. If you need to accept connection

[h2] Best Practice using H2

2021-03-23 Thread mrbr...@gmail.com
A recent reply (https://groups.google.com/g/h2-database/c/lYi5Usc4tHU/m/yL1_dwA8AgAJ?pli=1) suggests that an application should not start the TCP server. Is there any 'best practice' documentation concerning set up and use of H2? I am using H2 for a Java app (not web) and start the TCP server