This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 123497 - Cannot Connect to Oracle 10g
Summary: Cannot Connect to Oracle 10g
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: DB schema (show other bugs)
Version: 6.x
Hardware: Other Windows XP
: P3 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-12-05 17:37 UTC by tibipaun
Modified: 2007-12-06 07:07 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description tibipaun 2007-12-05 17:37:37 UTC
I am having a problem with netbeans 6.0 (latest version, even though the problem was encountered in 6.0 dev version).
When I try to connect the IDE to an Oracle 10g server, it gives me an error message like this :
"java.sql.SQLException: Exception d'E/S: The Network Adapter could not establish the connection"
I use ojdbc14 (which I have used to connect to the same database with nb 5.5.1) and exactly the same database url.
I looked in ide's logs and found this :
INFO [global]
java.sql.SQLException: Exception d'E/S: The Network Adapter could not establish the connection
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
	at org.netbeans.modules.db.explorer.DbDriverManager.getConnection(DbDriverManager.java:122)
[catch] at org.netbeans.modules.db.explorer.DatabaseConnection$2.run(DatabaseConnection.java:533)
	at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561)
	at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986)
INFO [org.netbeans.modules.db.explorer.dlg.AddDriverDialog]: Got an exception trying to load class
oracle.jdbc.connector.OracleConnectionManager during search for JDBC drivers in  driver jar(s):
java.lang.NoClassDefFoundError: javax/resource/spi/ConnectionManager.  Skipping this class...
INFO [org.netbeans.modules.db.explorer.dlg.AddDriverDialog]: Got an exception trying to load class
oracle.jdbc.connector.OracleConnectionRequestInfo during search for JDBC drivers in  driver jar(s):
java.lang.NoClassDefFoundError: javax/resource/spi/ConnectionRequestInfo.  Skipping this class...
INFO [org.netbeans.modules.db.explorer.dlg.AddDriverDialog]: Got an exception trying to load class
oracle.jdbc.connector.OracleLocalTransaction during search for JDBC drivers in  driver jar(s):
java.lang.NoClassDefFoundError: javax/resource/spi/LocalTransaction.  Skipping this class...
INFO [org.netbeans.modules.db.explorer.dlg.AddDriverDialog]: Got an exception trying to load class
oracle.jdbc.connector.OracleManagedConnection during search for JDBC drivers in  driver jar(s):
java.lang.NoClassDefFoundError: javax/resource/spi/ManagedConnection.  Skipping this class...
INFO [org.netbeans.modules.db.explorer.dlg.AddDriverDialog]: Got an exception trying to load class
oracle.jdbc.connector.OracleManagedConnectionMetaData during search for JDBC drivers in  driver jar(s):
java.lang.NoClassDefFoundError: javax/resource/spi/ManagedConnectionMetaData.  Skipping this class...
INFO [org.netbeans.modules.db.explorer.dlg.AddDriverDialog]: Got an exception trying to load class
oracle.jdbc.connector.OracleManagedConnectionFactory during search for JDBC drivers in  driver jar(s):
java.lang.NoClassDefFoundError: javax/resource/spi/ManagedConnectionFactory.  Skipping this class...
INFO [org.netbeans.modules.db.explorer.dlg.AddDriverDialog]: Got an exception trying to load class
oracle.jdbc.connector.OracleResourceAdapter during search for JDBC drivers in  driver jar(s):
java.lang.NoClassDefFoundError: javax/resource/spi/ResourceAdapter.  Skipping this class...

I added the jar javaee.jar (from GlassFish's installation directory) that contained the required javax.resource.*
classes but the problem persists (other error message, though):
INFO [global]
java.sql.SQLException: Exception d'E/S: The Network Adapter could not establish the connection
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
	at org.netbeans.modules.db.explorer.DbDriverManager.getConnection(DbDriverManager.java:122)
[catch] at org.netbeans.modules.db.explorer.DatabaseConnection$2.run(DatabaseConnection.java:533)
	at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561)
	at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986)
INFO [org.netbeans.modules.j2ee.deployment.impl.ServerInstance]: DebuggerInfo cannot be found for: BEA WebLogic Server 9
INFO [org.netbeans.modules.j2ee.deployment.impl.ServerInstance]: DebuggerInfo cannot be found for: Apache Tomcat 6.0.14
INFO [org.netbeans.modules.j2ee.deployment.impl.ServerInstance]: DebuggerInfo cannot be found for: Sun Java System
Application Server
INFO [org.netbeans.modules.j2ee.deployment.impl.ServerInstance]: DebuggerInfo cannot be found for: GlassFish V2
INFO [global]
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
	at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
	at org.netbeans.ProxyClassLoader.loadClass(ProxyClassLoader.java:231)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
	at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:169)
[catch] at org.netbeans.modules.db.explorer.DatabaseConnection$2.run(DatabaseConnection.java:530)
	at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561)
	at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986)
INFO [global]
java.sql.SQLException: Exception d'E/S: The Network Adapter could not establish the connection
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
	at org.netbeans.modules.db.explorer.DbDriverManager.getConnection(DbDriverManager.java:122)
[catch] at org.netbeans.modules.db.explorer.DatabaseConnection$2.run(DatabaseConnection.java:533)
	at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561)
	at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986)
GRAVE: Unable to access component BeanInfo
java.lang.ClassNotFoundException: com.sun.jsfcl.std.property.IntegerPropertyEditor
	at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
	at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:169)
Comment 1 David Vancouvering 2007-12-06 00:16:11 UTC
There is a known issue with proxies in NB 6 which prevents JDBC drivers from connecting.  Can you make sure your SOCKS
proxy is turned off?  To do this, go to Tools->Options, and then look at Proxy Settings.  If you have proxies configured
manually, choose More..., and then uncheck "use the same proxy for all protocols" and then clear out the SOCKS proxy entry.

If you are using System settings, make sure your operating system is not configured to use proxies (if I remember right,
this is done under TCP/IP settings for your network connection), or if it is, that it is not configured to use a SOCKS
proxy.

Let me know if that solves your problem.
Comment 2 tibipaun 2007-12-06 07:07:25 UTC
Hello
I have the proxy configured manually.
You are right, it is not a bug but a misconfiguration of the proxy.
After changing the proxy configuration - as you suggested - works perfectly.

Thank you very much