Oracle JDBC Problem

From:

"jctown@nb.sympatico.ca" <jctown@nb.sympatico.ca>

Newsgroups:

comp.lang.java.help

Date:

4 Sep 2006 07:20:04 -0700

Message-ID:

<1157379603.961404.319210@i3g2000cwc.googlegroups.com>

I have a Java program on a laptop which is trying to access an Oracle
XE Database on my desktop.

Here is the error I get...obviously there is something wrong with a
connection string or something but I don't know what it would be

Exception in thread "main" java.sql.SQLException: Io exception: 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:419)
    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 Oracle.OracleTest.main(OracleTest.java:12)

And here is my source

package Oracle;

import java.lang.*;
import java.util.*;
import java.sql.*;

class OracleTest {
  public static void main (String args []) throws SQLException
  {
        DriverManager.registerDriver (new
oracle.jdbc.driver.OracleDriver());

        Connection conn = DriverManager.getConnection
             ("jdbc:oracle:thin:@emily5:1521:XE", "xxxxxx", "######"");
                             // @machineName:port:SID, userid,
password

        Statement stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery("select * from books");
        while (rset.next())
        {
            int index = 1;
                while (index <= 7)
                {
                        System.out.print (rset.getString(index) + " ");
                    index++;
                }
                System.out.println ("");
        }
        stmt.close();

  }
}

The program compiles and I have the odbc jar on the class path.