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

richardzhang

代码如下：
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)
        at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1069)
        at oracle.jdbc.driver.T4C8TTIpro.receive(T4C8TTIpro.java:130)
        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:866)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:267)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at com.test.a.main(a.java:13)
请指教，谢谢！

[ 本帖最后由 richardzhang 于 2008-4-24 16:50 编辑 ]

richardzhang

我把tnsnames.ora和listener.ora中的localhost改为本机的ip地址，现在报出新的错误：
java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
        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:254)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at com.test.a.main(a.java:13)

richardzhang

找到错误了，应改为：
Connection conn = DriverManager.getConnection("jdbcracle:thin192.168.1.7:1521rcl","SYSTEM","123456";
不能写localhost，可能因为我装了虚拟机，有多个虚拟网卡的缘故。另外应写“orcl”,即数据库的sid,而不是sid_name

Chinese_Dragon

强！