OraFAQ Forum: Client Tools » Sql developer not working constantly

Home » Other » Client Tools » Sql developer not working constantly (sql developer ,3.2.20.09 , Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sql developer not working constantly [message #594621]

Sat, 31 August 2013 03:19

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior 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

Littlefoot
Messages: 21782
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.

Report message to a moderator

Re: Sql developer not working constantly [message #594623 is a reply to message #594622]

Sat, 31 August 2013 03:55

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Hi Littlefoot,

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

Report message to a moderator

Re: Sql developer not working constantly [message #594624 is a reply to message #594623]

Sat, 31 August 2013 04:00

Littlefoot
Messages: 21782
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.

Report message to a moderator

Re: Sql developer not working constantly [message #594649 is a reply to message #594624]

Sat, 31 August 2013 23:55

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior 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

Report message to a moderator

Re: Sql developer not working constantly [message #594654 is a reply to message #594649]

Sun, 01 September 2013 01:05

Littlefoot
Messages: 21782
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.

Report message to a moderator

Re: Sql developer not working constantly [message #594658 is a reply to message #594654]

Sun, 01 September 2013 01:37

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior 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

Report message to a moderator

Previous Topic:	Sqlplus not found Message file sp1<lang>.msb not found
Next Topic:	view red cross

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 02:08:43 CDT 2023