Subject | RE: [firebird-support] shutting down server while open connection |
---|---|
Author | Wilson, Fred |
Post date | 2003-11-13T17:54:35Z |
I understand that this is not an answer to your question, but your
description (below) brings a question.
Are you saying that you have an application, that can allow a transaction to
be "open" for extended periods of time, like, for instance, the user starts
the application (opens connection), goes to a form (starts a transaction),
goes to lunch, comes back 1 hour later, closes the form (ends transaction)
??
If so, then this is an extremely poor design, especially in a multi-user
environment.
Best regards,
Fred Wilson
SE, Böwe Bell & Howell
fred.wilson@... <mailto:fred.wilson@...>
-----Original Message-----
From: Daniel Aut [mailto:daniel.aut@...]
Sent: Thursday, November 13, 2003 10:32 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] shutting down server while open connection
Hi,
i'd like to know what happens if i shut down the server (a Win98 pc) while
there is an open connection, but this is not in transaction, i mean it was
commited before.
Will give more details:
i have an application, that connects to firebird (local server) when it
begins. Every time it opens a form, it begins transaction, and when it
closes a form, it commits transaction. When the application closes, it
closes the connection.
The users shut down windows, but not application, (there isn't forms opened,
therefore the transaction is closed, but not the connection).
Is there any problem with all that?
Thank you!
PD: Sorry about my poor english
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=12c15mcfq/M=258297.4155332.5363524.4049140/D=egroup
web/S=1705115386:HM/EXP=1068832150/A=1683962/R=0/*http://www.techsmith.com/r
dr/ban/syah/default.asp> click here
<http://us.adserver.yahoo.com/l?M=258297.4155332.5363524.4049140/D=egroupmai
l/S=:HM/A=1683962/rand=572378584>
To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
description (below) brings a question.
Are you saying that you have an application, that can allow a transaction to
be "open" for extended periods of time, like, for instance, the user starts
the application (opens connection), goes to a form (starts a transaction),
goes to lunch, comes back 1 hour later, closes the form (ends transaction)
??
If so, then this is an extremely poor design, especially in a multi-user
environment.
Best regards,
Fred Wilson
SE, Böwe Bell & Howell
fred.wilson@... <mailto:fred.wilson@...>
-----Original Message-----
From: Daniel Aut [mailto:daniel.aut@...]
Sent: Thursday, November 13, 2003 10:32 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] shutting down server while open connection
Hi,
i'd like to know what happens if i shut down the server (a Win98 pc) while
there is an open connection, but this is not in transaction, i mean it was
commited before.
Will give more details:
i have an application, that connects to firebird (local server) when it
begins. Every time it opens a form, it begins transaction, and when it
closes a form, it commits transaction. When the application closes, it
closes the connection.
The users shut down windows, but not application, (there isn't forms opened,
therefore the transaction is closed, but not the connection).
Is there any problem with all that?
Thank you!
PD: Sorry about my poor english
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=12c15mcfq/M=258297.4155332.5363524.4049140/D=egroup
web/S=1705115386:HM/EXP=1068832150/A=1683962/R=0/*http://www.techsmith.com/r
dr/ban/syah/default.asp> click here
<http://us.adserver.yahoo.com/l?M=258297.4155332.5363524.4049140/D=egroupmai
l/S=:HM/A=1683962/rand=572378584>
To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]