I haven't tried it, but the docs do clearly state: "All processes need to have access to the database file" "Explicit client/server connections (using jdbc:h2:tcp:// or ssl://) are not supported."
and the example shows:
// Application 1:
DriverManager.getConnection("jdbc:h2:/data/test;AUTO_SERVER=TRUE");
// Application 2:
DriverManager.getConnection("jdbc:h2:/data/test;AUTO_SERVER=TRUE");
I guess somebody else may have to chime in to help. I can't check it myself
right now.
Cheers
Kerry
On Tue, Jan 19, 2010 at 9:04 AM, Nitai @ Razuna <[email protected]> wrote:
> Sorry, i wouldn't have asked without first consulting the docs.
>
> The question remains. Because I have tested it and does not work. Plus
> we need to change port of have a fixed port.
>
> jdbc:h2:tcp://ip:port/opt/h2/mydb
>
> Kind Regards,
> Nitai
>
> On Mon, Jan 18, 2010 at 9:00 PM, Kerry Sainsbury <[email protected]>
> wrote:
> > auto_server documentation is described here, and answers your questions.
> >
> >
> http://www.h2database.com/html/features.html?highlight=AUTO_SERVER&search=auto_server#auto_mixed_mode
> >
> > Cheers
> > Kerry
> >
> > On Mon, Jan 18, 2010 at 8:25 PM, Nitai @ Razuna <[email protected]>
> wrote:
> >>
> >> To follow up on this I got a related question:
> >>
> >> Say I initialize H2 with the auto_server=true setting and the path to
> >> the database is "/opt/h2/mydb"
> >>
> >> So, how do we then connect to this database from a remove machine? Is it
> >> with:
> >>
> >> jdbc:h2:tcp://ip:port/opt/h2/mydb
> >>
> >> Also, can we set the port manually? Since H2 is started on a remote
> >> machine with a firewall, we need to configure the port.
> >>
> >> Thanks.
> >>
> >> Kind Regards,
> >> Nitai
> >>
> >> On Mon, Jan 18, 2010 at 7:06 AM, Thomas Mueller
> >> <[email protected]> wrote:
> >> > 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.
> >>
> >>
> >>
> >> --
> >> See for yourself how easy it is to manage files today. Join the
> >> revolution!
> >>
> >> Razuna SaaS On-Demand - Hosted Digital Asset Management Solution
> >> http://www.razuna.com/
> >>
> >> Razuna - Open Source Digital Asset Management
> >> http://www.razuna.org/
> >>
> >> Follow us on Twitter
> >> http://twitter.com/razunahq
> >>
> >> --
> >> 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]<h2-database%[email protected]>
> .
> >> For more options, visit this group at
> >> http://groups.google.com/group/h2-database?hl=en.
> >>
> >>
> >>
> >
> >
> > --
> > 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]<h2-database%[email protected]>
> .
> > For more options, visit this group at
> > http://groups.google.com/group/h2-database?hl=en.
> >
> >
>
>
>
> --
> See for yourself how easy it is to manage files today. Join the revolution!
>
> Razuna SaaS On-Demand - Hosted Digital Asset Management Solution
> http://www.razuna.com/
>
> Razuna - Open Source Digital Asset Management
> http://www.razuna.org/
>
> Follow us on Twitter
> http://twitter.com/razunahq
>
> --
> 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]<h2-database%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
>
>
>
-- 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.
