On 10 April 2010 22:26, Knut Staring <knu...@gmail.com> 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 <knu...@gmail.com> 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 <bobjolli...@gmail.com>
>>>
>>> 2010/4/10 Bob Jolliffe <bobjolli...@gmail.com>:
>>> > 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 <larshe...@gmail.com>:
>>> >> 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 <knu...@gmail.com>:
>>> >>> 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@lists.launchpad.net
>>> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> >> More help : https://help.launchpad.net/ListHelp
>>> >>
>>> >
>>
>>
>>
>> --
>> Cheers,
>> Knut Staring
>
>
>
> --
> Cheers,
> Knut Staring
>
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
