prodDb.properties issue

33 views

Skip to first unread message

Mr. DingSauce

unread,

Apr 25, 2013, 5:42:10 PM4/25/13

to ozonepla...@googlegroups.com

I am getting an error when I transfer the OWF.war file from tomcat to a new instance of Jetty. It its giving me an issue: java.sql.SQLExceptioon : Table not Found. I am not sure what this is but I think i narrowed it down to

the prodDB.properties. Any suggestions?

Thanks

Tina

unread,

Apr 26, 2013, 8:27:08 AM4/26/13

to ozonepla...@googlegroups.com

Aha - correlating your questions - put prodDb.* (any prodDB files you
have, either directly shipped by us or further generated after
application runs) in the jetty root.

Tina

> --
> You received this message because you are subscribed to the Google Groups
> "ozoneplatform-dev" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to ozoneplatform-...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

Mr. DingSauce

unread,

Apr 29, 2013, 11:18:43 AM4/29/13

to ozonepla...@googlegroups.com

Tina,

I moved the two prodDb files that I have (prodDb.script & prodDb.properties) into the root jetty directory, I am still getting this error. I did notice the properties file has some hsqldb properties associated with it, not sure if they need to be modified. Here is the stacktrace:

013-04-29 08:12:24,824 [main] ERROR StackTrace - Sanitizing stacktrace:

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id0_0_, this_.version as version0_0_, this_.description as descript3_0_0_, this_.email as email0_0_, this_.email_show as email5_0_0_, this_.enabled as enabled0_0_, this_.last_login as last7_0_0_, this_.prev_login as prev8_0_0_, this_.user_real_name as user9_0_0_, this_.username as username0_0_ from person this_ where this_.username=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:629)

at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)

at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)

at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)

at org.codehaus.groovy.grails.orm.hibernate.metaclass.FindByPersistentMethod.doInvokeInternalWithExpressions(FindByPersistentMethod.java:67)

at org.codehaus.groovy.grails.orm.hibernate.metaclass.AbstractClausedStaticPersistentMethod.doInvokeInternal(AbstractClausedStaticPersistentMethod.java:562)

at org.codehaus.groovy.grails.orm.hibernate.metaclass.AbstractStaticPersistentMethod.invoke(AbstractStaticPersistentMethod.java:64)

at org.codehaus.groovy.grails.orm.hibernate.metaclass.AbstractStaticPersistentMethod.invoke(AbstractStaticPersistentMethod.java:57)

at org.codehaus.groovy.grails.commons.metaclass.StaticMethodInvocation$invoke.call(Unknown Source)

at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)

at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)

at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:132)

at org.codehaus.groovy.grails.plugins.orm.hibernate.HibernatePluginSupport$_addDynamicFinderSupport_closure17.doCall(HibernatePluginSupport.groovy:466)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:601)

at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)

at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)

at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)

at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)

at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)

at groovy.lang.Closure.call(Closure.java:282)

at org.codehaus.groovy.runtime.metaclass.ClosureStaticMetaMethod.invoke(ClosureStaticMetaMethod.java:59)

at groovy.lang.MetaClassImpl.invokeStaticMissingMethod(MetaClassImpl.java:1355)

at groovy.lang.MetaClassImpl.invokeStaticMethod(MetaClassImpl.java:1343)

at groovy.lang.ExpandoMetaClass.invokeStaticMethod(ExpandoMetaClass.java:1082)

at groovy.lang.MetaObjectProtocol$invokeStaticMethod.call(Unknown Source)

at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)

at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)

at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:132)

at org.codehaus.groovy.grails.plugins.orm.hibernate.HibernatePluginSupport$_enhanceSessionFactory_closure14.doCall(HibernatePluginSupport.groovy:382)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:601)

at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)

at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)

at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)

at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)

at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)

at groovy.lang.Closure.call(Closure.java:282)

at org.codehaus.groovy.runtime.metaclass.ClosureStaticMetaMethod.invoke(ClosureStaticMetaMethod.java:59)

at groovy.lang.MetaClassImpl.invokeStaticMissingMethod(MetaClassImpl.java:1355)

at groovy.lang.MetaClassImpl.invokeStaticMethod(MetaClassImpl.java:1343)

at groovy.lang.ExpandoMetaClass.invokeStaticMethod(ExpandoMetaClass.java:1082)

at org.codehaus.groovy.runtime.callsite.StaticMetaClassSite.call(StaticMetaClassSite.java:50)

at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)

at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)

at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:124)

at BootStrap.createNewUser(BootStrap.groovy:642)

at BootStrap.this$2$createNewUser(BootStrap.groovy)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:601)

at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)

at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)

at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)

at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)

at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)

at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1003)

at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)

at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)

at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.callCurrent(PogoMetaClassSite.java:66)

at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)

at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)

at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:145)

at BootStrap$_closure1.doCall(BootStrap.groovy:112)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:601)

at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)

at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)

at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)

at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)

at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)

at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:930)

at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)

at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)

at groovy.lang.Closure.call(Closure.java:282)

at groovy.lang.Closure.call(Closure.java:277)

at grails.util.Environment.evaluateEnvironmentSpecificBlock(Environment.java:251)

at grails.util.Environment.executeForEnvironment(Environment.java:244)

at grails.util.Environment.executeForCurrentEnvironment(Environment.java:220)

at org.codehaus.groovy.grails.commons.DefaultGrailsBootstrapClass.callInit(DefaultGrailsBootstrapClass.java:59)

at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.executeGrailsBootstraps(GrailsConfigUtils.java:74)

at org.codehaus.groovy.grails.web.context.GrailsContextLoader.createWebApplicationContext(GrailsContextLoader.java:74)

at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)

at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)

at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:781)

at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:425)

at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:773)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:275)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1321)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:725)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:490)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:69)

at org.eclipse.jetty.util.component.ContainerLifeCycle.addBean(ContainerLifeCycle.java:279)

at org.eclipse.jetty.util.component.ContainerLifeCycle.addBean(ContainerLifeCycle.java:193)

at org.eclipse.jetty.util.component.ContainerLifeCycle.updateBeans(ContainerLifeCycle.java:718)

at org.eclipse.jetty.server.handler.HandlerCollection.setHandlers(HandlerCollection.java:89)

at org.eclipse.jetty.server.handler.ContextHandlerCollection.setHandlers(ContextHandlerCollection.java:165)

at org.eclipse.jetty.server.handler.HandlerCollection.addHandler(HandlerCollection.java:155)

at org.eclipse.jetty.deploy.bindings.StandardDeployer.processBinding(StandardDeployer.java:41)

at org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:186)

at org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:495)

at org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:146)

at org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:175)

at org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:64)

at org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:605)

at org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:528)

at org.eclipse.jetty.util.Scanner.scan(Scanner.java:391)

at org.eclipse.jetty.util.Scanner.doStart(Scanner.java:313)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:69)

at org.eclipse.jetty.deploy.providers.ScanningAppProvider.doStart(ScanningAppProvider.java:145)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:69)

at org.eclipse.jetty.deploy.DeploymentManager.startAppProvider(DeploymentManager.java:557)

at org.eclipse.jetty.deploy.DeploymentManager.doStart(DeploymentManager.java:232)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:69)

at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:108)

at org.eclipse.jetty.server.Server.start(Server.java:348)

at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:90)

at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:58)

at org.eclipse.jetty.server.Server.doStart(Server.java:296)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:69)

at org.eclipse.jetty.xml.XmlConfiguration$1.run(XmlConfiguration.java:1236)

at java.security.AccessController.doPrivileged(Native Method)

at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1160)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:601)

at org.eclipse.jetty.start.Main.invokeMain(Main.java:453)

at org.eclipse.jetty.start.Main.start(Main.java:595)

at org.eclipse.jetty.start.Main.main(Main.java:96)

Caused by: org.hibernate.exception.SQLGrammarException: could not execute query