View original (French)

Connection loss issue in sqldeveloper

Solved
ptisephy Posted messages 78 Status Member -  
ptisephy Posted messages 78 Status Member -
Hello,

this afternoon I noticed that I always have to reconnect to the database, because every time I run my queries it says "connection interrupted", I have to reconnect in sqldeveloper.

Is there a way to keep the connection during lunch, because generally I'm away for 45 minutes to 1.5 hours and just that, is there no way to keep my connection active?

Thank you

Configuration: Windows / Firefox 58.0

1 answer

Answer 1 / 1
baladur13 Posted messages 47302 Registration date   Status Moderator Last intervention   14 384
 
Hello
Since you mentioned in an alert that you solved the problem by yourself, it would be nice of you to share the solution with us.
This could, who knows, help other users facing this type of issue.
Thank you in advance for them.

-- 
 Very difficult to catch a black cat in a dark room.
                              Especially when it's not there...
0
ptisephy Posted messages 78 Status Member
 
Of course, actually, I didn't do anything special lol since it doesn't come from the idl_time which is set to unlimited nor from the firewall, it depends on higher-ups (those who manage the servers)
From what I've seen online, there are several types of solutions:
- set the idl_time to unlimited if it isn't already,
- check if it’s not the firewall that cuts the connection after a certain time (look in the firewalls)
- check if it doesn’t come from higher-ups (which is my case)
0