一天了,都没搞清楚问题在哪里,那位朋友给指点吧!
谢谢!报表任务服务因异常中断
java.sql.SQLException: Network error IOException: Connection timed out: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:385)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at cn.com.headsoft.PlanReportForms.PlanReportTaskService.init(PlanReportTaskService.java:118)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3917)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4201)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
at org.apache.catalina.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
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:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:364)
at java.net.Socket.connect(Socket.java:507)
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:585)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:304)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:255)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:310)
... 23 more
谢谢!报表任务服务因异常中断
java.sql.SQLException: Network error IOException: Connection timed out: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:385)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at cn.com.headsoft.PlanReportForms.PlanReportTaskService.init(PlanReportTaskService.java:118)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3917)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4201)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
at org.apache.catalina.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
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:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:364)
at java.net.Socket.connect(Socket.java:507)
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:585)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:304)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:255)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:310)
... 23 more
解决方案 »
- Struts2 spring hibernate参数传递问题
- 这样的代码是否安全
- 求相关于servlet的学习资料或视频教学之类的东西高份相送
- 有能力的来拿分(关于特殊字体在JSP的应用)
- 用servlet从数据库中提取了数据,怎样把提取的字段传给下一个jsp页面?谢谢各位大侠指点!
- myecplise 代码提交到svn时,不能写注释
- EditPlus的配置问题
- 刷新未完成的jsp页面,连接不释放并生成新连接的问题
- 谁有jsp聊天室?能给我一份或下载地址?谢谢了~
- session生命期问题,我在一个页面下有个sesion,即打开这个叶面时seesion有了生命为5秒,那么我(不断)打开本网站别的页面,该seesion是
- 如何遍历网络文件夹并取得文件名
- struts2页面的显示问题
这个提示对应的类是你自己写的吧?118行怎么写的啊?
......Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:364)
at java.net.Socket.connect(Socket.java:507)
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:585)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:304)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:255)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:310)
... 23 more
查找数据源开始
查找数据源完成
---> The PlugIn FileUploadPlugin is starting <---
---- = MaxFileSize
MaxFileSize = 1
---- = SaveFilePath
SaveFilePath = /upload/
---- = MinFileSize
MinFileSize = 0
---- = VirtualPath
VirtualPath = true
---- = TotalFilesSize
TotalFilesSize = 5
2009-5-6 10:50:10 org.apache.coyote.http11.Http11BaseProtocol start
信息: Starting Coyote HTTP/1.1 on http-8089
2009-5-6 10:50:11 org.apache.jk.common.ChannelSocket init
信息: JK: ajp13 listening on /0.0.0.0:8009
2009-5-6 10:50:11 org.apache.jk.server.JkMain start
信息: Jk running ID=0 time=0/90 config=null
2009-5-6 10:50:11 org.apache.catalina.storeconfig.StoreLoader load
信息: Find registry server-registry.xml at classpath resource
2009-5-6 10:50:11 org.apache.catalina.startup.Catalina start
信息: Server startup in 45686 ms
JZParam 警告:数据类型和对象不匹配 CO_ParamType_String 值=null
JZParam 警告:数据类型和对象不匹配 CO_ParamType_String 值=null
JZParam 警告:数据类型和对象不匹配 CO_ParamType_String 值=null
SELECT ITemID,DstrbtUnits,UseUnits,DstrbtSeq,Director,Iinancing,Clerk,Stuff,DstrbtPerson,Readme,Receipt,ReceiptTime,DstrbtTime,ExamineStatu,BDBH,statu FROM CD_StuffDistribute WHERE year(DstrbtTime)='2009' and month(DstrbtTime)='5' and DisType=0 ORDER BY DstrbtTime desc
JZParam 警告:数据类型和对象不匹配 CO_ParamType_String 值=null
SELECT ITemID,DstrbtUnits,UseUnits,DstrbtSeq,Director,Iinancing,Clerk,Stuff,DstrbtPerson,Readme,Receipt,ReceiptTime,DstrbtTime,ExamineStatu,BDBH,statu FROM CD_StuffDistribute WHERE year(DstrbtTime)='2009' and month(DstrbtTime)='4' and DisType=0 ORDER BY DstrbtTime desc
JZParam 警告:数据类型和对象不匹配 CO_ParamType_String 值=null
SELECT ItemID,PItemID,ZIndex,Path,Guid,ZType FROM COM_TreeView WHERE ZType=?
ItemID=137
PItemID=1
ZIndex=0
Path=\137
Guid={CFC0B99C-E7E7-4A2A-99F5-65159E52B338}
ZType=1020
SELECT a.ItemID as ItemID,max(a.PItemID) as PItemID,max(a.ZIndex) as ZIndex, max(a.Path) as Path,max(a.Guid) as Guid,max(a.ZType) as ZType, case when count(*)>1 then 1 else 0 end as ParentFlag FROM COM_TreeView a left join COM_TreeView b on b.PItemID=a.ItemID WHERE a.pItemID=? group by a.ItemID
ItemID=138
PItemID=137
ZIndex=0
Path=\137\138
Guid={BBE175BB-F604-4D36-B617-071CE5BE1F86}
.....
.....
今天在看配置文件时,发现:
在web.xml中也有段
<param-name>driverClassName</param-name>
<param-value>net.sourceforge.jtds.jdbc.Driver</param-value> <param-name>dbUrl</param-name>
<param-value>jdbc:jtds:sqlserver://192.168.64.6:1433/pms_bs_cd_px</param-value> <param-name>user</param-name>
<param-value>sa</param-value> <param-name>pwd</param-name>
<param-value>buzhidao</param-value>而在tomcat 下的server.xml中还有段
<Context path="/..." docBase="/..." debug="0" reloadable="true">
<Resource name="ProjectDataSource"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="sa"
password="buzhidao"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://localhost:1433/pms_bs_cd_px"/>
</Context>两个配置文件的url 不一致!下面(server.xml中)的是正确的。
但却报错了,因为项目启动时web.xml优先于server.xml执行
用的也就是web.xml中的是,driver,url,user,pwd.
而server.xml中的这些信息就成了多余的。
因此要解决问题有:
1)可以删除web.xml中的链接配置。
2)把web.xml中的链接配置正确,而server.xml中的链接配置可以删除,
也可留着,留着是多余的,不会再执行(因为web.xml已经帮你链接好了),因此也不会影响连。