Hi,
Thanks for the link, but I do not see then, why I am getting the below
error message:
"
Org.h2.jdbc.JdbcSQLException: Error opening database: “Lock file
recently modified” [8000-126]
"
How should I be accessing my database once the server is enabled?
Still with:
"
Class.forName("org.h2.Driver");
Connection conn = DriverManager.
getConnection("jdbc:h2:~/test", "sa", "");
...
conn.close();
"
?
Also, looking at another option:
http://www.h2database.com/html/features.html#auto_mixed_mode
What does "rolled back" mean in this context:
"All processes need to have access to the database files. If the first
connection is closed (the connection that started the server), open
transactions of other connections will be rolled back"
Thanks!!
On Jan 18, 1:06 am, Thomas Mueller <[email protected]>
wrote:
> Hi,
>
> > In summary would I need to put those server code lines in each of my
> > applications accessing the database?
>
> No. The server only needs to be started once (in one process). Each of
> the clients should then access the database over this (and only this)
> server.
>
> I'm not sure if you already read the connection mode
> documentation:http://www.h2database.com/html/features.html#connection_modes
>
> I will extend the documentation about the Server a bit:
>
> "
> When using the server mode (sometimes called remote mode or
> client/server mode), an application opens a database remotely using
> the JDBC or ODBC API. A server needs to be started within the same or
> another virtual machine, or on another computer. Many applications can
> connect to the same database at the same time, by connecting to this
> server. Internally, the server process opens the database(s) in
> embedded mode.
> "
>
> Regards,
> Thomas
--
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.
