Oracle Database - Klaros Test Management - Forum - Klaros Test Management
Oracle Database
Jacopo Doria, modified 6 Years ago.
Oracle Database
Youngling Post: 1 Join Date: 5/11/17 Recent Posts
Hi,
I tried to change the default db from derby to Oracle.
I followed the tutorial I found here (http://klaros-testmanagement.com/en/) but I have always this error message in log file:
According to the guide, I set the number of open_cursor to 2000 (even if I think this is an horrible suggestion...), but without any result.
Could you help me?
I tried to change the default db from derby to Oracle.
I followed the tutorial I found here (http://klaros-testmanagement.com/en/) but I have always this error message in log file:
2017-05-11 17:53:42: INFO, org.hibernate.dialect.Dialect HHH000400: Using dialect: org.hibernate.dialect.Oracle10gDialect | |
2017-05-11 17:53:43: INFO, org.hibernate.validator.internal.util.Version HV000001: Hibernate Validator 4.3.2.Final | |
2017-05-11 17:53:44: INFO, org.hibernate.search.Version HSEARCH000034: Hibernate Search 4.5.3.Final | |
2017-05-11 17:53:57: WARN, org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Error: 1000, SQLState: 72000 | |
2017-05-11 17:53:57: ERROR, org.hibernate.engine.jdbc.spi.SqlExceptionHelper ORA-01000: maximum open cursors exceeded | |
2017-05-11 17:53:57: ERROR, org.hibernate.tool.hbm2ddl.SchemaUpdate HHH000299: Could not complete schema update | |
java.lang.NullPointerException: null | |
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) | |
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) | |
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:158) | |
at org.hibernate.cfg.Configuration.generateSchemaUpdateScriptList(Configuration.java:1283) | |
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:237) | |
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:203) | |
at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:522) | |
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1859) | |
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1930) | |
at org.springframework.orm.hibernate4.LocalSessionFactoryBuilder.buildSessionFactory(LocalSessionFactoryBuilder.java:372) | |
at org.springframework.orm.hibernate4.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:454) | |
at de.verit.klaros.core.dao.hibernate.KlarosLocalSessionFactoryBean.buildSessionFactory(KlarosLocalSessionFactoryBean.java:68) | |
at org.springframework.orm.hibernate4.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:439) | |
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637) | |
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574) | |
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545) | |
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) | |
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) | |
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) | |
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) | |
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) | |
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351) | |
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) | |
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481) | |
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226) | |
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543) | |
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) | |
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) | |
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) | |
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) | |
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) | |
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772) | |
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839) | |
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538) | |
at org.jboss.seam.ioc.spring.ContextLoader.startupContextLoader(ContextLoader.java:64) | |
at org.jboss.seam.ioc.spring.ContextLoader.create(ContextLoader.java:43) | |
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:606) | |
at org.jboss.seam.util.Reflections.invoke(Reflections.java:22) | |
at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:144) | |
at org.jboss.seam.Component.callComponentMethod(Component.java:2313) | |
at org.jboss.seam.Component.callCreateMethod(Component.java:2236) | |
at org.jboss.seam.Component.newInstance(Component.java:2196) | |
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:343) | |
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:335) | |
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:317) | |
at org.jboss.seam.contexts.ServletLifecycle.endInitialization(ServletLifecycle.java:143) | |
at org.jboss.seam.init.Initialization.init(Initialization.java:813) | |
at org.jboss.seam.servlet.SeamListener.contextInitialized(SeamListener.java:36) | |
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4853) | |
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314) | |
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145) | |
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:753) | |
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:729) | |
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717) | |
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:940) | |
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1816) | |
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) | |
at java.util.concurrent.FutureTask.run(FutureTask.java:262) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) | |
at java.lang.Thread.run(Thread.java:745) | |
2017-05-11 17:53:58: WARN, org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Error: 942, SQLState: 42000 | |
2017-05-11 17:53:58: ERROR, org.hibernate.engine.jdbc.spi.SqlExceptionHelper ORA-00942: table or view does not exist |
Could you help me?
Torsten Stolpmann, modified 6 Years ago.
RE: Oracle Database (Answer)
Jedi Council Member Posts: 755 Join Date: 2/12/09 Recent Posts
Hi Jacopo,
This is a bug in the distributed oracle driver (ojdbc7 12.1.0.2.0). See https://community.oracle.com/thread/3682300
Remove the driver webapps/klaros-web/WEB-INF/libs/ojdbc7-12.1.0.2.0.jar and add the attached jar, then restart your tomcat server.
We will change this in the upcoming 4.7.0 release.
Please let me know if this works for you.
Kind regards,
Torsten
This is a bug in the distributed oracle driver (ojdbc7 12.1.0.2.0). See https://community.oracle.com/thread/3682300
Remove the driver webapps/klaros-web/WEB-INF/libs/ojdbc7-12.1.0.2.0.jar and add the attached jar, then restart your tomcat server.
We will change this in the upcoming 4.7.0 release.
Please let me know if this works for you.
Kind regards,
Torsten