dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

>
> > I have looked at different alternatives for the embedded database in the
> > lite version.
> >
> > - H2 is not working out so well. It seems the Hibernate H2Dialect is
> buggy.
> > The H2 people tried to submit a patch but it didn't work so well. It's
> all
> > explained here:
> > http://opensource.atlassian.com/projects/hibernate/browse/HHH-3401 .
> >
> > What is weird is that all our unit tests run fine on H2 but I guess we
> > haven't covered it all. I get problems e.g. on import for calculated data
> > elements, which is mapped as a subclass of DataElement in Hibernate.
>
> Yes I'd seen rumours that the H2Dialect was buggy, but hadn't hit any
> problems before.  One of the reasons for looking at ...
>
> > - Derby embedded looks as a good alternative, but unfortunately crashes
> at
> > database creation time because "indicator" and "translation" (which are
> > database table names in DHIS 2) are reserved words in Derby (doh). I
> don't
> > feel like starting to rename the tables, any other suggestions?
>
> Derby/javaDB.  Let me take a look now.  Though I am not sure how we
> might get around the tablename/reserved word problem other than
> renaming and refactoring which could be painful.
>


I have committed an extension to the jdbc support in DHIS 2 which allows for
use of derby.