AnsweredAssumed Answered

conneting  activiti with oracle

Question asked by vijayd on Mar 3, 2014
Latest reply on Mar 10, 2014 by jbarrez
try to connect with oracle 9g getting follwoing error while staring tomcat server      

at org.springframework.web.context.ContextLoader.configureAndRefreshWebA
pplicationContext(ContextLoader.java:383)
        at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:283)
        at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:111)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:4939)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContex
t.java:5434)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:87
7)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:983)

        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:
1660)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:44
1)
        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(ThreadPoolExec
utor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:908)
        at java.lang.Thread.run(Thread.java:662)
Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriverá'
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriverá
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
der.java:1702)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
der.java:1547)
        at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(Basic
DataSource.java:1420)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:1371)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
.java:1044)
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(D
ataSourceUtils.java:111)
        at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$T
ransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:224
)
        at $Proxy6.getMetaData(Unknown Source)
        at org.activiti.engine.impl.db.DbSqlSession.isTablePresent(DbSqlSession.
java:770)
        at org.activiti.engine.impl.db.DbSqlSession.isEngineTablePresent(DbSqlSe
ssion.java:756)
        at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.
java:708)
        at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProce
ssEngineBuild(DbSqlSession.java:1015)
        at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(S
chemaOperationsProcessEngineBuild.java:25)
        at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandIn
voker.java:24)
        at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execut
e(CommandContextInterceptor.java:57)
        at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(Sp
ringTransactionInterceptor.java:47)
        at org.springframework.transaction.support.TransactionTemplate.execute(T
ransactionTemplate.java:130)
        at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransa
ctionInterceptor.java:45)
        at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterc
eptor.java:31)
        at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecu
torImpl.java:40)
        at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.j
ava:72)
        at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProc
essEngine(ProcessEngineConfigurationImpl.java:363)
        at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngi
ne(SpringProcessEngineConfiguration.java:61)
        at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineF
actoryBean.java:56)
        at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineF
actoryBean.java:32)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.
doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.
getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102)
        at or05:53:35,355 [localhost-startStop-1] INFO  org.springframework.bean
s.factory.support.DefaultListableBeanFactory  - Destroying singletons in org.spr
ingframework.beans.factory.support.DefaultListableBeanFactory@40d611: defining b
eans [demoDataGenerator,dbProperties,dataSource,transactionManager,processEngine
Configuration,processEngine,repositoryService,runtimeService,taskService,history
Service,managementService,identityService,activitiLoginHandler,activitiUiPropert
yPlaceholder,navigatorManager,attachmentRendererManager,formPropertyRendererMana
ger,variableRendererManager,componentFactories,processDefinitionFilterFactory,de
ploymentFilterFactory,navigationFragmentChangeListener,mainWindow,explorerApp,si
mpleWorkflowJsonConverter,i18nManager,scopedTarget.messageSource,messageSource,n
otificationManager,viewManager,workflowDefinitionConversionFactory]; root of fac
tory hierarchy
05:53:35,355 [localhost-startStop-1] ERROR org.springframework.web.context.Conte
xtLoader  - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'demoDataGenerator' defined in ServletContext resource [/WEB-INF/activiti
-standalone-context.xml]: Cannot resolve reference to bean 'processEngine' while
setting bean property 'processEngine'; nested exception is org.springframework.
beans.factory.BeanCreationException: Error creating bean with name 'processEngin
e': FactoryBean threw exception on object creation; nested exception is java.uti
l.EmptyStackException
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:328)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:294)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:225)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:291)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:193)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactory.java:609)
        at org.springframework.context.support.AbstractApplicationContext.finish
BeanFactoryInitialization(AbstractApplicationContext.java:918)
        at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:469)
        at org.springframework.web.context.ContextLoader.configureAndRefreshWebA
pplicationContext(ContextLoader.java:383)
        at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:283)
        at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:111)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:4939)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContex
t.java:5434)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:87
7)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:983)

        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:
1660)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:44
1)
        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(ThreadPoolExec
utor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:908)
        at java.lang.Thread.run(Thread.java:662)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creati
ng bean with name 'processEngine': FactoryBean threw exception on object creatio
n; nested exception is java.util.EmptyStackException
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.
doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:149)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.
getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getObje
ctForBeanInstance(AbstractBeanFactory.java:1442)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:305)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:193)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:322)
        … 29 more
Caused by: java.util.EmptyStackException
        at java.util.Stack.peek(Stack.java:85)
        at org.activiti.engine.impl.context.Context.getExecutionContext(Context.
java:68)
        at org.activiti.engine.impl.interceptor.CommandContext.exception(Command
Context.java:188)
        at org.activiti.engine.impl.interceptor.CommandContext.close(CommandCont
ext.java:153)
        at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execut
e(CommandContextInterceptor.java:66)
        at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(Sp
ringTransactionInterceptor.java:47)
        at org.springframework.transaction.support.TransactionTemplate.execute(T
ransactionTemplate.java:130)
        at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransa
ctionInterceptor.java:45)
        at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterc
eptor.java:31)
        at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecu
torImpl.java:40)
        at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.j
ava:72)
        at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProc
essEngine(ProcessEngineConfigurationImpl.java:363)
        at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngi
ne(SpringProcessEngineConfiguration.java:61)
        at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineF
actoryBean.java:56)
        at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineF
actoryBean.java:32)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.
doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
        … 34 more
3 Mar, 2014 5:53:35 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
3 Mar, 2014 5:53:35 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/activiti-explorer] startup failed due to previous errors
3 Mar, 2014 5:53:35 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive D:\Servers\apache-tomcat-7.0.47-windows-
x86\apache-tomcat-7.0.47\webapps\activiti-rest.war
05:53:36,801 [localhost-startStop-1] INFO  org.activiti.rest.common.servlet.Acti
vitiServletContextListener  - Booting Activiti Process Engine
05:53:36,805 [localhost-startStop-1] INFO  org.activiti.engine.ProcessEngines  -
Initializing process engine using Spring configuration 'file:/D:/Servers/apache
-tomcat-7.0.47-windows-x86/apache-tomcat-7.0.47/webapps/activiti-rest/WEB-INF/cl
asses/activiti-context.xml'
05:53:36,887 [localhost-startStop-1] INFO  org.springframework.beans.factory.xml
.XmlBeanDefinitionReader  - Loading XML bean definitions from URL [file:/D:/Serv
ers/apache-tomcat-7.0.47-windows-x86/apache-tomcat-7.0.47/webapps/activiti-rest/
WEB-INF/classes/activiti-context.xml]
05:53:36,915 [localhost-startStop-1] INFO  org.springframework.context.support.G
enericXmlApplicationContext  - Refreshing org.springframework.context.support.Ge
nericXmlApplicationContext@1386751: startup date [Mon Mar 03 17:53:36 IST 2014];
root of context hierarchy
05:53:36,970 [localhost-startStop-1] INFO  org.springframework.beans.factory.con
fig.PropertyPlaceholderConfigurer  - Loading properties file from class path res
ource [db.properties]
05:53:36,976 [localhost-startStop-1] INFO  org.springframework.beans.factory.sup
port.DefaultListableBeanFactory  - Pre-instantiating singletons in org.springfra
mework.beans.factory.support.DefaultListableBeanFactory@1ad186f: defining beans
[demoDataGenerator,dbProperties,dataSource,transactionManager,processEngineConfi
guration,processEngine]; root of factory hierarchy
05:53:37,738 [localhost-startStop-1] INFO  org.activiti.engine.impl.db.DbSqlSess
ion  - performing create on engine with resource org/activiti/db/create/activiti
.h2.create.engine.sql
05:53:37,759 [localhost-startStop-1] INFO  org.activiti.engine.impl.db.DbSqlSess
ion  - performing create on history with resource org/activiti/db/create/activit
i.h2.create.history.sql
05:53:37,764 [localhost-startStop-1] INFO  org.activiti.engine.impl.db.DbSqlSess
ion  - performing create on identity with resource org/activiti/db/create/activi
ti.h2.create.identity.sql
05:53:37,766 [localhost-startStop-1] INFO  org.activiti.engine.impl.ProcessEngin
eImpl  - ProcessEngine default created
05:53:37,769 [localhost-startStop-1] INFO  org.activiti.rest.service.demo.DemoDa
taGenerator  - Initializing demo groups
05:53:37,828 [localhost-startStop-1] INFO  org.activiti.rest.service.demo.DemoDa
taGenerator  - Initializing demo users
05:53:37,854 [localhost-startStop-1] INFO  org.activiti.rest.service.demo.DemoDa
taGenerator  - Initializing demo process definitions
05:53:37,860 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource createTimersProcess.bpmn20.xml
05:53:37,945 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource Helpdesk.png
05:53:37,945 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource reviewSalesLead.bpmn20.xml
05:53:38,250 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource FixSystemFailureProcess.png
05:53:38,250 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource VacationRequest.png
05:53:38,250 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource VacationRequest.bpmn20.xml
05:53:38,268 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource oneTaskProcess.bpmn20.xml
05:53:38,281 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource FixSystemFailureProcess.bpmn20.xml
05:53:38,295 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource Helpdesk.bpmn20.xml
05:53:38,326 [localhost-startStop-1] INFO  org.activiti.rest.service.demo.DemoDa
taGenerator  - Initializing demo models
3 Mar, 2014 5:53:38 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory D:\Servers\apache-tomcat-7.0.47-window
s-x86\apache-tomcat-7.0.47\webapps\docs
3 Mar, 2014 5:53:38 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory D:\Servers\apache-tomcat-7.0.47-window
s-x86\apache-tomcat-7.0.47\webapps\examples
3 Mar, 2014 5:53:39 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory D:\Servers\apache-tomcat-7.0.47-window
s-x86\apache-tomcat-7.0.47\webapps\host-manager
3 Mar, 2014 5:53:39 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory D:\Servers\apache-tomcat-7.0.47-window
s-x86\apache-tomcat-7.0.47\webapps\manager
3 Mar, 2014 5:53:39 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory D:\Servers\apache-tomcat-7.0.47-window
s-x86\apache-tomcat-7.0.47\webapps\ROOT
3 Mar, 2014 5:53:39 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-apr-8080"]
3 Mar, 2014 5:53:39 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-apr-8009"]
3 Mar, 2014 5:53:39 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 11899 ms

Outcomes