jdbc连接oracle 10g问题 新手 谢谢

来源:百度知道 编辑:UC知道 时间:2024/06/19 11:11:23
代码如下:
public class a
{

public static void main(String[] args) throws Exception
{
try{
Class.forName("oracle.jdbc.OracleDriver";
Connection conn = DriverManager.getConnection("jdbcracle:thinlocalhost:1521LSExtProc","SYSTEM","123456";
}
catch(Exception e)
{e.printStackTrace();}
}
}
其中PLSExtProc是listener.ora中查到的sid_name,使用sqlplus能登陆数据库
出现错误如下:
java.sql.SQLException: 无法从套接字读取更多的数据
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:207)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1117)

Class.forName("oracle.jdbc.OracleDriver";
Connection conn = DriverManager.getConnection("jdbcracle:thinlocalhost:1521LSExtProc","SYSTEM","123456";
}
这两句有问题,改成:
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:SextProc";
Connection conn=DriverManager.getconnection(url,"SYSTEM","123456");