Search code examples
jdbcoracle-sqldeveloper

Is there a solution to JDBC driver bug in "Out Of Band Breaks"?

There is a long standing issue with SQL Developer disconnecting when used over VPN and other less than perfect networks.

As per a member from SQL Developer Team, it's a known bug in JDBC driver, unable to cope with 'Out Of Band Breaks'. He also proposes setting AddVMOption -Doracle.net.disableOob=true as a workaround. See more at: OTN Discussion Forums: SQL Developer: Not able to view tables

I want to ask, if anyone is aware of this bug being solved, or have a better solution than proposed above?

Solution

  • setting java system property oracle.net.disableOob=true is not a bad solution, this is common misunderstanding. Oracle just fallbacks to polling mechanism, server process will permanently check if there is cancel message sent by client even when query is running. There is no more bug in JDBC driver (at least not in 11.2.0.3), the main reason why it does not work is the following. When connecting to oracle DB through VPN, there is for sure some Firewall. And most modern firewalls are clearing URG packets for many security reasons. They do not drop packets with URG flags, just clear those bits.

    Even in RFC there is written that URG packets are not correctly implemented on several platforms.

    There is a possibility to persuade security officer to allow URG flags, but will be hard work with them, I'm affraid.