Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

User can create global context variables in context of database. [CORE2048] #2484

Open
firebird-automations opened this issue Aug 22, 2008 · 3 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Doru Constantin (doru_constantin)

Duplicates CORE1863

Extend Generic user and system context variable(s) to create global variables in context of curent database. The server should release this variable when user who create it is disconnected, when the database is dettached form server, when time is out (additional parameter), or when is released by the user who create it. It is like a database mutex.

@firebird-automations
Copy link
Collaborator Author

Commented by: Ain Valtin (ain)

Kind of similar request:
CORE1863

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

1 - Session variables are already released when the current user session is disconnected! What else do you need for the User variables?

2 - As Ain has already outlined, System/namespace variables is already noted as a Feature Request.

3 - There is already a Feature Request to support the scheduled execution of SPs. So, by leveraging this feature, you would be able to create a procedure to release/reset the system variable based on a "timeout".

4 - Your description of a "database mutex" makes me think that you are trying to have the database perform network locking. This is not what a SQL database is for. There are a number of tools (we have written our own) which can integrate locking into your application.

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

Link: This issue duplicates CORE1863 [ CORE1863 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant