> > > 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.
_______________________________________________ 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
