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 121580 - Proxy settings: Connection to Oracle with Netbeans 6
Summary: Proxy settings: Connection to Oracle with Netbeans 6
Status: REOPENED
Alias: None
Product: platform
Classification: Unclassified
Component: -- Other -- (show other bugs)
Version: 6.x
Hardware: All Windows XP
: P3 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-11-09 14:21 UTC by gerhardf
Modified: 2016-05-13 02:31 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments
Error Message (960.05 KB, image/gif)
2007-11-12 08:01 UTC, gerhardf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description gerhardf 2007-11-09 14:21:31 UTC
I can't add a new Connection to an Oracle XE Database with Netbeans 6 Beta 2. (error Msg Cannot establish a connection
to...)
I use the same driver and Connection settings as in Netbeans 5.5, where all is O.K.

System is Win XP SP2 with jdk 1.6

Regards
Comment 1 David Vancouvering 2007-11-10 04:45:01 UTC
Can you provide a little more detail?  What happens, are there any error messages?  What version of the JDBC driver are
you using?  What version of NetBeans 6 (see the About box).  Thanks.
Comment 2 gerhardf 2007-11-12 07:58:36 UTC
Product Version: NetBeans IDE 6.0 Beta 2 (Build 200710212201)
Java: 1.6.0_02; Java HotSpot(TM) Client VM 1.6.0_02-b05
System: Windows XP version 5.1 running on x86; Cp1252; de_DE (nb)

I use the JDBC -Driver which is part of the installation of Oracle XE
My Connection-String is: jdbc:oracle:thin:@tdet2531.de.festo.net:1521:XE
Driver: oracle.jdbc.driver.OracleDriver

Comment 3 gerhardf 2007-11-12 08:01:31 UTC
Created attachment 52862 [details]
Error Message
Comment 4 David Vancouvering 2007-11-12 16:53:35 UTC
It says it is unable to establish a connection, so it looks like it is using the driver correctly, but it can't get
connected to the server.  Can you connect to the XE server outside of NetBeans, using the same connection parameters? 
Are you sure the server is running?
Comment 5 gerhardf 2007-11-13 08:30:54 UTC
I think i've found the problem. The database resides on another PC and I configured the proxy in the configuration 
settings in Netbeans. If i select no Proxy I'm able to connect to the DB. (it's not only a problem with oracle)

In my opinion, the proxy settings should only affect the start-page and the download of the plugins, not the connection 
to a database. Unfortunately adding the DB-hostname to the list of "No Proxy Hosts" doesn`t work.
Regards 
Gerhard
Comment 6 David Vancouvering 2007-11-13 22:58:58 UTC
Oh, yes, the proxy problem.  I saw another issue come by about this.  We should probably fix this, I'm leaving this
open, to be fixed in a future release.
Comment 7 Andrei Badea 2007-11-14 10:38:53 UTC
... but not by the db team probably.

Jirko, yet another proxy problem, it still seems to me something's not right.
Comment 8 el_diego 2007-11-21 11:00:25 UTC
I had this problem to in 6.0 RC1 with Oracle, didn't even think that the proxy would be involved when making the db 
connection. If I add my database host or a domain-name pattern to the No Proxy Host the connection works. Great!
Comment 9 hjalles 2007-12-07 14:06:00 UTC
Hello together,

i installed NB 6.0 production yesterday and imported a project from former 5.5.1.
Trying to connect to Oracle DB via jdbc:thin doesn't work as long as the proxy settings are marked as 'Manual Proxy 
Settings' with http proxy values set.
Changing it to 'Use System Proxy Settings' the DB connect works. Update center is still available.

HJ
Comment 10 Lukas Hasik 2008-04-10 21:24:13 UTC
moving opened issues from TM <= 6.1 to TM=Dev
Comment 11 volunteer 2008-08-27 10:15:49 UTC
Hi,

I'm having the same problem in NetBeans IDE 6.1 (Build 200804211638). After spending hours and hours on internet search
I finally found this solution/bug. 

For me it works when:

 - I disable the proxy setting
 - I add the database host to the non-proxy hosts list

As already mentioned it would be nice if the proxy setting would not affect the database connection or it should be
added as an option to the "New Database Connection" wizard.

Regards,
Sören
Comment 12 Jiri Rechtacek 2008-11-21 16:22:57 UTC
I guess it works for me in NB6.5
Comment 13 albertinix 2014-10-23 09:38:31 UTC
I realize this is an old issue, but... the problem persists, in Netbeans 7.3 and 8.0.1 (that I tested, probably in other 7.x versions, too).

I have a proxy that I set up manually. In the list of "No proxy hosts" I put a list of other servers (e.g. version control) which are well recognized and understood by Netbeans (version control works).

But - database connections with Oracle Thin Driver do not work. No matter if I put the database host in the "No Proxy hosts", the connection does not work.

Only if the proxy is disabled does it work.

P.S. one small caveat: if I disable the proxy, connect to the database and then enable the proxy - the connection continues to function. If I disconnect and try to reconnect - it won't work.
Comment 14 rym002 2016-05-13 02:31:21 UTC
Does anyone know what module handles this. I wouldnt mind looking @ the code but I am not sure what module to start with. I have been facing this issue for years and would like to get away from it.