首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > JAVA > J2SE开发 >

请问sql server2000+tomcat5.0数据库连接池有关问题

2012-01-14 
请教sql server2000+tomcat5.0数据库连接池问题!在单位配置了一下sqlserver2000+tomcat5.0的数据库连接池,

请教sql server2000+tomcat5.0数据库连接池问题!
在单位配置了一下sql   server2000+tomcat5.0的数据库连接池,分成三步来做:
1、拷贝jtds-1.2.jar到tomcat的common/lib下面
2、配置tomcat中conf文件夹中server.xml文件
3、配置工程中web.xml文件
配置都没有问题,测试了一下,通过了。
晚上回家把程序拷贝到家里的机器上,也是按照上面三步来做的,并且保证了配置信息的正确性,然后测试,在ds.getConnection()的时候报错,ds为DataSource类。提示的错误如下:
org.apache.commons.dbcp.SQLNestedException:   Cannot   create   PoolableConnectionFactory   (Network   error   IOException:   No   route   to   host:   connect)
at   org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
at   org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at   com.nmefc.db.DbConnection.initnew(DbConnection.java:76)
at   com.nmefc.db.DbConnection. <init> (DbConnection.java:22)
at   com.nmefc.suanfa.monthrptDisplay.getTabStr(monthrptDisplay.java:16)
at   org.apache.jsp.jsp.monthrpt_jsp._jspService(monthrpt_jsp.java:157)
at   org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at   javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at   org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
at   org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at   org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at   javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
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.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)
Caused   by:   java.sql.SQLException:   Network   error   IOException:   No   route   to   host:   connect


at   net.sourceforge.jtds.jdbc.ConnectionJDBC2. <init> (ConnectionJDBC2.java:372)
at   net.sourceforge.jtds.jdbc.ConnectionJDBC3. <init> (ConnectionJDBC3.java:50)
at   net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
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)
...   35   more
Caused   by:   java.net.NoRouteToHostException:   No   route   to   host:   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:461)
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.createSocketForJDBC3(SharedSocket.java:289)
at   net.sourceforge.jtds.jdbc.SharedSocket. <init> (SharedSocket.java:250)
at   net.sourceforge.jtds.jdbc.ConnectionJDBC2. <init> (ConnectionJDBC2.java:297)
...   41   more
不知道什么原因,周一就要交活了,现在连接池配不好,影响后面的工程,恳请大家帮助,谢谢!!!!!


[解决办法]
试下用jdbc能不能获得连接?
[解决办法]
WEB。XML文件的链接池配置代码帖出来看看。。。
[解决办法]
web.xml文件的

<Context path> 路径错了吧.....

热点排行