转了数据库后也修改了jdbc.properties文件,如下:
jdbc.driverClassName=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc.url=jdbc:microsoft:sqlserver://localhost:1433;databaseName=cmsv6
jdbc.username=sa
jdbc.password=admin123
hibernate.db=sqlserver
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
hibernate.hbm.jeecms.core=classpath*:/com/jeecms/core/entity/hbm/*.hbm.xml
hibernate.hbm.jeecms.cms=classpath*:/com/jeecms/cms/entity/main/hbm/*.hbm.xml
hibernate.hbm.jeecms.assist=classpath*:/com/jeecms/cms/entity/assist/hbm/*.hbm.xml
cpool.checkoutTimeout=15000
cpool.minPoolSize=20
cpool.maxPoolSize=50
cpool.maxIdleTime=17200
cpool.maxIdleTimeExcessConnections=1800
cpool.acquireIncrement=10
启动会报错
信息: Initializing Spring root WebApplicationContext
11:10:39.387 ERROR org.hibernate.util.JDBCExceptionReporter - An attempt by a client to checkout a C
onnection has timed out.
11:10:53.391 ERROR org.hibernate.util.JDBCExceptionReporter - Connections could not be acquired from
the underlying database!
11:10:53.393 ERROR org.hibernate.util.JDBCExceptionReporter - Connections could not be acquired from
the underlying database!
11:11:08.396 ERROR org.hibernate.util.JDBCExceptionReporter - An attempt by a client to checkout a C
onnection has timed out.
11:11:08.396 ERROR org.hibernate.util.JDBCExceptionReporter - An attempt by a client to checkout a C
onnection has timed out.
11:11:08.590 ERROR org.springframework.web.context.ContextLoader - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'loadTask' de
fined in ServletContext resource [/WEB-INF/config/quartz-task.xml]: Invocation of init method failed
; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not op
en Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCExcepti
on: Cannot open connection
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(Abst
ractAutowireCapableBeanFactory.java:1512) ~[spring-beans-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(Abstra
ctAutowireCapableBeanFactory.java:521) ~[spring-beans-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(Abstract
AutowireCapableBeanFactory.java:458) ~[spring-beans-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.ja
va:296) ~[spring-beans-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingl
etonBeanRegistry.java:223) ~[spring-beans-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java
:293) ~[spring-beans-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:1
94) ~[spring-beans-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(De
faultListableBeanFactory.java:628) ~[spring-beans-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(A
bstractApplicationContext.java:932) ~[spring-context-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContex
t.java:479) ~[spring-context-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLo
ader.java:389) ~[spring-web-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:294)
~[spring-web-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.j
ava:112) [spring-web-3.2.6.jar:3.2.6.RELEASE]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4994) [catalina.jar:
7.0.57]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5492) [catalina.jar:
7.0.57]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.57]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.
0.57]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.57]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) [catalina.jar:7.0.57]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245) [catalina.jar:7.0.5
7]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895) [catalina.jar:7
.0.57]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [na:1.7.0_45]
at java.util.concurrent.FutureTask.run(FutureTask.java:262) [na:1.7.0_45]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_45]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_45]
at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernat
e Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot
open connection
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManag
er.java:597) ~[spring-orm-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(Abstra
ctPlatformTransactionManager.java:372) ~[spring-tx-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessar
y(TransactionAspectSupport.java:417) ~[spring-tx-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(Tra
nsactionAspectSupport.java:255) ~[spring-tx-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor
.java:94) ~[spring-tx-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.
java:172) ~[spring-aop-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) ~[sprin
g-aop-3.2.6.jar:3.2.6.RELEASE]
at com.sun.proxy.$Proxy59.getList(Unknown Source) ~[na:na]
at com.jeecms.cms.task.LoadTask.loadTask(LoadTask.java:29) ~[LoadTask.class:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_45]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_45]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0
_45]
at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_45]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMet
hod(AbstractAutowireCapableBeanFactory.java:1638) ~[spring-beans-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(A
bstractAutowireCapableBeanFactory.java:1579) ~[spring-beans-3.2.6.jar:3.2.6.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(Abst
ractAutowireCapableBeanFactory.java:1509) ~[spring-beans-3.2.6.jar:3.2.6.RELEASE]
... 25 common frames omitted
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126
) ~[hibernate-3.3.2.jar:na]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114) ~[hibernate-3.3.2.
jar:na]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-3.3
.2.jar:na]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52) ~[hibernate-3.3
.2.jar:na]
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449) ~[hibernate-3.3.
2.jar:na]
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) ~[hibernate-3.3.2
.jar:na]
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142) ~[hibernate-3.3.2.jar:na]
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85) ~[hibernate-3.3.2.jar:n
a]
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354) ~[hibernate-3.3.2.jar:na]
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManag
er.java:556) ~[spring-orm-3.2.6.jar:3.2.6.RELEASE]
... 40 common frames omitted
其他地方未做修改,改一下配置连接mysql数据库是没问题的,求高人指点!急! |
|
