← Back to team overview

dhis2-users team mailing list archive

Re: Error in DHIS2

 

Thanks for Reply.

DHIS_HOME directory hibernate.properties file

The following information in that file

hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
hibernate.connection.driver_class = org.postgresql.Driver
hibernate.connection.url = jdbc:postgresql:dhis_db
hibernate.connection.username = postgres
hibernate.connection.password = <server password>
hibernate.hbm2ddl.auto = update


Thanks & Regards

*Chandrasekar Ravi*
*Scientist - C, Data Manager*

*GHSA MAHA CDC Project*


*National Institute of Epidemiology, ICMR127, Second Main Road,
TNHBAyapakkam, Ambattur, Chennai – 77*
*aravindraci@xxxxxxxxx <aravindraci@xxxxxxxxx>,*
*9787214185*

On Tue, Aug 23, 2016 at 3:16 PM, Michael Mwebaze <michael.mwebaze@xxxxxxxxx>
wrote:

> Hi Ravi,
>
> do you have the environment variable DHIS2_HOME pointing to the directory
> containing either hibernate.properties or dhis.conf configuration files?
> Below is a link to a sample configuration file and you can just limit to
> the section 'Database connection for PostgreSQL'
>
> http://dhis2.github.io/dhis2-docs/2.22/en/implementer/html/ch08s07.html
>
> Regards,
>
> Michael
>
> On 23 August 2016 at 01:10, Chandrasekar Ravi <aravindraci@xxxxxxxxx>
> wrote:
>
>> Dear Team,
>>
>> When i am trying to open the dhis2 software in web browser. It shows the
>> following error. How to rectify it?
>>
>> : org.springframework.transaction.CannotCreateTransactionException:
>> Could not open Hibernate Session for transaction; nested exception is
>> org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC
>> Connection
>>
>> Thanks & Regards
>>
>> *Chandrasekar Ravi*
>> *Scientist - C, Data Manager*
>>
>> *GHSA MAHA CDC Project*
>>
>>
>> *National Institute of Epidemiology, ICMR127, Second Main Road,
>> TNHBAyapakkam, Ambattur, Chennai – 77*
>> *aravindraci@xxxxxxxxx <aravindraci@xxxxxxxxx>,*
>> *9787214185 <9787214185>*
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>

Follow ups

References