Is there any way to keep Oracle SQL Developer from closing my DB connections, or to increase the timeout? Sometimes during a long-running query SQL Dev will just close the connection, leaving my query running on the server but me with no results. If I RDP into the server and run SQL Dev locally it never seems to have this problem.
Oracle – How to keep Oracle SQL Developer from closing the DB connection
oracleoracle-sqldeveloperoracle10g
Related Topic
- Oracle SQL Developer – Query results window with grid missing
- C# – Force closing an oracle connection in C#
- Oracle – How to generate an entity-relationship (ER) diagram using Oracle SQL Developer
- Oracle – How to set a custom date time format in Oracle SQL Developer
- Php – Is it preferred to assign POST variable to an actual variable
- Python – Pandas can’t read hdf5 file created with h5py
Best Answer
Answer
It's most likely a firewall between SQL Developer and the database that breaks things. You can solve that from SQL Developer using the SQL Developer Keepalive plugin.
You can also fix this from the Database Server by using the answers by Thomas and David Mann.
Original answer
I don't have the answer for this, but I'm experiencing the same problem.
The firewall between my SQL Developer and the database automaticly closes "inactive" sessions. A long running query is according to the firewall an inactive session, so he closes it. I've not, yet, found how to make SQL Developer send packets over a connection with a long running query, so that the firewall doesn't close the connection. And I don't know if this is possible at all.
So I don't think it is a SQL Developer problem, but a firewall issue.
-- UPDATE
There is an extension for SQL Developer that allows you to keep the connections active: http://sites.google.com/site/keepaliveext/
It's not totally finished yet (for example the notification you get states the same timeout no matter what timeout you have specified) but it does the trick. I've not, yet, tested it against the latest SQL Developer pre-release, but it worked with SQL Developer 2.2.x
-- UPDATE
For SQL Developer 4+ you can use: http://scristalli.github.io/SQL-Developer-4-keepalive/