dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #05387
Re: Multiple connections to H2
Well, if I start DHIS Live with the following URL in hibernate.properites
jdbc:h2:tcp://localhost/V:/dhis/dhis2-live/database/kenya7;AUTO_SERVER=TRUE
I am then able to connect from H2 console with:
jdbc:h2:tcp://localhost/V:/dhis/dhis2-live/database/kenya7
This at least works for my needs - do you see a problem with doing it that
way?
On Sat, Apr 10, 2010 at 11:35 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx>wrote:
> On 10 April 2010 22:26, Knut Staring <knutst@xxxxxxxxx> wrote:
> > Ok, it works now - the trick was to use the same URL also in
> > hibernate.properties, i.e.
> >
> jdbc:h2:tcp://localhost/V:/dhis/dhis2-live/database/kenya7;AUTO_SERVER=TRUE
>
> No that's not the trick!!
>
> In hibernate properties you want:
> jdbc:h2:./database/kenya7;AUTO_SERVER=TRUE
>
> And for subsequent connections (eg console) you want:
> jdbc:h2:tcp://localhost/V:/dhis/dhis2-live/database/kenya7
>
> Note the lack of AUTO_SERVER=TRUE. You only want one process (dhis2)
> to act as server. The tcp connection is just for clients.
>
>
> >
> > On Sat, Apr 10, 2010 at 11:23 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
> >>
> >> Almost...maybe it is subtly different on Windows?
> >> If I start the H2 console first like below, I can then proceed to also
> >> start DHIS Live, and I see changes I make in DHIS show up in the
> console:
> >>
> >>
> jdbc:h2:tcp://localhost/V:/dhis/dhis2-live/database/kenya7;AUTO_SERVER=TRUE
> >>
> >> However, if I start DHIS2 Live first, I am not allowed to connect in the
> >> console.
> >> I can start in the console, then DHIS, log out of the console and log in
> >> again (i.e. access both at the same time). I just need to do the initial
> >> startup with the console.
> >> 2010/4/10 Bob Jolliffe <bobjolliffe@xxxxxxxxx>
> >>>
> >>> 2010/4/10 Bob Jolliffe <bobjolliffe@xxxxxxxxx>:
> >>> > I've also had this problem but I doubt if the bindaddress has
> anything
> >>> > to do with it. By default the server socket will be bound to
> >>> > INADDR_ANY. (This is the same as the tomcat security issue I
> referred
> >>> > to some time back). Will investigate ...
> >>> >
> >>> > Bob
> >>> >
> >>> >
> >>> > 2010/4/10 Lars Helge Øverland <larshelge@xxxxxxxxx>:
> >>> >> I have had the same problem. Why don't you test it, you can set
> props
> >>> >> from the command line when starting live..
> >>> >>
> >>> >> 2010/4/10, Knut Staring <knutst@xxxxxxxxx>:
> >>> >>> I am unable to connect to the H2 database through the H2 console
> >>> >>> while DHIS2
> >>> >>> is running, despite AUTO_SERVER being indicated in
> >>> >>> hibernate.properties
> >>> >>> (default for DHIS Live).
> >>> >>>
> >>> >>> >From the following message, it seems that perhaps we need to set
> >>> >>> System.setProperty("h2.bindAddress", ...) before loading the
> >>> >>> org.h2.Driver class (and before starting the server)
> >>> >>>
> >>>
> >>> OK. Here goes ...
> >>>
> >>> I saw that there were a few hits on google about this "problem"
> >>> including the peculiar bindaddress workaround but I wasn't entirely
> >>> convinced. So I started poking around with the source code and
> >>> looking at the latest releases thinking that if this was a problem
> >>> before, then it would probably have been solved by now. In the
> >>> process discovered that:
> >>>
> >>> (i) This really is a fast moving project. Release cycle seems to
> >>> average a week or two!
> >>> (ii) We are using v1.1.119 in DHIS2. Current version is v1.2.132.
> >>> (iii) there are issues of version compatibility with the h2 file
> format.
> >>>
> >>> So thinking that this could be the problem (my external h2 client was
> >>> 1.1.114) I decided to update my dhis2 and local client to the latest
> >>> and greatest v1.2.132. To my great disappointment (my dhis-web
> >>> compile is very slow) this made no difference at all other than a more
> >>> helpful exception being thrown and reported on. So ..
> >>>
> >>> Well sometimes I am stupid and sometimes I am very stupid :-)
> >>>
> >>> My url in hibernate.properties is:
> >>> jdbc:h2:./database/testdb;AUTO_SERVER=TRUE
> >>>
> >>> Then in my client (h2 console or openoffice jdbc) I used:
> >>> jdbc:h2:./database/testdb
> >>>
> >>> and of course it doesn't connect. The dhis2 connection opens the file
> >>> in embedded mode which means other clients can't do the same thing
> >>> (file locking prevents this). Other clients have to connect using
> >>> tcp to get access in server mode. So if instead I use:
> >>>
> >>> jdbc:h2:tcp://localhost/home/bobj/dhis2-live/database/testdb
> >>>
> >>> everything works like a charm! My guess is I'm not the only one who
> >>> was doing this. And I doubt if this has much to do with my h2 version
> >>> upgrade. Knut, try using a tcp url like this with your setup and see
> >>> if it works. If so problem soved.
> >>>
> >>> There is of course a downside. If I configure this url in openoffice
> >>> (my preferred way of accessing h2 db) I can only open it if h2 is
> >>> running in server mode (eg my dhis2-live is running) which is a bit of
> >>> a pain. I need to actually have two db connections configured - one
> >>> for server mode and one to open the db directly. But I guess you
> >>> can't have your cake and eat it.
> >>>
> >>> Final thought on version upgrade. It is very tempting to look at
> >>> bumping up our h2 version in dhis2 with one big pro and one big con.
> >>> The con being that there will likely be incompatibility with existing
> >>> h2 file format (not a major issue as I don't think there's much h2
> >>> production use but it might mess with our sample db). The pro being
> >>> that each new release seems be improving postgres compatibility. If
> >>> we can freely exchange db dumps between h2 and postgres that would be
> >>> more than cool. Given that exchange between postgres versions is
> >>> troublesome anyway I'm not holding my breath too much, but its worth
> >>> investigating.
> >>>
> >>> Cheers
> >>> Bob
> >>>
> >>> >>> http://groups.google.com/group/h2-database/msg/7526244fde1a0e58
> >>> >>>
> >>> >>> --
> >>> >>> Cheers,
> >>> >>> Knut Staring
> >>> >>>
> >>> >>
> >>> >> --
> >>> >> Sendt fra min mobile enhet
> >>> >>
> >>> >> _______________________________________________
> >>> >> Mailing list: https://launchpad.net/~dhis2-devs
> >>> >> Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >>> >> Unsubscribe : https://launchpad.net/~dhis2-devs
> >>> >> More help : https://help.launchpad.net/ListHelp
> >>> >>
> >>> >
> >>
> >>
> >>
> >> --
> >> Cheers,
> >> Knut Staring
> >
> >
> >
> > --
> > Cheers,
> > Knut Staring
> >
>
--
Cheers,
Knut Staring
Follow ups
References