关于在JBuilder6.0中调用Oracle8i数据库的问题,实在伤脑筋!
我使用的数据库服务器在局域网中的IP地址是192.168.0.4
我调用数据库的步骤如下:
1.在configure libraries中添加ORACLE的驱动classes12.zip
2.在project properties中的required library里添加上面的驱动
3.在Enterprise Setup中的数据库驱动程序里添加上面的驱动
4.重新启动JBuider
5.在CLASSPATH上添加ORACLE安装路径(D:\Oracle\Ora81\jdbc\lib.classes12.zip)
6.在database pilot中URL为jdbc:oracle:thin:@192.168.0.4:1521:ORCL
DRIVER为oracle.jdbc.driver.OracleDriver
可是当我输入用户名和密码时出现“IO异常:connection refused”
详细的错误代码如下:
See com.borland.dx.dataset.DataSetException error code: BASE+66
com.borland.dx.dataset.DataSetException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135290880)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at com.borland.dx.dataset.DataSetException.a(Unknown Source)
at com.borland.dx.dataset.DataSetException.throwException(Unknown Source)
at com.borland.dx.dataset.DataSetException.SQLException(Unknown Source)
at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)
at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source)
at com.borland.jdbcx.metadata.e.run(Unknown Source)
Chained exception:
java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135290880)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)
at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source)
at com.borland.jdbcx.metadata.e.run(Unknown Source)
希望能给予回答!