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
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.
Joined: Nov 22, 2000
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
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