Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot

[accpchwb]

大家好！！！
这是我最近使用Struts+Spring+Hibernate这三种框架做的一个项目。。。当我把它部署到服务器里去时出现了如下错误。。。。。。。请哪位有经练的朋友帮我解决一下。。。
----声明...我的应用平台和数据库服务器不在同一台服务器里面....而且数据库是mssqlserver已经打好了SP4的补丁。。。

错误如下：
HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot create PoolableConnectionFactory ([Atinav][JDBC SQL Server Driver:Ver C3.0C] null); nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory ([Atinav][JDBC SQL Server Driver:Ver C3.0C] null)
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:523)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
com.hnhh.peixun.util.SetCharactorEncoding.doFilter(SetCharactorEncoding.java:24)


root cause

org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot create PoolableConnectionFactory ([Atinav][JDBC SQL Server Driver:Ver C3.0C] null); nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory ([Atinav][JDBC SQL Server Driver:Ver C3.0C] null)
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:120)
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276)
org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:377)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:840)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:832)
com.hnhh.peixun.dao.PeixunSkillAchievementDAOImpl.findAll(PeixunSkillAchievementDAOImpl.java:151)
com.hnhh.peixun.service.PeixunSkillAchievementServiceImpl.findAll(PeixunSkillAchievementServiceImpl.java:23)
com.hnhh.peixun.struts.action.AchievementAction.execute(AchievementAction.java:46)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
com.hnhh.peixun.util.SetCharactorEncoding.doFilter(SetCharactorEncoding.java:24)


root cause

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory ([Atinav][JDBC SQL Server Driver:Ver C3.0C] null)
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
org.hibernate.loader.Loader.doQuery(Loader.java:661)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
org.hibernate.loader.Loader.doList(Loader.java:2145)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
org.hibernate.loader.Loader.list(Loader.java:2024)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:849)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:840)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:832)
com.hnhh.peixun.dao.PeixunSkillAchievementDAOImpl.findAll(PeixunSkillAchievementDAOImpl.java:151)
com.hnhh.peixun.service.PeixunSkillAchievementServiceImpl.findAll(PeixunSkillAchievementServiceImpl.java:23)
com.hnhh.peixun.struts.action.AchievementAction.execute(AchievementAction.java:46)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
com.hnhh.peixun.util.SetCharactorEncoding.doFilter(SetCharactorEncoding.java:24)


note The full stack trace of the root cause is available in the Apache Tomcat/5.5.12 logs.


--------------------------------------------------------------------------------

Apache Tomcat/5.5.12




有兴趣的朋友可以帮我看看。。。
http://www.hndatc.com/peixun/achievement.jsp

点查询就出现了刚刚这个错误。。。谢谢。。

[feidao25]

看看hibernate spring配置文件的
<value>
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test
</value>
以上是eclipse自动格式化后的结果。
改成一下形式就OK了，我也是这个错误！原来spring配置datasource不能有空格，我就晕！！！
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test</value>