I have an environment that permits me to use sqldeveloper on my laptop, to connect to a jump server over ssh, that connects to the database targets over SQLNET.
This is great, sqldeveloper allows me to use SSH port forwarding.
However, what I need the SSH tunnel to do is "stay alive". The networks to the jump service clearly have a strict/short TTL and drop the connection if I go away and get a cup of coffee.
What would be really cool is if SQL Developer was somehow able to send a background sql transaction (select user from dual;) every 'x' seconds or preferably, allow the SSH tunnel client to send null packets/TCP_Keepalives to keep the connection going.
Does anyone have a workaround?
I know there is something that could be adopted by creating a bespoke version of sqldeveloper with jdeveloper and https://github.com/scristalli/SQL-Developer-4-keepalive however, I would rather the product owners provide the solution. Call me old fashioned