OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Network issue (Oracle 11gR1, Windows server 2003, Windows XP client)

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

Network issue [message #579599]

Wed, 13 March 2013 10:02

: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

Report message to a moderator

Re: Network issue [message #579601 is a reply to message #579599]

Wed, 13 March 2013 10:12

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you have no connection to the DB how can you access the data?

Regards
Michel

Report message to a moderator

Re: Network issue [message #579700 is a reply to message #579601]

Thu, 14 March 2013 02:15

: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.

Report message to a moderator

Re: Network issue [message #579704 is a reply to message #579700]

Thu, 14 March 2013 02:32

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

:aleksa:
Messages: 3
Registered: March 2013

Junior Member

Thank you Michel,

well, that I was afraid of.

Thank you, again.

Alex

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 22:23:13 CST 2024