急急急!!!连接数据库的问题
本人配置jb7+weblogic7+oracle8i 在jb7下写了一个连接数据库的小程序
package myproject1;
import java.sql.*;
public class MakingTheConnection {
public static void main(String[] args) {
try{
Class.forName( "oracle.jdbc.driver.OracleDriver" );
String sourceurl="jdbc:oracle:thin:@server:1521:databasename";
String user="xuguangyu";
String password="wdjjsqyl";
Connection databaseConnection=DriverManager.getConnection(sourceurl,user,password);
System.out.println("Connection established successfully!!!");
databaseConnection.close();
}
catch(ClassNotFoundException cnfe){
System.err.println(cnfe);
}
catch(SQLException sqle){
System.err.println(sqle);
}
}
}
我的ip是自动获取的,run后错误是这样的
D:\bea\jdk131_03\bin\javaw -classpath "D:\javaproject\jbproject\classes;D:\bea\weblogic700\server\lib\weblogic.jar;D:\bea\jdk131_03\jre\lib\i18n.jar;D:\bea\jdk131_03\jre\lib\jaws.jar;D:\bea\jdk131_03\jre\lib\rt.jar;D:\bea\jdk131_03\jre\lib\sunrsasign.jar;D:\bea\jdk131_03\lib\dt.jar;D:\bea\jdk131_03\lib\htmlconverter.jar;D:\bea\jdk131_03\lib\tools.jar" myproject1.MakingTheConnection
java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150999297)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
当我设置ip后错误变成:
D:\bea\jdk131_03\bin\javaw -classpath "D:\javaproject\jbproject\classes;D:\bea\weblogic700\server\lib\weblogic.jar;D:\bea\jdk131_03\jre\lib\i18n.jar;D:\bea\jdk131_03\jre\lib\jaws.jar;D:\bea\jdk131_03\jre\lib\rt.jar;D:\bea\jdk131_03\jre\lib\sunrsasign.jar;D:\bea\jdk131_03\lib\dt.jar;D:\bea\jdk131_03\lib\htmlconverter.jar;D:\bea\jdk131_03\lib\tools.jar" myproject1.MakingTheConnection
java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150999297)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))