Hi Riccard,
finally I've managed this "mixed mode" by using (almost) exactly the
same URL:
Anyhow, I don't know if this server mode would work remotely.
Maybe it helps you when I provide you my settings:
This is my JBoss "datasource" (observe the connection URL):
<connection-url>jdbc:h2:${jboss.server.data.dir}/databases/jms/
JMS;AUTO_
SERVER=TRUE;MVCC=TRUE</connection-url>
<driver-class>org.h2.jdbcx.JdbcDataSource</driver-class>
And this is the Java standalone application URL:
jdbc:h2:D:/Projects/HAC/cccas/server/ccc/data/databases/jms/
JMS;AUTO_SER
VER=TRUE;IFEXISTS=TRUE
So, the "path" to the database must be the same. In the second
application I'm using IFEXISTS=TRUE because JBoss creates the database
for me and not the sattellite application.
I suppose that connecting remotely would mean to have access to the
database files from the remote computer. It's not quite what I want
but, anyhow ....
Kr
Josef
On Nov 4, 12:48 pm, "Riccard M" <[email protected]> wrote:
> Thomas,
>
> Sorry yo bore you!
> I have read the docs in the manual in different chapters on mixed mode
> several times and other threads
> but have not understood how mixed mode works between different machines
> which in the doc are explicitly
> mentioned to be able to connct..
> One thing I have not tested is using
> "DriverManager.getConnection("jdbc:h2:/data/test;AUTO_SERVER=TRUE");"
> with other applications. Is it not enough to write the URL-part in H2 GUI
> also for other apps
> which works for the first one?
>
> Please put me on the track a little.
>
> Riccard
--
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.
