struts1.1.b3的数据库连接问题！！！十万火急！！！！！

[3thinking]

我按照struts的文档把数据源配成如下：
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="autoCommit" value="false"/>
<!-- ================= Oracle DataSource ====================== -->
<set-property property="description"
value="Oracle Data Source Configuration"/>
<set-property property="driverClassName"
value="oracle.jdbc.driver.OracleDriver"/>
<set-property property="password" value="manager"/>
<set-property property="url" value="jdbc:oracle:thin:@localhost:1521:oracledb"/>
<set-property property="user" value="system"/>
<set-property property="maxCount" value="100"/>
<set-property property="minCount" value="10"/>
<set-property property="maxActive" value="100"/>
<set-property property="maxWait" value="5000"/>
<set-property property="defaultAutoCommit" value="false" />
<set-property property="defaultReadOnly" value="false" />
</data-source>
</data-sources>
可，为什么在程序中调用的时候会报如下错误：
DBCP borrowObject failed: java.sql.SQLException: JZ006: 捕获到 IO 例外:java.net.
ConnectException: Connection refused: connect

高手们请多多赐教！！！！！（分不是问题）

[qizi168]

期待回答……

[jianten]

帮你up

[888888888888]

关注

[cultra]

up

[leelongchun]

给出我再JB8中用struts1。1连接sqlserver的例子，已经成功连接。我用ms jdbc
<data-sources>
<data-source>
<set-property value="com.microsoft.jdbc.sqlserver.SQLServerDriver" property="driverClass" />
<set-property value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Employees" property="url" />
<set-property value="5" property="maxCount" />
<set-property value="sa" property="user" />
<set-property value="sa" property="password" />
<set-property value="1" property="minCount" />
</data-source>
</data-sources>

相应的action代码：
protected String getUser(String username, String password) {
String user = null;
String copypassword = null;
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
ServletContext context = servlet.getServletContext();
DataSource dataSource = (DataSource)
context.getAttribute(Action.DATA_SOURCE_KEY);
try {
conn = dataSource.getConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sqlstring ="select * from employees where "
+ "username='" + username + "' "
+ "and password = '" + password + "'";
rs =stmt.executeQuery(sqlstring);
if ( rs.next() ) {
user = rs.getString("username");
copypassword=rs.getString("password");
// Iterate over the results
System.err.println("Username : "
+ user
+ " Password : " + copypassword);
}
else {
System.err.println("---->User not found<----");
}
}

catch (SQLException e) {
System.err.println(e.getMessage());
}
finally {
if (rs != null) {
try {
rs.close();
}
catch (SQLException sqle) {
System.err.println(sqle.getMessage());
}
rs = null;
}
if (stmt != null) {
try {
stmt.close();
}
catch (SQLException sqle) {
System.err.println(sqle.getMessage());
}
stmt = null;
}
if (conn != null) {
try {
conn.close();
}
catch (SQLException sqle) {
System.err.println(sqle.getMessage());
}
conn = null;
}
}
return user;
}

[AllError]

<data-sources>
<data-source>
<set-property property="autoCommit"
value="false"/>
<set-property property="description"
value="Example"/>
<set-property property="driverClass"
value="oracle.jdbc.driver.OracleDriver"/>
<set-property property="maxCount"
value="10"/>
<set-property property="minCount"
value="2"/>
<set-property property="password"
value="test"/>
<set-property property="url"
value="dbc:oracle:thin:@10.0.2.122:1521:truelx"/>
<set-property property="user"
value="test"/>
</data-source>
</data-sources>

[AllError]

上面的user 改为username

[httruly]

up

[ukyer]

only up

[warren04]

up