| query about jdbc connectivity to oracle8i [message #366671] |
Sat, 02 September 2000 04:29  |
subhasish
Messages: 33
Registered: May 2000
|
Member |
|
|
the following code for jdbc connectivity through thin driver works fine when database is oracle7.3 or 8.0, but it does not work with oracle8i( version 8.1.5.0). I have even copied classes12_01.zip file in /jdk1.2/lib. Please help me . Thanks in advance.
following error is reported:::
Exception in thread "main" java.sql.SQLException: Io exception: The Network Adap
ter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:210)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
va:251)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:224)
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(DriverManager.java:137)
at dbAccess.main(Compiled Code)
the code is
import java.sql.*;
import java.math.*;
class dbAccess {
public static void main (String args [[]]) throws SQLException
{
DriverManager.registerDriver (new
oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@172.31.61.2:1526:test", "tech",
"tech");
// @machineName:port:SID, userid,
password
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select BANNER from
SYS.V_$VERSION");
while (rset.next())
System.out.println (rset.getString(1)); // Print col 1
stmt.close();
}
}
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
