dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

You must be a bit careful, as the database schema does not always tell
you what is required. If you are populating manually from SQL, you
must set "active" and "haspatients" to something and all other NOT
NULL fields. There is no default in the schema, so you must set it
through the insert statement.From the schema, NULLS are allowed in
"openingdate", but this is not really the case as you have observed.

Regards,
Jason



On Tue, Apr 17, 2012 at 4:15 PM, Romain-Rolland TOHOURI
<romain@xxxxxxxxxxx> wrote:
> Thanks Jason :-D
> now its works! and the second mistake was the fact that was not adding an
> opening date for the orgunits that why I was unable to see them in dhis.
>
> Regards,
>
> Romain
>
> Le 17 avril 2012 14:36, Jason Pickering <jason.p.pickering@xxxxxxxxx> a
> écrit :
>
>> Yes. Classic mistake, made by yours truly at least once (consult the
>> archives)
>>
>> Uncomment out. #hibernate.hbm2ddl.auto = update
>>
>> to
>>
>> hibernate.hbm2ddl.auto = update
>>
>> Regards,
>> Jason
>>
>> On Tue, Apr 17, 2012 at 3:34 PM, Romain-Rolland TOHOURI
>> <romain@xxxxxxxxxxx> wrote:
>> > here is my hibernate.properties file
>> >
>> > #hibernate.dialect = org.hibernate.dialect.H2Dialect
>> > #hibernate.connection.driver_class = org.h2.Driver
>> > #hibernate.connection.url =
>> > jdbc:h2:./database/dhis2;AUTO_SERVER=TRUE;DB_CLOSE_ON_EXIT=FALSE
>> > #hibernate.connection.username = sa
>> > #hibernate.connection.password =
>> >
>> > hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
>> > hibernate.connection.driver_class = org.postgresql.Driver
>> > hibernate.connection.url = jdbc:postgresql:dhis
>> > hibernate.connection.username = dhis
>> > hibernate.connection.password = dhis
>> >
>> > #hibernate.hbm2ddl.auto = update
>> >
>> > Do you see something wrong in it?
>> >
>> > Regards,
>> >
>> > Romain
>> >
>> > Le 17 avril 2012 14:26, Jason Pickering <jason.p.pickering@xxxxxxxxx> a
>> > écrit :
>> >
>> >> What is your hibernate.properties file?
>> >>
>> >> If you populated the table manually, i.e. through SQL, and it gets
>> >> overwritten each time you restart, sounds like an issue with the
>> >> hibernate.properties file  to me.
>> >>
>> >> Not sure about this other error though.
>> >>
>> >> On Tue, Apr 17, 2012 at 3:11 PM, Romain-Rolland TOHOURI
>> >> <romain@xxxxxxxxxxx> wrote:
>> >> > Hello all,
>> >> > I need some help, I'm trying to import an organisation unit from a
>> >> > dhis
>> >> > 2.2
>> >> > into dhis 2.7.
>> >> > I have manually populate date from my previous 2.2 organisationunit
>> >> > table
>> >> > into the dhis 2.7 organisationunit table and I did the same
>> >> > for orgunitlevel
>> >> > table. But after restarting dhis 2.7 I find that the organisationunit
>> >> > and orgunitlevel are empty and I'm not able to see anything from the
>> >> > web
>> >> > interface.
>> >> > Can someone explain me what is happening and how I can solve it?
>> >> >
>> >> > I also notice these two lines in the logs:
>> >> > 2012-04-17 13:54:37.371 java[45912:f203] *** __NSAutoreleaseNoPool():
>> >> > Object
>> >> > 0x100131840 of class NSCFNumber autoreleased with no pool in place -
>> >> > just
>> >> > leaking
>> >> > 2012-04-17 13:54:37.374 java[45912:f203] *** __NSAutoreleaseNoPool():
>> >> > Object
>> >> > 0x1021ad060 of class NSCFArray autoreleased with no pool in place -
>> >> > just
>> >> > leaking
>> >> >
>> >> >
>> >> > Thanks,
>> >> >
>> >> > Romain
>> >> >
>> >> > _______________________________________________
>> >> > Mailing list: https://launchpad.net/~dhis2-devs
>> >> > Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> >> > Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> > More help   : https://help.launchpad.net/ListHelp
>> >> >
>> >
>> >
>> >
>> >
>> > --
>> > Dr Tohouri Romain-Rolland
>> > www.tohouri.com
>
>
>
>
> --
> Dr Tohouri Romain-Rolland
> www.tohouri.com