请教在jbuilder8中，通过jdbc连接远程oracle数据库求救！！！！！！！

[radish0111]

采用的是oracle thin连接方式，oracle的jdbc thin驱动已经加入到jbuilder中去了。然后我在Database polit中配置新的database url：jdbc:oracle:thin:@192.168.12.44:1521:ORCL

Driver是oracle.jdbc.driver.OracleDriver。
然后想连接到192.168.12.44上的oracle database。

但是发生错误为：
See com.borland.dx.dataset.DataSetException error code: BASE+66

com.borland.dx.dataset.DataSetException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(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.k.run(Unknown Source)

Chained exception:
java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)

at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)

at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)

at java.sql.DriverManager.getConnection(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)

at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source)

at com.borland.jdbcx.metadata.k.run(Unknown Source)

请大侠救命！！！！！！！！！！！！

[livesmile]

我也在找这方面的内容，现在还不知道怎么用jdbc连接orcle.需要一些什么软件和编写语句
友情up.

[skyxj]

Driver应该是oracle.jdbc.OracleDriver

[LGQDUCKY]

参考下：
http://www.oradb.net/setup/jspora_001.htm

[livesmile]

这个是odbc连接的，请问有没有jdbc连接的例子啊

[pegtop]

试着搜索一下以前的贴子，会找到，前一段时间有个已结的贴子好象也是连接的问题！

[livesmile]

下载不到jdbc的驱动程序，哪位可以提供一个？

[cjnstone]

在classpath里加上$ORACLE_HOME/jdbc/lib,或者将class12.zip ,nls_charset12.zip 拷到你的classpath，就可以了

import java.sql.*;

public class JdbcTest1 {
public static void main(String[] args) {
try{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.2.3:1521:test","test","test123123");

Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "select * from student";

ResultSet rs = stmt.executeQuery(sql);



while(rs.next())
{
int stuid = rs.getInt("stuid");
String name = rs.getString(2);
int lockerid = rs.getInt("lockerid");
System.out.println("id="+stuid+" name="+name+" lockerid="+lockerid);
}


rs.close();
stmt.close();
conn.close();


}catch(Exception ex)
{
ex.printStackTrace();
}
}

[livesmile]

随便找个安装oracle后的，jdbc文件里有个class12.zip ,nls_charset12.zip 改为.jar的格式。放到所建项目的defaultroot->WEB-INF->lib下就可以了