excepttion in thread "main" java.sql.SQLException: Io exception: The Network Adapter

[Ryan G Johnson]

know this has been posted repeatedly. However, I have tried all the generic solutions Mine is a little different.

1. I can connect with SQLPLUS to the database. I am on windows XP connecting to Oracle 10g on a Solaris box. So the listener is running.

2. Here is my tnsnames.ora entry which works with SQLPLUS:
I can tnsping this address

 
SID_NAME =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = IP_NUMBER)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = SID_NAME)
    )
  )
 
 

I am trying to run the following sample code:

 
/*
 * This sample shows how to list all the names from the EMP table
 *
 * It uses the JDBC THIN driver.  See the same program in the
 * oci8 samples directory to see how to use the other drivers.
 */
 
package basic;
 
// You need to import the java.sql package to use JDBC
import java.sql.*;
 
class Employee
{
  public static void main (String args [])
       throws SQLException
  {
    // Load the Oracle JDBC driver
    DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
 
    // Connect to the database
    // You must put a database name after the @ sign in the connection URL.
    // You can use either the fully specified SQL*net syntax or a short cut
    // syntax as <host>:<port>:<sid>.  The example uses the short cut syntax.
    String url = "jdbc :-o	 racle:thin:@IP_NAME:1521:SID_NAME";
    String userName = "USERNAME";
    String password = "PASSWORD";
 
 
 
 
 
    if (args.length > 0) url = args[0];
    if (args.length > 1) userName = args[1];
    if (args.length > 2) password = args[2];
 
    //Connection conn =
    //  DriverManager.getConnection (url, userName, password);
Connection conn =
    DriverManager.getConnection("jdbc :-o	 racle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=IP_NUMBER:1521)(PORT=1521)))(CONNECT_DATA=(SID=SID_NAME)(SERVER=DEDICATED)))", "USERNAME", "PASSWORD");
    // Create a Statement
    Statement stmt = conn.createStatement ();
 
    // Select the ENAME column from the EMP table
    ResultSet rset = stmt.executeQuery ("select object_name from user_objects");
 
    // Iterate through the result and print the employee names
    while (rset.next ())
      System.out.println (rset.getString (1));
  }
}
 

I also used the following IP

[Ryan G Johnson]

I also use the following:

Connection conn =
      DriverManager.getConnection (url, userName, password);
 

[David O'Meara]

Have you grabbed the latest driver from Oracle? Just to be sure, I'd also double check to make sure the orrect driver jar was being used.

[Ryan G Johnson]

i am using the same driver as other people i work with who can connect.

[Reid M. Pinchback]

Oracle service names and SIDs aren't the same thing. I wonder if the problem may be related to that? Your tnsnames entry describes the value as a service name, but in the oracle-style connection structure you say it is a SID. If you know the listener uses the same value for both SID and service name obviously it shouldn't matter, but if they differ, I suspect that is what you may be tripping over. You should only need to use the simpler form, the URL-based on, in any case. For 10g I'm pretty sure you specify the service name in the URL, not the SID, if you find the listener values differ.

[stu derby]

Originally posted by Reid M. Pinchback:
Oracle service names and SIDs aren't the same thing.

What Reid said...

If you're using a service name, the URL syntax changes; the port is seperated from the service name by a "/".

Try:

String url = "jdbc :-o	 racle:thin:@IP_NAME:1521/service_name";

See:
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#05_04