org.springframework.dao.DataAccessResourceFailureException: Cannot open connecti
SSH连接数据库异常，连接不上去，麻烦哪位大侠救救我，下面是报错信息：
org.springframework.dao.DataAccessResourceFailureException: Cannot open connection; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection
Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:849)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:840)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:836)
at com.accp.dao.jb_crm_team0.Imp.SysUserDAO.findByProperty(SysUserDAO.java:191)
at com.accp.dao.jb_crm_team0.Imp.SysUserDAO.findByUsrName(SysUserDAO.java:199)
at com.accp.service.LoginService.validUser(LoginService.java:21)
at com.accp.service.LoginService$$FastClassByCGLIB$$ed71417.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:696)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:631)
at com.accp.service.LoginService$$EnhancerByCGLIB$$c55f9ee2.validUser(<generated>)
at com.accp.struts.action.LoginAction.doLogin(LoginAction.java:48)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)
at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.accp.filter.RightFilter.doFilter(RightFilter.java:29)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.accp.filter.EncodeFilter.doFilter(EncodeFilter.java:22)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
... 67 more --------------------编程问答-------------------- 先顶顶 --------------------编程问答-------------------- 我测试过，就是到红色字体那出现问题
// 用户登录
public ActionForward doLogin(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
System.out.println("登录系统");
HttpSession session = request.getSession();
// session.setMaxInactiveInterval(30);
PrintWriter out = response.getWriter();
String userName = request.getParameter("userName");
String password = request.getParameter("password");
try {
List<SysUser> users = loginService.validUser(userName); if (users.isEmpty()) {
out.print("{success:false,msg:'此用户不存在'}");
} else {
for (int i = 0; i < users.size(); i++) {
if (password.equals(users.get(i).getUsrPassword())) {
System.out.println("登录成功");
out.print("{success:true,msg:'登录成功'}");
Long userId = users.get(i).getUsrId();
Long roleId = users.get(i).getSysRole().getRoleId();
System.out.println("角色编号：" + roleId);
// 把用户的名称、角色名称还有编号放入到session中
session.setAttribute("userId", userId);
session.setAttribute("userName", userName);
session.setAttribute("roleId", roleId);
// 用户成功登录之后把他的权限(即可以访问的地址)放入到Session中
String[] rightUrl = rightService.findRight(users.get(i)
.getSysRole().getRoleId());
session.setAttribute("rightUrl", rightUrl);
for (int j = 0; j < rightUrl.length; j++) {
System.out.println("该用户可以访问的地址有："
+ rightUrl[j].toString());
}
} else {
out.print("{success:false,msg:'登录失败,密码不正确'}");
}
}
}
} catch (Exception e) {
e.printStackTrace();
out.print("{success:false,msg:'系统异常,登录失败'}");
} --------------------编程问答-------------------- List users = loginService.validUser(userName);
把loginService这个类 贴出来看看
吧数据库连接类贴出来啊 要不怎么知道哪错了 --------------------编程问答-------------------- package com.accp.service;
import java.util.List;
import com.accp.dao.jb_crm_team0.Inf.ISysUserDAO;
import com.accp.entity.jb_crm_team0.SysUser;
public class LoginService {
private ISysUserDAO sysUserDao = null;
public ISysUserDAO getSysUserDao() {
return sysUserDao;
}
public void setSysUserDao(ISysUserDAO sysUserDao) {
this.sysUserDao = sysUserDao;
}
// 验证用户
public List<SysUser> validUser(String userName) {
return sysUserDao.findByUsrName(userName);
}
// 修改用户密码
public void updatePwd(SysUser user) {
sysUserDao.merge(user);
}
public SysUser findById(Long userId) {
return sysUserDao.findById(userId);
}
} --------------------编程问答-------------------- 很明显的错误，连接不到数据库，caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. --------------------编程问答-------------------- 检查下数据源的配置 --------------------编程问答-------------------- 配置连接数据库的地方有问题。 --------------------编程问答-------------------- 数据库连接其他项目都没问题，就是连接这个项目才有问题的， --------------------编程问答-------------------- 问题解决啦！！！就是配置数据库出问题了，谢谢大家 --------------------编程问答--------------------
补充：Java , Web 开发
