10,608
社区成员
发帖
与我相关
我的任务
分享SSH连接sqlserver出错
这几天公司要做一个web项目，用ssh框架，今天学习孙宇老师的sshe框架的搭建，其中连接数据库部分连接不上公司的sql server 2012，运行时显示如下：
console里信息如下：
[INFO][2017-03-11 15:06:32,897][org.springframework.web.context.ContextLoader]Root WebApplicationContext: initialization started
[INFO][2017-03-11 15:06:32,958][org.springframework.web.context.support.XmlWebApplicationContext]Refreshing Root WebApplicationContext: startup date [Sat Mar 11 15:06:32 CST 2017]; root of context hierarchy
[INFO][2017-03-11 15:06:33,029][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/classes/spring.xml]
[INFO][2017-03-11 15:06:33,231][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/classes/spring-hibernate.xml]
[INFO][2017-03-11 15:06:33,306][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/classes/spring-druid.xml]
[INFO][2017-03-11 15:06:33,325][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/classes/spring-tasks.xml]
[INFO][2017-03-11 15:06:33,360][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/classes/spring-ehcache.xml]
[INFO][2017-03-11 15:06:33,395][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/classes/spring-cxf.xml]
[INFO][2017-03-11 15:06:33,424][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [jar:file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/lib/cxf-rt-core-2.7.7.jar!/META-INF/cxf/cxf.xml]
[INFO][2017-03-11 15:06:33,439][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [jar:file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/lib/cxf-rt-bindings-soap-2.7.7.jar!/META-INF/cxf/cxf-extension-soap.xml]
[INFO][2017-03-11 15:06:33,453][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [jar:file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/lib/cxf-rt-transports-http-2.7.7.jar!/META-INF/cxf/cxf-servlet.xml]
[INFO][2017-03-11 15:06:33,521][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/classes/spring-javamelody.xml]
[INFO][2017-03-11 15:06:33,535][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [jar:file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/lib/javamelody-core-1.47.0.jar!/net/bull/javamelody/monitoring-spring.xml]
[INFO][2017-03-11 15:06:33,775][org.springframework.beans.factory.config.PropertyPlaceholderConfigurer]Loading properties file from class path resource [config.properties]
[INFO][2017-03-11 15:06:33,874][org.springframework.beans.factory.support.DefaultListableBeanFactory]Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@145a438c: defining beans [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,baseDaoImpl,syonlineServiceImpl,syorganizationServiceImpl,syresourceServiceImpl,syresourcetypeServiceImpl,syroleServiceImpl,syuserServiceImpl,baseServiceImpl,initServiceImpl,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,dataSource,sessionFactory,transactionManager,transactionAdvice,org.springframework.aop.config.internalAutoProxyCreator,transactionPointcut,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0,druid-stat-interceptor,druid-stat-pointcut,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#1,org.springframework.scheduling.support.ScheduledMethodRunnable#0,org.springframework.scheduling.config.CronTask#0,org.springframework.scheduling.config.ContextLifecycleScheduledTaskRegistrar#0,org.springframework.cache.annotation.AnnotationCacheOperationSource#0,org.springframework.cache.interceptor.CacheInterceptor#0,org.springframework.cache.config.internalCacheAdvisor,cacheManagerFactory,cacheManager,cxf,org.apache.cxf.bus.spring.BusWiringBeanFactoryPostProcessor,org.apache.cxf.bus.spring.Jsr250BeanPostProcessor,org.apache.cxf.bus.spring.BusExtensionPostProcessor,org.apache.cxf.binding.soap.SoapBindingFactory,org.apache.cxf.binding.soap.SoapTransportFactory,org.apache.cxf.binding.soap.customEditorConfigurer,org.apache.cxf.jaxws.EndpointImpl--1178458449,facadeMonitoringAdvisor,monitoringAdvisor,org.springframework.aop.framework.autoproxy.DefaultAdvisorAutoProxyCreator#0,springDataSourceBeanPostProcessor,org.springframework.context.annotation.ConfigurationClassPostProcessor.importAwareProcessor]; root of factory hierarchy
[WARN][2017-03-11 15:06:34,354][org.apache.cxf.bus.spring.OldSpringSupport]Import of META-INF/cxf/cxf-extension-soap.xml has been deprecated and is unnecessary.
[INFO][2017-03-11 15:06:34,479][com.alibaba.druid.pool.DruidDataSource]{dataSource-1} inited
[INFO][2017-03-11 15:06:34,721][org.hibernate.annotations.common.Version]HCANN000001: Hibernate Commons Annotations {4.0.2.Final}
[INFO][2017-03-11 15:06:34,728][org.hibernate.Version]HHH000412: Hibernate Core {4.2.7.SP1}
[INFO][2017-03-11 15:06:34,729][org.hibernate.cfg.Environment]HHH000206: hibernate.properties not found
[INFO][2017-03-11 15:06:34,731][org.hibernate.cfg.Environment]HHH000021: Bytecode provider name : javassist
[ERROR][2017-03-11 15:06:35,921][com.alibaba.druid.pool.DruidDataSource]create connection error
java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:436)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at net.sf.log4jdbc.DriverSpy.connect(DriverSpy.java:728)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:146)
at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:211)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:140)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1355)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1409)
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1649)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:69)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:157)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
at java.net.Socket.connect(Socket.java:579)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:251)
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:331)
... 8 more
然后我换了mysql数据库，就可以运行，这是怎么回事？求大神解答！！我毫无头绪啊。。。
console里信息如下：
[INFO][2017-03-11 15:06:32,897][org.springframework.web.context.ContextLoader]Root WebApplicationContext: initialization started
[INFO][2017-03-11 15:06:32,958][org.springframework.web.context.support.XmlWebApplicationContext]Refreshing Root WebApplicationContext: startup date [Sat Mar 11 15:06:32 CST 2017]; root of context hierarchy
[INFO][2017-03-11 15:06:33,029][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/classes/spring.xml]
[INFO][2017-03-11 15:06:33,231][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/classes/spring-hibernate.xml]
[INFO][2017-03-11 15:06:33,306][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/classes/spring-druid.xml]
[INFO][2017-03-11 15:06:33,325][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/classes/spring-tasks.xml]
[INFO][2017-03-11 15:06:33,360][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/classes/spring-ehcache.xml]
[INFO][2017-03-11 15:06:33,395][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/classes/spring-cxf.xml]
[INFO][2017-03-11 15:06:33,424][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [jar:file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/lib/cxf-rt-core-2.7.7.jar!/META-INF/cxf/cxf.xml]
[INFO][2017-03-11 15:06:33,439][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [jar:file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/lib/cxf-rt-bindings-soap-2.7.7.jar!/META-INF/cxf/cxf-extension-soap.xml]
[INFO][2017-03-11 15:06:33,453][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [jar:file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/lib/cxf-rt-transports-http-2.7.7.jar!/META-INF/cxf/cxf-servlet.xml]
[INFO][2017-03-11 15:06:33,521][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/classes/spring-javamelody.xml]
[INFO][2017-03-11 15:06:33,535][org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from URL [jar:file:/D:/QQproject/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sshe/WEB-INF/lib/javamelody-core-1.47.0.jar!/net/bull/javamelody/monitoring-spring.xml]
[INFO][2017-03-11 15:06:33,775][org.springframework.beans.factory.config.PropertyPlaceholderConfigurer]Loading properties file from class path resource [config.properties]
[INFO][2017-03-11 15:06:33,874][org.springframework.beans.factory.support.DefaultListableBeanFactory]Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@145a438c: defining beans [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,baseDaoImpl,syonlineServiceImpl,syorganizationServiceImpl,syresourceServiceImpl,syresourcetypeServiceImpl,syroleServiceImpl,syuserServiceImpl,baseServiceImpl,initServiceImpl,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,dataSource,sessionFactory,transactionManager,transactionAdvice,org.springframework.aop.config.internalAutoProxyCreator,transactionPointcut,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0,druid-stat-interceptor,druid-stat-pointcut,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#1,org.springframework.scheduling.support.ScheduledMethodRunnable#0,org.springframework.scheduling.config.CronTask#0,org.springframework.scheduling.config.ContextLifecycleScheduledTaskRegistrar#0,org.springframework.cache.annotation.AnnotationCacheOperationSource#0,org.springframework.cache.interceptor.CacheInterceptor#0,org.springframework.cache.config.internalCacheAdvisor,cacheManagerFactory,cacheManager,cxf,org.apache.cxf.bus.spring.BusWiringBeanFactoryPostProcessor,org.apache.cxf.bus.spring.Jsr250BeanPostProcessor,org.apache.cxf.bus.spring.BusExtensionPostProcessor,org.apache.cxf.binding.soap.SoapBindingFactory,org.apache.cxf.binding.soap.SoapTransportFactory,org.apache.cxf.binding.soap.customEditorConfigurer,org.apache.cxf.jaxws.EndpointImpl--1178458449,facadeMonitoringAdvisor,monitoringAdvisor,org.springframework.aop.framework.autoproxy.DefaultAdvisorAutoProxyCreator#0,springDataSourceBeanPostProcessor,org.springframework.context.annotation.ConfigurationClassPostProcessor.importAwareProcessor]; root of factory hierarchy
[WARN][2017-03-11 15:06:34,354][org.apache.cxf.bus.spring.OldSpringSupport]Import of META-INF/cxf/cxf-extension-soap.xml has been deprecated and is unnecessary.
[INFO][2017-03-11 15:06:34,479][com.alibaba.druid.pool.DruidDataSource]{dataSource-1} inited
[INFO][2017-03-11 15:06:34,721][org.hibernate.annotations.common.Version]HCANN000001: Hibernate Commons Annotations {4.0.2.Final}
[INFO][2017-03-11 15:06:34,728][org.hibernate.Version]HHH000412: Hibernate Core {4.2.7.SP1}
[INFO][2017-03-11 15:06:34,729][org.hibernate.cfg.Environment]HHH000206: hibernate.properties not found
[INFO][2017-03-11 15:06:34,731][org.hibernate.cfg.Environment]HHH000021: Bytecode provider name : javassist
[ERROR][2017-03-11 15:06:35,921][com.alibaba.druid.pool.DruidDataSource]create connection error
java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:436)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at net.sf.log4jdbc.DriverSpy.connect(DriverSpy.java:728)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:146)
at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:211)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:140)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1355)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1409)
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1649)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:69)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:157)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
at java.net.Socket.connect(Socket.java:579)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:251)
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:331)
... 8 more
然后我换了mysql数据库，就可以运行，这是怎么回事？求大神解答！！我毫无头绪啊。。。
...全文
请发表友善的回复…
发表回复
