Hi Roger,
It does certainly sound like a problem with your hibernate.properties.
Are you perchance running Postgres on a nonstandard port (not 5432)?
If you have a Postgres user called dhis with password dhis running on port 5433 on your local machine, the following should be correct:
hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
hibernate.connection.driver_class = org.postgresql.Driver
hibernate.connection.url = jdbc:postgresql://localhost:5433/dhis2
hibernate.connection.username = dhis
hibernate.connection.password = dhis
hibernate.hbm2ddl.auto = update
Knut
···
On Sat, Apr 10, 2010 at 5:20 PM, Friedman, Roger (CDC/OID/NCHHSTP) (CTR) rdf4@cdc.gov wrote:
Hi all.
Edem kindly provided me with a DB dump file to use. It was Postgres but I had installed MySQL. So I just installed Postgres, created the DHIS2 database, created the dhis user and granted all on database to dhis. I reloaded the backup and can see the data in the tables. I stopped dhis in tomcat, changed the hibernate file to the Postgres version, and tried to restart dhis. It fails. It looks like the problem was that hibernate could not open the jdbc connection, message “Connections could not be acquired from the underlying database!”. Excuse me if I don,t type the whole error chain on my Blackberry (remote e-mail access is down right now). Any suggestions? I notice my mysql hibernate file has a //localhost before :dhis2, the Postgres version does not.
Thanks, Roger
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
Cheers,
Knut Staring