H2 database on AWS

Hi there. I got a database from Knut, and am trying to get it started
on Amazon Web services. Am running the latest 2.4 war.

Cannot get the thing to start.

Stack trace here..

Any ideas? Bob's souffle is ready, so I need someone else to help me.

Regards,
Jason

This doesn't seem right:
org.hisp.dhis.dialect.H2Dialect

It should probably be org.hibernate.dialect.H2Dialect? (in your
hibernate properties)

···

--
Morten

On Tue, Sep 20, 2011 at 8:40 PM, Jason Pickering <jason.p.pickering@gmail.com> wrote:

Hi there. I got a database from Knut, and am trying to get it started
on Amazon Web services. Am running the latest 2.4 war.

Cannot get the thing to start.

Stack trace here..

http://pastebin.com/PAt2UAe7

Any ideas? Bob's souffle is ready, so I need someone else to help me.

Regards,
Jason

_______________________________________________
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

This seems to be it. Not sure where this came from. Let me try again
and get back to you.

Thanks Morten.

Regards,
Jason

···

On Tue, Sep 20, 2011 at 8:46 PM, Morten Olav Hansen <mortenoh@gmail.com> wrote:

This doesn't seem right:
org.hisp.dhis.dialect.H2Dialect

It should probably be org.hibernate.dialect.H2Dialect? (in your
hibernate properties)

--
Morten

On Tue, Sep 20, 2011 at 8:40 PM, Jason Pickering > <jason.p.pickering@gmail.com> wrote:

Hi there. I got a database from Knut, and am trying to get it started
on Amazon Web services. Am running the latest 2.4 war.

Cannot get the thing to start.

Stack trace here..

http://pastebin.com/PAt2UAe7

Any ideas? Bob's souffle is ready, so I need someone else to help me.

Regards,
Jason

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

The reason for the reference to the dhis H2Dialect is that the one
shipped with hibernate 3 was buggy (aknowledged by both h2 and
hibernate team) and we made a new one which was included with dhis. It
might be that this has been fixed in hibernate 3.6 and that the dhis
one is not longer compatible in some way. Let us know if it works.

Lars

···

On Tue, Sep 20, 2011 at 8:57 PM, Jason Pickering <jason.p.pickering@gmail.com> wrote:

This seems to be it. Not sure where this came from. Let me try again
and get back to you.

Thanks Morten.

Regards,
Jason

On Tue, Sep 20, 2011 at 8:46 PM, Morten Olav Hansen <mortenoh@gmail.com> wrote:

This doesn't seem right:
org.hisp.dhis.dialect.H2Dialect

It should probably be org.hibernate.dialect.H2Dialect? (in your
hibernate properties)

--
Morten

On Tue, Sep 20, 2011 at 8:40 PM, Jason Pickering >> <jason.p.pickering@gmail.com> wrote:

Hi there. I got a database from Knut, and am trying to get it started
on Amazon Web services. Am running the latest 2.4 war.

Cannot get the thing to start.

Stack trace here..

http://pastebin.com/PAt2UAe7

Any ideas? Bob's souffle is ready, so I need someone else to help me.

Regards,
Jason

_______________________________________________
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

_______________________________________________
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

Thanks. I tried this and got a while lot of other errors on both windows and linux. Seems like it is something with the db and i do not feel like trying to figure out what. Have asked knut for dxf instead,.

Regards

Jason

···

On Sep 21, 2011 8:09 AM, “Lars Helge Øverland” larshelge@gmail.com wrote:

The reason for the reference to the dhis H2Dialect is that the one

shipped with hibernate 3 was buggy (aknowledged by both h2 and
hibernate team) and we made a new one which was included with dhis. It
might be that this has been fixed in hibernate 3.6 and that the dhis

one is not longer compatible in some way. Let us know if it works.

Lars

On Tue, Sep 20, 2011 at 8:57 PM, Jason Pickering > jason.p.pickering@gmail.com wrote:

This seems to be it. Not sure where this came from. Let me try again
and get back to you.

Thanks Morten.

Regards,
Jason

On Tue, Sep 20, 2011 at 8:46 PM, Morten Olav Hansen mortenoh@gmail.com wrote:

This doesn’t seem right:
org.hisp.dhis.dialect.H2Dialect

It should probably be org.hibernate.dialect.H2Dialect? (in your
hibernate properties)


Morten

On Tue, Sep 20, 2011 at 8:40 PM, Jason Pickering >>> jason.p.pickering@gmail.com wrote:

Hi there. I got a database from Knut, and am trying to get it started

on Amazon Web services. Am running the latest 2.4 war.

Cannot get the thing to start.

Stack trace here…

http://pastebin.com/PAt2UAe7

Any ideas? Bob’s souffle is ready, so I need someone else to help me.

Regards,
Jason


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


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

Hi, I tested using the hibernate H2Dialect and it seems OK here. I
have uploaded a new live package at dhis2.org with the updated
hibernate.properties and the latest 2.4 war build.

Lars

···

2011/9/21 Jason Pickering <jason.p.pickering@gmail.com>:

Thanks. I tried this and got a while lot of other errors on both windows and
linux. Seems like it is something with the db and i do not feel like trying
to figure out what. Have asked knut for dxf instead,.
Regards
Jason

On Sep 21, 2011 8:09 AM, "Lars Helge Øverland" <larshelge@gmail.com> wrote:

The reason for the reference to the dhis H2Dialect is that the one
shipped with hibernate 3 was buggy (aknowledged by both h2 and
hibernate team) and we made a new one which was included with dhis. It
might be that this has been fixed in hibernate 3.6 and that the dhis
one is not longer compatible in some way. Let us know if it works.

Lars

On Tue, Sep 20, 2011 at 8:57 PM, Jason Pickering >> <jason.p.pickering@gmail.com> wrote:

This seems to be it. Not sure where this came from. Let me try again
and get back to you.

Thanks Morten.

Regards,
Jason

On Tue, Sep 20, 2011 at 8:46 PM, Morten Olav Hansen <mortenoh@gmail.com> >>> wrote:

This doesn't seem right:
org.hisp.dhis.dialect.H2Dialect

It should probably be org.hibernate.dialect.H2Dialect? (in your
hibernate properties)

--
Morten

On Tue, Sep 20, 2011 at 8:40 PM, Jason Pickering >>>> <jason.p.pickering@gmail.com> wrote:

Hi there. I got a database from Knut, and am trying to get it started
on Amazon Web services. Am running the latest 2.4 war.

Cannot get the thing to start.

Stack trace here..

http://pastebin.com/PAt2UAe7

Any ideas? Bob's souffle is ready, so I need someone else to help me.

Regards,
Jason

_______________________________________________
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

_______________________________________________
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

See here for the H2 hibernate.properties:

http://dhis2.org/development#databasesetup

Thanks for all the help. In this case, it was a combination of using
the old H2 dialect string and not having the username and password to
the H2 database.

I managed to get a lot of help from Knut, who provided me with some
DXF which worked fine. So, I have the Ethiopia database from Knut
running on AWS on both Postgres as well as H2.

I mostly wanted to try and get H2 running, in order to compare to what
this runs like on an Amazon Web Service micro instance, compared to
running the instance with both Tomcat and Postgres versus Tomcat and
H2.

If I come up with any sort of touchy-feely metrics as to which one is
faster, I will let everyone know.

Regards,
Jason

···

2011/9/21 Lars Helge Øverland <larshelge@gmail.com>:

See here for the H2 hibernate.properties:

http://dhis2.org/development#databasesetup