dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hello Marimo,

can you please post the content of your hibernate.properties file (except
the password of course!). Could it be that you use the postgres dialect
with a mysql connection string?

regards,

Lars



On Tue, Jul 2, 2013 at 4:05 PM, Moses Marimo <marimo@xxxxxxxxx> wrote:

> Is there anyone with a good step by step tutorial of configuring DHIS2
> with MySQL. I don't seem to be getting that to work though PostgreSQL
> work on the same server without a problem.
>
> I keep getting this error:
> -------------------------------------------------------------
>
> INFO: Deploying web application directory /var/lib/tomcat7/webapps/dhis
> Jul 02, 2013 4:05:29 PM org.apache.catalina.loader.WebappClassLoader
> validateJarFile
> INFO:
> validateJarFile(/var/lib/tomcat7/webapps/dhis/WEB-INF/lib/geronimo-servlet_2.5_spec-1.1.2.jar)
> - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending
> class: javax/servlet/Servlet.class
> * INFO  2013-07-02 16:05:42,292 System property dhis2.home not set
> (DefaultLocationManager.java [localhost-startStop-1])
> * INFO  2013-07-02 16:05:42,295 Environment variable DHIS2_HOME points
> to /home/marimo/config (DefaultLocationManager.java
> [localhost-startStop-1])
> * ERROR 2013-07-02 16:05:47,080 HHH000299: Could not complete schema
> update (SchemaUpdate.java [localhost-startStop-1])
> java.lang.NullPointerException
>         at
> org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:156)
>         at
> org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:70)
>         at
> org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:63)
>         at
> org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:196)
>         at
> org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:178)
>         at
> org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:505)
>         at
> org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1750)
>         at
> org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1788)
>         at
> org.springframework.orm.hibernate4.LocalSessionFactoryBuilder.buildSessionFactory(LocalSessionFactoryBuilder.java:247)
>         at
> org.springframework.orm.hibernate4.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:373)
>         at
> org.springframework.orm.hibernate4.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:358)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1547)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1485)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:524)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:461)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
>         at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:323)
>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:107)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1393)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1134)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:522)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:461)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
>         at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
>
>
>
>
>
> --
> ICT Warehouse (Pvt) Ltd - "The Stockist of e-nnovation"
> 115 Leopold Takawira St / Nelson Mandela
> 2nd Floor St. Barbara House, Harare
> Tel: +263-4-752707, +263-4-780559
> Cell: +263-772-268353
> Direct Line: +263-4-2933218
> Website: www.ict.co.zw
>
>
> Innovative solutions in Web Design and E-Commerce, Software
> Engineering, Mobile and Bulk SMS Solutions, Graphic Design and
> Printing, General ICT Solutions and Consultancy.
>
> _______________________________________________
> 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
>