org.h2.jdbc.JdbcSQLException: Connection is broken: 'java.net.ConnectException: Connection refused: connect: localhost' [90067-1

[udhayakumar_t]

Currently i am not using H2 database, i modified the db.properties to use mysql. However, it still tries to access the H2 database and throws the following exception

org.h2.jdbc.JdbcSQLException: Connection is broken: "java.net.ConnectException: Connection refused: connect: localhost" [90067-168]
   at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
   at org.h2.message.DbException.get(DbException.java:158)
   at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:399)
   at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:287)
   at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)
   at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92)
   at org.h2.Driver.connect(Driver.java:72)
   at java.sql.DriverManager.getConnection(Unknown Source)
   at java.sql.DriverManager.getConnection(Unknown Source)
   at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:181)
   at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:176)
   at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:80)
   at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:371)
   at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:80)
   at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.initDatabaseType(ProcessEngineConfigurationImpl.java:525)
   at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.initDataSource(ProcessEngineConfigurationImpl.java:487)
   at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.init(ProcessEngineConfigurationImpl.java:332)
   at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:310)
   at com.hcl.viacom.activiti.ActivitiDeployer.main(ActivitiDeployer.java:26)
Caused by: java.net.ConnectException: Connection refused: connect
   at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
   at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
   at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
   at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
   at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
   at java.net.PlainSocketImpl.connect(Unknown Source)
   at java.net.SocksSocketImpl.connect(Unknown Source)
   at java.net.Socket.connect(Unknown Source)
   at org.h2.util.NetUtils.createSocket(NetUtils.java:119)
   at org.h2.util.NetUtils.createSocket(NetUtils.java:100)
   at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:93)
   at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:395)
   

[jbarrez]

Your db.properties must be wrong. It is still using the H2 database driver.

[chetan1]

org.h2.jdbc.JdbcSQLException: Connection is broken: "java.net.ConnectException: Connection refused: connect: localhost" [90067-1
Follow this thread
Currently i am not using H2 database, i modified the db.properties to use mysql. However, it still tries to access the H2 database and throws the following exception
my db properties are

db=activiti 
jdbc.driver=com.mysql.jdbc.Driver 
jdbc.url=jdbc:mysql://localhost:3306/activiti 
jdbc.username=root 
jdbc.password=





        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 'com.mysql.jdbc.Driverá'
java.lang.ClassNotFoundException: com.mysql.jdbc.Driverá
        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 org.springframework.beans.factory.support.04:07:06,642 [localhost-sta
rtStop-1] INFO  org.springframework.beans.factory.support.DefaultListableBeanFac
tory  - Destroying singletons in org.springframework.beans.factory.support.Defau
ltListableBeanFactory@14562c5: defining beans [demoDataGenerator,dbProperties,da
taSource,transactionManager,processEngineConfiguration,processEngine,repositoryS
ervice,runtimeService,taskService,historyService,managementService,identityServi
ce,activitiLoginHandler,activitiUiPropertyPlaceholder,navigatorManager,attachmen
tRendererManager,formPropertyRendererManager,variableRendererManager,componentFa
ctories,processDefinitionFilterFactory,deploymentFilterFactory,navigationFragmen
tChangeListener,mainWindow,explorerApp,simpleWorkflowJsonConverter,i18nManager,s
copedTarget.messageSource,messageSource,notificationManager,viewManager,workflow
DefinitionConversionFactory]; root of factory hierarchy
04:07:06,643 [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 4:07:06 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
3 Mar, 2014 4:07:06 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/activiti-explorer] startup failed due to previous errors
3 Mar, 2014 4:07:06 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
04:07:07,894 [localhost-startStop-1] INFO  org.activiti.rest.common.servlet.Acti
vitiServletContextListener  - Booting Activiti Process Engine
04:07:07,898 [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'
04:07:07,974 [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]
04:07:08,097 [localhost-startStop-1] INFO  org.springframework.context.support.G
enericXmlApplicationContext  - Refreshing org.springframework.context.support.Ge
nericXmlApplicationContext@1e9d0cc: startup date [Mon Mar 03 16:07:08 IST 2014];
root of context hierarchy
04:07:08,152 [localhost-startStop-1] INFO  org.springframework.beans.factory.con
fig.PropertyPlaceholderConfigurer  - Loading properties file from class path res
ource [db.properties]
04:07:08,158 [localhost-startStop-1] INFO  org.springframework.beans.factory.sup
port.DefaultListableBeanFactory  - Pre-instantiating singletons in org.springfra
mework.beans.factory.support.DefaultListableBeanFactory@301bf5: defining beans [
demoDataGenerator,dbProperties,dataSource,transactionManager,processEngineConfig
uration,processEngine]; root of factory hierarchy
04:07:08,881 [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
04:07:08,902 [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
04:07:08,907 [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
04:07:08,909 [localhost-startStop-1] INFO  org.activiti.engine.impl.ProcessEngin
eImpl  - ProcessEngine default created
04:07:08,912 [localhost-startStop-1] INFO  org.activiti.rest.service.demo.DemoDa
taGenerator  - Initializing demo groups
04:07:08,975 [localhost-startStop-1] INFO  org.activiti.rest.service.demo.DemoDa
taGenerator  - Initializing demo users
04:07:08,996 [localhost-startStop-1] INFO  org.activiti.rest.service.demo.DemoDa
taGenerator  - Initializing demo process definitions
04:07:09,002 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource createTimersProcess.bpmn20.xml
04:07:09,087 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource Helpdesk.png
04:07:09,087 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource reviewSalesLead.bpmn20.xml
04:07:09,399 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource FixSystemFailureProcess.png
04:07:09,399 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource VacationRequest.png
04:07:09,399 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource VacationRequest.bpmn20.xml
04:07:09,417 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource oneTaskProcess.bpmn20.xml
04:07:09,431 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource FixSystemFailureProcess.bpmn20.xml
04:07:09,445 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deploye
r.BpmnDeployer  - Processing resource Helpdesk.bpmn20.xml
04:07:09,472 [localhost-startStop-1] INFO  org.activiti.rest.service.demo.DemoDa
taGenerator  - Initializing demo models
3 Mar, 2014 4:07:09 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 4:07:09 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 4:07:10 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 4:07:10 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 4:07:10 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 4:07:10 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-apr-8080"]
3 Mar, 2014 4:07:10 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-apr-8009"]
3 Mar, 2014 4:07:10 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 11731 ms

[jbarrez]

The error is quite obvious here:

<code>
java.lang.ClassNotFoundException: com.mysql.jdbc.Driverá
</code>

The Mysql db driver is not on the classpath …