急》》》》Struts数据源的问题

急》》》》Struts数据源的问题 [无满意答案结贴,结贴人:schuy]

schuy
紫枫
等级:
可用分等级：短工
总技术专家分：0
总技术专家分排名：311804
揭帖率：100.00%

发表于：2008-06-04 13:54:35 楼主

resin服务器启动的时候报的错误：

严重: Initializing application data source java:comp/localhost
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFact
ory (到主机的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused:
connect)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:855)
at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.
java:598)
at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionSe
rvlet.java:808)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:335)
at javax.servlet.GenericServlet.init(GenericServlet.java:82)
at com.caucho.server.http.Application.createServlet(Application.java:310
9)
at com.caucho.server.http.Application.loadServlet(Application.java:3060)

at com.caucho.server.http.Application.initServlets(Application.java:1921
)
at com.caucho.server.http.Application.init(Application.java:1847)
at com.caucho.server.http.VirtualHost.init(VirtualHost.java:728)
at com.caucho.server.http.ServletServer.initHosts(ServletServer.java:874
)
at com.caucho.server.http.ServletServer.initInternal(ServletServer.java:
719)
at com.caucho.server.http.ServletServer.init(ServletServer.java:530)
at com.caucho.server.http.ResinServer.init(ResinServer.java:393)
at com.caucho.server.http.ResinServer.main(ResinServer.java:1154)
at com.caucho.server.http.HttpServer.main(HttpServer.java:103)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 到主机的 TCP/IP 连
接失败。 java.net.ConnectException: Connection refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv
erConnectionFactory.java:37)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable
ConnectionFactory.java:290)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas
icDataSource.java:877)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:851)
... 15 more

struts.config的数据源配置：
<data-source key="java:comp/localhost" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<set-property property="url" value="jdbc:sqlserver://localhost:1433;DatabaseName=Company"/>
<set-property property="username" value="sa"/>
<set-property property="password" value="kaka"/>
<set-property property="maxActive" value="5"/>
<set-property property="maxIdle" value="3"/>
<set-property property="maxWait" value="100"/>
<set-property property="defaultAutoCommit" value="true"/>
<set-property property="defaultReadOnly" value="false"/>
</data-source>

请各位帮忙看看是什么错误呢？？设置SQLEXPRESS服务器: 的设置都按照楼主的样子设置了！

问题点数：20 回复次数：2 修改删除举报引用回复