struts连接池问题，很急！出主意者均有分

Question

小姐接了一个项目的二期，现在拿到的程序死活跑不起来！这个项目是struts的，escplise+jboss开发的！连接数据库的部分使用的是连接池！代码如下：
<?xml version="1.0" encoding="UTF-8"?>
<datasources> 
  <local-tx-datasource>
    <jndi-name>jdbc/mssqlSafety</jndi-name>
    <connection-url>jdbc:jtds:sqlserver://localhost:1433/safety_lz;tds=8.0;lastupdatecount=true</connection-url>
    <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
    <user-name>sa</user-name>
    <password>guoyin</password>
    <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>      
  </local-tx-datasource> 
</datasources>
注：这个文件是在jboss中的server\default\deploy目录下的mssql-ds.xml
启动JBOSS没有问题，工程跑起来之后出这个错误，错误代码如下：
16:52:59,437 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
16:52:59,437 ERROR [JDBCExceptionReporter] Cannot create PoolableConnectionFactory (Network error IOException: Connection timed out: connect)
16:52:59,437 WARN  [SettingsFactory] Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Network error IOException: Connection timed out: connect)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at org.springframework.orm.hibernate.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:76)
at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:73)
at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1132)
但是使用下面的JSP页面进行测试的时候却没有问题，测试代码如下：
<%@ page contentType="text/html; charset=utf-8" pageEncoding="GB2312" language="java" %>
<%@pageimport="javax.naming.*"%> 
<%@pageimport="javax.sql.*"%> 
<%@pageimport="java.sql.*"%> 
<% Context ctx = new InitialContext(); //???????? 
System.out.println("ctx***************" + ctx);
Object obj = ctx.lookup("java:/jdbc/mssqlSafety");//????? 
System.out.println("obj***************" + obj);
DataSource ds = (DataSource) obj;//???DataSurce 
System.out.println("ds***************" + ds);
Connection connect = ds.getConnection();//??????????? 
System.out.println("connect***************" + connect);
Statement stmt = connect.createStatement(); 
System.out.println("stmt***************" + stmt);
ResultSet rs = stmt.executeQuery("select * from OG_USER");//??????????! 
System.out.println("rs***************" + rs);
while(rs.next()){ %>
您的第一个字段内容为：<%=rs.getString(1)%>
<%
} 
%>
我真的很着急，很各位高人帮帮我

Answer 1

今天运气不错 大清早就能接100分这位小妹你好啊你的问题出在下面：验证有效性的SQL文出错了<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>  解决方案1
去掉这行解决方法2
请写一句正确的sql文

Answer 2

非常郁闷，我的问题还没有解决，下面是新的错误提示
10:06:41,750 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
10:06:41,765 ERROR [JDBCExceptionReporter] Cannot create PoolableConnectionFactory (Network error IOException: Connection timed out: connect)
10:06:41,765 WARN  [SettingsFactory] Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Network error IOException: Connection timed out: connect)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at org.springframework.orm.hibernate.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:76)
at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:73)
at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1132)
at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:766)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:543)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:477)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1003)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:348)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:269)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:317)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:80)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:65)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:56)
at com.prg.safety.model.basic.share.util.SpringUtil.getInstance(SpringUtil.java:15)
at com.prg.safety.control.basic.init.action.InitAction.<init>(InitAction.java:44)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at java.lang.Class.newInstance0(Class.java:308)
at java.lang.Class.newInstance(Class.java:261)
at org.apache.struts.util.RequestUtils.applicationInstance(RequestUtils.java:145)
at org.apache.struts.action.RequestProcessor.processActionCreate(RequestProcessor.java:282)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:220)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at com.prg.safety.model.basic.share.filter.EncodingFilter.doFilter(EncodingFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:158)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)

Answer 3

Caused by: java.sql.SQLException: Network error IOException: Connection timed out: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:371)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:188)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
... 65 more
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
at java.net.Socket.connect(Socket.java:452)
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:324)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:275)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:300)
... 71 more
10:07:11,562 WARN  [SQLErrorCodesFactory] Error while extracting database product name - falling back to empty error codes
org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Network error IOException: Connection timed out: connect)
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Network error IOException: Connection timed out: connect)
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Network error IOException: Connection timed out: connect)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:107)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:163)
at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:203)
at org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLErrorCodesFactory.java:185)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.setDataSource(SQLErrorCodeSQLExceptionTranslator.java:126)

Answer 4

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:324)
at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:856)
at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:734)
at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:886)
at org.springframework.beans.BeanWrapperImpl.setPropertyValues(BeanWrapperImpl.java:913)
at org.springframework.beans.BeanWrapperImpl.setPropertyValues(BeanWrapperImpl.java:902)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:967)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:768)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:330)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:275)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:317)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:80)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:65)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:56)
at com.prg.safety.model.basic.share.util.SpringUtil.getInstance(SpringUtil.java:15)
at com.prg.safety.control.basic.init.action.InitAction.<init>(InitAction.java:44)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at java.lang.Class.newInstance0(Class.java:308)
at java.lang.Class.newInstance(Class.java:261)
at org.apache.struts.util.RequestUtils.applicationInstance(RequestUtils.java:145)
at org.apache.struts.action.RequestProcessor.processActionCreate(RequestProcessor.java:282)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:220)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at com.prg.safety.model.basic.share.filter.EncodingFilter.doFilter(EncodingFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:158)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)

Answer 5

<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
替换成
<check-valid-connection-sql> select * from OG_USER</check-valid-connection-sql>

Answer 6

不大清楚
<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
为什么要有这一句呢？

Answer 7

<check-valid-connection-sql>要写一句用于测试数据库的sql
我不知道你 具体用个数据库

Answer 8

自己试了下select 1没有错你自己的jsp测试通过说明连接池的配置也没有问题看了下你的报错at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1132)估计你关于hibernate的配置文件有问题 导致初始化hibernate的时候出了错

Answer 9

<property name="hibernateProperties"> 
<props> 
<prop key="hibernate.dialect">net.sf.hibernate.dialect.SQLServerDialect</prop> 
<prop key="hibernate.show_sql">false</prop> 
</props> 
</property> 
你是指这段嘛？

Answer 10

用JDTS连接数据库有什么要求没有？

Answer 11

你的hibernate.cfg.xml是不是像下面一样类似的配置
<property name="connection.datasource">java:/jdbc/mssqlSafety</property>

Answer 12

对了我试过用JDBC也出现这个错误

Answer 13

<property name="connection.datasource">java:/jdbc/mssqlSafety</property>
        <property name="dialect">net.sf.hibernate.dialect.SQLServerDialect</property>
        <property name="show_sql">false</property>还是不成啊
14:56:28,281 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
14:56:28,281 ERROR [JDBCExceptionReporter] Cannot create PoolableConnectionFactory (Network error IOException: Connection timed out: connect)
14:56:28,281 WARN  [SettingsFactory] Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Network error IOException: Connection timed out: connect)

Answer 14

你用的什么连接池啊？我hibernate里的"方言"是下面的
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
我的hibernate的版本是3.0，会不会是你的hibernate版本和别人的不一致！2.0和3.0在用的时候是用区别的！

Answer 15

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection)看样子是连接池的某个工厂类出问题。于是从WSAD换到了JB，又换了Tomcat，又换了JNDI，死活不行，总是报这个错。奇了怪了，昨天好好的呀。由于是第一次遇到这种异常的，没有办法，到网上搜索资料去。看了一哥们的Blog说是由于防火墙的问题，防火墙把端口屏蔽了，把对应的端口打开即可。“我们的服务器用防火墙了吗？我访问不了了！”－－我指着后面的服务器问旁边的一个哥们。这时坐在我后面的一兄弟突然站起来，说道：“你用这台机子呢？我，－－我把网线拔了插到我的笔记本上！！ ”  faint！这哥们出差一个月，今天刚回来。再看上面的提示：(Io 异常: The Network Adapter could not establi在网上帮你找的，看看！

Answer 16

还不行啊 找找看你的项目里有没有一个叫hibernate.properties的文件可能你们是通过这个文件来配置jndi源的

Answer 17

我刚才打了SQL SP4的补丁，可是还不成！

Answer 18

我只找到这个.myhibernatedata
#
#Tue Oct 18 14:12:58 CST 2005
config.mappings[11]=com/prg/safety/model/business/archives/impl/hibernate/FmArchive.hbm.xml
config.mappings[14]=com/prg/safety/model/business/research/impl/hibernate/LzQytzry.hbm.xml
config.mappings[17]=com/prg/safety/model/basic/menu/impl/hibernate/po/menu.hbm.xml
config.password=guoyin
addLibs2Classpath=false
config.username=sa
config.dialect=Microsoft SQL Server
config.useDriver=false
config.mappings[20]=com/prg/safety/model/basic/userRole/impl/hibernate/OgRole.hbm.xml
config.name=jdbc/safety_lz
config.keyGenerator=native
config.mappings[1]=com/prg/safety/model/business/portal/cms/impl/hibernate/CmsInformation.hbm.xml
config.mappings[4]=com/prg/safety/model/business/research/impl/hibernate/LzQu.hbm.xml
config.mappings[7]=com/prg/safety/model/business/law/impl/hibernate/LmLawType.hbm.xml
config.mappings[10]=com/prg/safety/model/basic/userRole/impl/hibernate/OgRoleMenu.hbm.xml
config.configFilepath=/safety/WEB-INF/src
config.mappings[13]=com/prg/safety/model/basic/mail/impl/hibernate/po/mail.hbm.xml
config.mappings[16]=com/prg/safety/model/business/archives/impl/hibernate/FmFolder.hbm.xml
addLibs2Project=false
config.mappings[19]=com/prg/safety/model/business/research/impl/hibernate/LzQyzs.hbm.xml
createConfigFile=true
config.mappings[0]=com/prg/safety/model/basic/userGroup/impl/hibernate/OgGroup.hbm.xml
libInstallFolder=
config.mappings[3]=com/prg/safety/model/basic/workFlow/impl/prg/WfAuditIdea.hbm.xml
config.mappings[6]=com/prg/safety/model/business/portal/cms/impl/hibernate/CmsSubject.hbm.xml
config.basePersistenceClass=
config.mappings[9]=com/prg/safety/model/business/research/impl/hibernate/LzQyjbxx.hbm.xml
config.mappings[12]=com/prg/safety/model/business/law/impl/hibernate/LmLawInfo.hbm.xml
config.mappings[15]=com/prg/safety/model/basic/skin/impl/hibernate/SysSkin.hbm.xml
config.url=jdbc/safety
config.mappings[18]=com/prg/safety/model/business/requestLeaver/impl/RequestLeaver.hbm.xml
config.className=org.apache.commons.dbcp.BasicDataSourceFactory
config.copyJarFiles=false
config.configFilename=hibernate.cfg.xml
config.mappings[21]=com/prg/safety/model/business/research/impl/hibernate/LzDwxx.hbm.xml
config.mappings[2]=com/prg/safety/model/business/research/impl/hibernate/LzSccs.hbm.xml
config.mappings[5]=com/prg/safety/model/basic/userGroup/impl/hibernate/OgUser.hbm.xml
configFile=
config.mappings[8]=com/prg/safety/model/basic/uploadFile/impl/hibernate/po/file.hbm.xml

Answer 19

16:16:15,984 INFO  [Environment] hibernate.properties not found

Answer 20

理沙姐姐 再从vss再取一遍source吧 说不定会有奇迹发生

Answer 21

挖~! 好长好长的Exception......

Answer 22

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Network error IOException: Connection timed out: connect)如果不是数据库的url写错了，就是 数据库服务器不可访问。

Answer 23

ldianfeng(教授) 
我用ecplise的ecplise database exploer工具连数据库是没有问题的！

Answer 24

<connection-url>jdbc:jtds:sqlserver://localhost:1433/safety_lz;tds=8.0;lastupdatecount=true</connection-url>
分号要转换

Answer 25

楼主，你看看有没有JDBC驱动。

Answer 26

anchor1(聪头):分号转换？转换成什么？
sg552(:)) 我用的是JTDS驱动啊

Answer 27

sg552(:)) 我的library里面没有关于JDBS的驱动，不过有MSSQL的

Answer 28

<connection-url>jdbc:jtds:sqlserver://localhost:1433/safety_lz;tds=8.0;lastupdatecount=true</connection-url>
改为
<connection-url>jdbc:jtds:sqlserver://localhost:1433/safety_lz&amp;tds=8.0&amp;lastupdatecount=true</connection-url>