conneting activiti with oracle

[vijayd]

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

[jbarrez]

The error is quite clear …

<code>
Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriverá'
</code>

You need to put the database driver on the classpath.