strut 连接不到 SQL SERVER

Imnotsad

strut 连接不到 SQL SERVER

error message

1. 
   
2. java.net.UnknownHostException: localhost
   
3.         at java.net.InetAddress.getLocalHost(Unknown Source)
   
4.         at com.inet.tds.TdsDriver.run(Unknown Source)
   
5.         at java.lang.Thread.run(Unknown Source)
   
6. DBCP borrowObject failed: com.inet.tds.SQLException: java.net.UnknownHostException: yzme\yzme
   
7. org.apache.commons.dbcp.DbcpException: com.inet.tds.SQLException: java.net.UnknownHostException: localhost
   
8.         at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)
   
9.         at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184)
   
10.         at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
    
11.         at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117)
    
12.         at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
    
13.         at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)
    
14.         at org.apache.struts.util.GenericDataSource.getConnection(GenericDataSource.java:276)
    
15.         at tess.caa.caaCommAction.execute(caaCommAction.java:39)
    
16.         at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)
    
17.         at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
    
18.         at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
    
19.         at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
    
20.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
    
21.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    
22.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
    
23.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
    
24.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
    
25.         at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
    
26.         at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
    
27.         at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
    
28.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
29.         at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
    
30.         at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
    
31.         at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
    
32.         at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
    
33.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
    
34.         at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
    
35.         at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
    
36.         at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
    
37.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
    
38.         at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
    
39.         at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
    
40.         at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
    
41.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
    
42.         at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
    
43.         at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
    
44.         at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
    
45.         at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
    
46.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
    
47.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
    
48.         at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
    
49.         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
    
50.         at java.lang.Thread.run(Unknown Source)
    
51. Caused by: com.inet.tds.SQLException: java.net.UnknownHostException: localhost
    
52.         at com.inet.tds.TdsDriver.a(Unknown Source)
    
53.         at com.inet.tds.TdsDriver.connect(Unknown Source)
    
54.         at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
    
55.         ... 42 more
    

复制代码

struts code

1. 
   
2. <?xml version="1.0" encoding="ISO-8859-1" ?>
   
3. 
   
4. <!DOCTYPE struts-config PUBLIC
   
5.           "-//Apache Software Foundation//DTD Struts Configuration 1.0//EN"
   
6.           "http://jakarta.apache.org/struts/dtds/struts-config_1_0.dtd">
   
7. 
   
8. <struts-config>
   
9. 
   
10. <data-sources>
    
11.     <data-source>
    
12.       <set-property property="autoCommit"
    
13.                      value="false"/>
    
14.       <set-property property="description"
    
15.                      value="SQLServer"/>
    
16.                      
    
17.           <set-property property="driverClass"
    
18.                      value="com.inet.tds.TdsDriver"/>                     
    
19.                             
    
20.       <set-property property="maxCount"
    
21.                      value="50"/>
    
22.       <set-property property="minCount"
    
23.                      value="10"/>
    
24.           <set-property property="url"
    
25.                      value="jdbc:inetdae7:localhost?database=TOSS"/>
    
26.       <set-property property="user"
    
27.                      value="sa"/>
    
28.       <set-property property="password"
    
29.                         value="password"/>
    
30.       <set-property property="username"
    
31.                             value="sa"/>
    
32.       <set-property property="password"
    
33.                                 value="password"/>
    
34.                     
    
35.        
    
36.     </data-source>
    
37. </data-sources>
    
38. 
    
39. <!--jdbc:inetdae7:127.0.0.1?database=TOSS-->
    
40. <!--microsoft:sqlserver:-->
    
41. <!-- ========== Form Bean Definitions =================================== -->
    
42. <form-beans>
    
43.         <form-bean name="caaCommForm" type="tess.caa.caaCommForm"/>
    
44. </form-beans>
    
45. 
    
46. <!-- ========== Global Forward Definitions ============================== -->
    
47. <global-forwards>
    
48. </global-forwards>
    
49. 
    
50. <!-- ========== Action Mapping Definitions ============================== -->
    
51. <action-mappings>
    
52. 
    
53.   <action path="/caaCommAction"
    
54.                   name="caaCommForm"
    
55.                   scope="request"
    
56.                   type="tess.caa.caaCommAction"
    
57.                   parameter="1">
    
58.         <!--Parameter 1:online   2:offline-->
    
59.           <!--1:File   2:database-->
    
60.         <set-property property="logMethod" value="1" />
    
61.         <set-property property="logFilePath" value="c:\BSILog.txt" />
    
62.   </action>
    
63. 
    
64.     <action path="/ENG/caaCommAction"
    
65.             name="caaCommForm"
    
66.             scope="request"
    
67.             type="tess.caa.caaCommAction"
    
68.             parameter="1">
    
69.                          <!--Parameter 1:online   2:offline-->
    
70.         <!--1:File   2:database-->
    
71.       <set-property property="logMethod" value="1" />
    
72.       <set-property property="logFilePath" value="c:\BSILog.txt" />
    
73.     </action>
    
74. 
    
75.     <action path="/FSR/ENG/caaCommAction"
    
76.             name="caaCommForm"
    
77.             scope="request"
    
78.             type="tess.caa.caaCommAction"
    
79.             parameter="1">
    
80.                          <!--Parameter 1:online   2:offline-->
    
81.         <!--1:File   2:database-->
    
82.       <set-property property="logMethod" value="1" />
    
83.       <set-property property="logFilePath" value="c:\BSILog.txt" />
    
84.     </action>
    
85.          
    
86.    
    
87. </action-mappings>
    
88. </struts-config>
    
89. 
    

复制代码

pls help

if i want to connect to microsoft access instead of sql server change to wat

1. 
   
2. <data-sources>
   
3.     <data-source>
   
4.       <set-property property="autoCommit"
   
5.                      value="false"/>
   
6.       <set-property property="description"
   
7.                      value="SQLServer"/>
   
8.                      
   
9.           <set-property property="driverClass"
   
10.                      value="com.inet.tds.TdsDriver"/>                     
    
11.                             
    
12.       <set-property property="maxCount"
    
13.                      value="50"/>
    
14.       <set-property property="minCount"
    
15.                      value="10"/>
    
16.           <set-property property="url"
    
17.                      value="jdbc:inetdae7:localhost?database=TOSS"/>
    
18.       <set-property property="user"
    
19.                      value="sa"/>
    
20.       <set-property property="password"
    
21.                         value="password"/>
    
22.       <set-property property="username"
    
23.                             value="sa"/>
    
24.       <set-property property="password"
    
25.                                 value="password"/>
    
26.                     
    
27.        
    
28.     </data-source>
    
29. </data-sources>
    
30. 
    

复制代码

Imnotsad

SQLException: Cannot load JDBC driver class 'null'

原帖由 Imnotsad 于 3-3-2006 09:24 PM 发表
SQLException: Cannot load JDBC driver class 'null'

JDBC driver 有在 classpath 里吗？

pcstory

Are your sure this is the correct database URL

jdbc:inetdae7:localhost?database=TOSS

i think this should be something like this

    jdbc:dbnet://wombat:356/fred

[ 本帖最后由 pcstory 于 4-3-2006 10:38 PM 编辑 ]