远程访问数据库
这是我的连接程序:
import java.sql.*;
public class Employee
{
public static void main (String args [])
throws SQLException
{
try{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn =
DriverManager.getConnection ("jdbc:oracle:thin:@192.168.1.22:1521:sydb",
"scott", "tiger");
Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery ("select * from t_user");
while (rset.next ())
System.out.println (rset.getString (2));
}
catch (SQLException e)
{
System.out.println(e.getMessage());
System.out.println(e.getErrorCode());
e.printStackTrace();
}
}
}
如果IP是本机地址,程序没问题,但是远程的地址就出错:“网络不能建立连接”可是网落状况很好(ping).在win200和linux测试的结果都一样。
为什么?
还有当我把本地的地址的程序写到jsp中去时,浏览器报以下错误:
Compilation error occured:
Found 3 errors in JSP file:
/opt/JRun/servers/default/demo-app/jwjsp/systemManager/addrecord.jsp:108: Error: No match was found for method "registerDriver(oracle.jdbc.driver.OracleDriver)".
/opt/JRun/servers/default/demo-app/jwjsp/systemManager/addrecord.jsp:108: Error: Could not find package named:
/opt/JRun/servers/default/demo-app/jwjsp/systemManager/addrecord.jsp:108: Error: Type oracle/jdbc/driver/OracleDriver was not found.
很奇怪!
我的应用服务器是JRun3.1,是不是JRun3.1要做什么配置?