Hi Sylvain, if the connections all come from one computer, and they are not in the same VM, then AUTO_SERVER is the best way to do this. AUTO_SERVER only has problems if you access the database via different networks (imagine a mobile user starting the server, and other users accessing this server via the mobile connection, just to get connected to a database located in the same network).
SERIALIZED is the best way to do a really file only database access, eg. for databases located on pure network shares. If you can provide a simple test case, I can have a look why the select changes the database. Regards Christian On Jul 6, 9:56 pm, Sylvain <[email protected]> wrote: > I tried the AUTO_SERVER, I also set > System.setProperty("h2.bindAddress", "localhost"); and it works very > well. I'll probably go with this solution. > > On Jul 6, 3:20 pm, Sylvain <[email protected]> wrote: > > > > > > > > > I forgot to mention that I'm using the last version 1.3.157 -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
