Make sure that there is no whitespace after your hbm-line, "update" != "update " as it does not trim options.
-- Morten On Fri, Sep 9, 2011 at 6:22 PM, Jo Størset <stor...@gmail.com> wrote: > Wild guess... hibernate.hbm2ddl.auto = update? > Jo > Den 9. sep. 2011 kl. 17.25 skrev Knut Staring: > > Hi everyone, > Trying to start DHIS2 on Ubuntu against an empty DHIS2 database, we get the > following complaints about missing dhis2.systemsetting table. > Any hints? > Knut > ---------- Forwarded message ---------- > From: Jose Garcia Muñoz <josem...@gmail.com> > Date: 2011/9/9 > Subject: > To: knu...@gmail.com > > > * INFO 17:19:50,505 Environment variable DHIS2_HOME points to > /home/jose/dhis2/DHIS2_HOME (DefaultLocationManager.java [Thread-2]) > * WARN 17:20:19,569 SQL Error: 1146, SQLState: 42S02 > (JDBCExceptionReporter.java [Thread-2]) > * ERROR 17:20:19,570 Table 'dhis2.systemsetting' doesn't exist > (JDBCExceptionReporter.java [Thread-2]) > * ERROR 17:20:19,684 Context initialization failed (ContextLoader.java > [Thread-2]) > org.springframework.beans.factory.BeanCreationException: Error creating bean > with name 'org.hisp.dhis.scheduling.SchedulingManager' defined in URL > [jar:file:/usr/local/apache-tomcat-7.0.8/webapps/dhis/WEB-INF/lib/dhis-service-reporting-2.3.jar!/META-INF/dhis/beans.xml]: > Invocation of init method failed; nested exception is > org.hibernate.exception.SQLGrammarException: could not execute query > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) > at > org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291) > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190) > at > org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580) > at > org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895) > at > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425) > at > org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276) > at > org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197) > at > org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47) > at > org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4723) > at > org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5226) > at > org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5221) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) > at java.util.concurrent.FutureTask.run(FutureTask.java:138) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > at java.lang.Thread.run(Thread.java:662) > Caused by: org.hibernate.exception.SQLGrammarException: could not execute > query > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) > at org.hibernate.loader.Loader.doList(Loader.java:2536) > at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2319) > at org.hibernate.loader.Loader.list(Loader.java:2268) > at > org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119) > at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716) > at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347) > at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369) > at > org.hisp.dhis.hibernate.HibernateGenericStore.getObject(HibernateGenericStore.java:159) > at > org.hisp.dhis.hibernate.HibernateGenericStore.getByName(HibernateGenericStore.java:219) > at > org.hisp.dhis.options.setting.DefaultSystemSettingManager.getSystemSetting(DefaultSystemSettingManager.java:106) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) > at > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) > at $Proxy30.getSystemSetting(Unknown Source) > at > org.hisp.dhis.scheduling.DefaultSchedulingManager.getRunnables(DefaultSchedulingManager.java:122) > at > org.hisp.dhis.scheduling.DefaultSchedulingManager.scheduleTasks(DefaultSchedulingManager.java:77) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1544) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1485) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417) > ... 20 more > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'dhis2.systemsetting' doesn't exist > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) > at com.mysql.jdbc.Util.getInstance(Util.java:381) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885) > at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) > at > org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) > at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) > at org.hibernate.loader.Loader.doQuery(Loader.java:802) > at > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) > at org.hibernate.loader.Loader.doList(Loader.java:2533) > ... 49 more > 09-sep-2011 17:20:19 org.apache.catalina.core.StandardContext startInternal > GRAVE: Error listenerStart > 09-sep-2011 17:20:19 org.apache.catalina.core.StandardContext startInternal > GRAVE: Falló en arranque del Contexto [/dhis] debido a errores previos > 09-sep-2011 17:20:19 org.apache.catalina.loader.WebappClassLoader > clearReferencesJdbc > GRAVE: La aplicación web [/dhis] registró el conductor JDBC > [com.mysql.jdbc.Driver] pero falló al anular el registro mientras la > aplicación web estaba parada. Para prevenir un fallo de memoria, se ha > anulado el registro del conductor JDBC por la fuerza. > 09-sep-2011 17:20:19 org.apache.catalina.loader.WebappClassLoader > clearReferencesThreads > GRAVE: La aplicación web [/dhis] parece haber arrancado un hilo llamado > [MySQL Statement Cancellation Timer] pero no ha podido pararlo. Esto tiene > todas las papeletas de convertirse en un fallo de memoria. > > > > > -- > Knut Staring > Department of Informatics > University of Oslo > http://hisp.uio.no > +4722952249 > _______________________________________________ > 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 > > _______________________________________________ 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
