Home » RDBMS Server » Networking and Gateways » Network issue (Oracle 11gR1, Windows server 2003, Windows XP client)
Network issue [message #579599] Wed, 13 March 2013 10:02 Go to next message
:aleksa:
Messages: 3
Registered: March 2013
Junior Member
Dear all,
I have clients that work using ADSL service to connect to DB. Sometimes connection is dropped for short time (less than 1 minute). Is there any way for my clients to continue with work without logging in again?

Thanks in advance.

Aleksa
Re: Network issue [message #579601 is a reply to message #579599] Wed, 13 March 2013 10:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you have no connection to the DB how can you access the data?

Regards
Michel
Re: Network issue [message #579700 is a reply to message #579601] Thu, 14 March 2013 02:15 Go to previous messageGo to next message
:aleksa:
Messages: 3
Registered: March 2013
Junior Member
Hi Michel,
thank you for quick response. I will try to describe my problem little more. I have an old application (.net 2.0, windows forms, CS). My users work with application over shared ADSL line. Occasionally, ADSL line is disconnected (20 sec for example) and connected again (thanks to our ADSL operator). All users are disconnected and they need to close applications, start applications and log-in again. You can understand that this is annoying and reason to complain. I'm asking that if there is a solution to overcome this? Is there any oracle parameter that can be set to hold user sessions during disconnection time? This is not time-critical system and users can wait for connection to restore.

I hope you understand what I'm trying to say.

Thank you in advance,
Alex.
Re: Network issue [message #579704 is a reply to message #579700] Thu, 14 March 2013 02:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No there is no such thing otherwise it would be possible to hack your session.
But you can code in your application that if it detects a deconnection then it automatically and transparently reconnects to the database.

Regards
Michel

[Edit: typo]

[Updated on: Thu, 14 March 2013 03:16]

Report message to a moderator

Re: Network issue [message #579709 is a reply to message #579704] Thu, 14 March 2013 02:57 Go to previous message
:aleksa:
Messages: 3
Registered: March 2013
Junior Member
Thank you Michel,

well, that I was afraid of.

Thank you, again.

Alex
Previous Topic: SQL*Net not properly installed
Next Topic: Dedicated server connection
Goto Forum:
  


Current Time: Thu Mar 28 05:26:39 CDT 2024