高手帮忙看看,是哪里的问题
趣味编程 2005-07-03 09:28:49 //郁闷死我了,从昨天调到今天中午也没调好,高手帮帮忙啊~
//下边是代码
public class db {
Context ctx =null;
DataSource ds =null;
Connection conn =null;
Statement stmt =null;
ResultSet rs =null;
public db() {
try {
ctx = new javax.naming.InitialContext();
System.out.println ("--------db30----------");
if(ctx==null){
throw new Exception("ctx==null");
}
ds = (javax.sql.DataSource)ctx.lookup("java:comp/env/jdbc/lesson");
System.out.println ("--------db35----------");
if(ds==null){
throw new Exception("ds==null");
}
conn = ds.getConnection();
System.out.println ("--------db40----------");
if(conn==null){
throw new Exception("conn==null");
}
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
System.out.println ("--------db46----------");
}
catch (Exception ex) {
//System.err.println("db.executeQuery :"+ex.getMessage());
ex.printStackTrace();
}
}
//-----------------------------------------------------------------------------------
执行到conn = ds.getConnection();就出错,下边是错误信息:
--------db30----------
--------db35----------
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, cause:
java.sql.SQLException: Connection refused: connect
at net.sourceforge.jtds.jdbc.TdsUtil.getSQLException(TdsUtil.java:181)
at net.sourceforge.jtds.jdbc.TdsUtil.getSQLException(TdsUtil.java:160)
at net.sourceforge.jtds.jdbc.TdsConnection.<init>(TdsConnection.java:182)
at net.sourceforge.jtds.jdbc.TdsConnectionJDBC3.<init>(TdsConnectionJDBC3.java:53)
at net.sourceforge.jtds.jdbc.Driver.getConnection(Driver.java:102)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:85)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:82)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:838)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:821)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
------------------------------------------------------------------------------
下边是我 server.xml 的配置
<Resource name="jdbc/lesson" scope="Shareable" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/lesson">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<!-- DBCP database connection settings -->
<parameter>
<name>url</name>
<value>jdbc:jtds:sqlserver://localhost:1433/lesson</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>net.sourceforge.jtds.jdbc.Driver</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value>795486</value>
</parameter>
<!-- DBCP connection pooling options -->
<parameter>
<name>maxWait</name>
<value>3000</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>100</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
</ResourceParams>
//高手帮忙看看,是哪里的问题呢