File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Network Adapter Error WHY???? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Network Adapter Error WHY????" Watch "Network Adapter Error WHY????" New topic
Author

Network Adapter Error WHY????

Tualha Khan
Ranch Hand

Joined: Nov 22, 2000
Posts: 287
Dear All,
Hey,
I have Windows 98, JDK1.2.2, Oracle 8i Personal Edition (8.1.6) I am facing problem in using the thin drivers for oracle. I am using the following statement to connect to the database:
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection Con=DriverManager.getConnection("jdbc racle:thin:@localhost:1521:GMD","username","password");
My SID is GMD
and username and password are my respective username and password. The code compiles correctly, but when I execute the code, I get the following exception:
Exception in Connection to Database : java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

Why am I getting this exception?
Please Help!
Also, what is the difference between TYPE II and TYPE III jdbc drivers?
Thanks a lot.
Bye,
Tualha Khan

SCJP2, BEA WLS 6.0, DB2 UDB 7.1
angiejin
Greenhorn

Joined: Feb 28, 2001
Posts: 3
Check your Oracle server configuration, like its TNS name, Listener, etc. Try to connect to other existing Oracle server. The most possible reason is in your Oracle.

Tualha Khan
Ranch Hand

Joined: Nov 22, 2000
Posts: 287
When I try to run the 'Test Connection' in Net8 Configuration Screen, it says ORA-Some error number : No Listener.
How do configure a listener. Is the guide available on the oracle site as a documentation. If yes, Please provide with the URL.
Thanks a lot.
Bye,
Tualha Khan
ramatubati
Greenhorn

Joined: Aug 17, 2001
Posts: 1
hi all
i got the same problem, network adapter could not establish the connection while using thin drivers, but in my case it is working fine with other users. only it is not working when im using connection pool. my tnslistner.ora and listener.ora are absolutely fine. im just wondering how its working for one user of oracle and not working for other user. user name and password are exactly correct. what could be the problem? please help me out.
thank u
rama tubati


Rama Tubati
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Network Adapter Error WHY????