Home » SQL & PL/SQL » Client Tools » Sql developer not working constantly (sql developer ,3.2.20.09 , Linux)
Sql developer not working constantly [message #594621] Sat, 31 August 2013 03:19 Go to next message
suhasdba
Messages: 68
Registered: April 2013
Location: INDIA
Member
Hi ,

sql developer tool which i am using to run query for every hour getting disconnected and to run a new query after an hour,
i need to make a new connection again.Could you tell me an alternate way that should not disconnect the session in sql developer.

Thanks

[Updated on: Sat, 31 August 2013 03:20]

Report message to a moderator

Re: Sql developer not working constantly [message #594622 is a reply to message #594621] Sat, 31 August 2013 03:29 Go to previous messageGo to next message
Littlefoot
Messages: 18833
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
See what's been said in How to prevent your SQL Developer sessions from being killed?. It also contains a link to MinChen Chai's Keep-Alive Extension.
Re: Sql developer not working constantly [message #594623 is a reply to message #594622] Sat, 31 August 2013 03:55 Go to previous messageGo to next message
suhasdba
Messages: 68
Registered: April 2013
Location: INDIA
Member
Hi Littlefoot,

Thanks for the link.But unable to download "extension to add KeepAlive functionality " link.getting pageout error.

Re: Sql developer not working constantly [message #594624 is a reply to message #594623] Sat, 31 August 2013 04:00 Go to previous messageGo to next message
Littlefoot
Messages: 18833
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which link (of the two I posted) did you follow?

I downloaded the extension successfully just a minute ago, so I guess it must be something on your side that's wrong.
Re: Sql developer not working constantly [message #594649 is a reply to message #594624] Sat, 31 August 2013 23:55 Go to previous messageGo to next message
suhasdba
Messages: 68
Registered: April 2013
Location: INDIA
Member
Littlefoot,

Quote:
Which link (of the two I posted) did you follow?

The one on the right hand side 'Keep-Alive Extension' . In that page, Below "oracle.sqldeveloper.keepalive.jar (6KB) /v1.1 (October 7, 2010) " there will be one button called download. When i click on that button, i get ' proxy server is refusing connections.

Pls tell me how to download that file ?

Thanks
Re: Sql developer not working constantly [message #594654 is a reply to message #594649] Sun, 01 September 2013 01:05 Go to previous messageGo to next message
Littlefoot
Messages: 18833
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I believe that you should talk to your system / network administrator who sets up proxy settings.
Re: Sql developer not working constantly [message #594658 is a reply to message #594654] Sun, 01 September 2013 01:37 Go to previous message
suhasdba
Messages: 68
Registered: April 2013
Location: INDIA
Member
Ok Littlefoot.i will do the same.

i get error something like this when i try to run sql query after an hour.(Till then session will be idle.)

IO Error: Connection reset by peer: socket write error
Previous Topic: Sqlplus not found Message file sp1<lang>.msb not found
Next Topic: view red cross
Goto Forum:
  


Current Time: Sun Apr 20 04:30:14 CDT 2014

Total time taken to generate the page: 0.04734 seconds