Re: Oracle JDBC Problem
"jctown@nb.sympatico.ca" <jctown@nb.sympatico.ca> said:
I have a Java program on a laptop which is trying to access an Oracle
XE Database on my desktop.
....
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.OracleTest.main(OracleTest.java:12)
Ok, the error tells a number of things:
- you got the proper drivers loaded (Oracle JDBC, not ODBC)
- the database JDBC URL is at least correct enough that the
driver attempted to connect
- the connection attempt failed
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", "######"");
So, it fails here. Looking ad the JDBC URL, it seems correct, assuming that
"emily5" is the name (in TCP/IP DNS, not just an arbitary computer name)
of the desktop running the database. As someone else responded, try pinging
that name, to see if it responds.
Other things, are you running Oracle TNS Listener service on emily5?
Is the listener service listening on port 1521?
You could find out these with commands
lsnrctl status
netstat -a
on the database server machine.
int index = 1;
while (index <= 7)
{
System.out.print (rset.getString(index) + " ");
index++;
}
As an aside, this could be more naturally written as a for loop:
for (int index = 1; index <= 7; index++) {
System.out.print(rset.getString(index) + " ");
}
System.out.println ("");
}
stmt.close();
.... and in real programs, remember to also close the connection:
conn.close();
--
Wolf a.k.a. Juha Laiho Espoo, Finland
(GC 3.0) GIT d- s+: a C++ ULSH++++$ P++@ L+++ E- W+$@ N++ !K w !O !M V
PS(+) PE Y+ PGP(+) t- 5 !X R !tv b+ !DI D G e+ h---- r+++ y++++
"...cancel my subscription to the resurrection!" (Jim Morrison)