Question

Could not open JDBC Connection for transaction

org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:240)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)
at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:81)
at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:380)
at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:64)
at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:56)
at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:32)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
... 44 more

Answer 1

在 计算机--设备--服务与应用程序--服务 里看数据库是否打开，然后检查jar包是否正确，还有查看数据库密码

Answer 2

先确保数据 库服务打开；
再看看账号密码端口是否正确，
还有驱动包

追问

这些没问题

追答

是mysql数据库吗？
数据库没有开放权限，需要在mysql数据库中做设置，先开放给所有的用户、在所有的IP地址上都可以访问数据库的权限。

先开放root用户的权限，假定密码是111111：
GRANT all privileges ON *.* to root@ IDENTIFIED BY "111111";

然后开放其他用户权限：
如果用户名是lxy,密码是111111，则
GRANT……

---------------------------------------------------------------------------
重置了密码和权限开放应该能搞定

Answer 3

没生意不好

Answer 4

应该是网络问题