Discussion:
[JIRA] Created: (MYO-89) Add simple escape syntax to support switching SQL Router qos during a session
Robert Hodges (JIRA)
2009-05-12 21:02:09 UTC
Permalink
Add simple escape syntax to support switching SQL Router qos during a session
-----------------------------------------------------------------------------

Key: MYO-89
URL: https://forge.continuent.org/jira/browse/MYO-89
Project: Myosotis
Type: New Feature

Versions: 0.6.5
Environment: All
Reporter: Robert Hodges
Assigned to: Gilles Rayrat
Fix For: 0.6.6


Add a simple escape command for the Tungsten Connector that allows users to switch SQL Router connections to a different QOS (quality of service) during a session. This would work by implementing a simple command syntax like the following:

/* TUNGSTEN: qos=RW_STRICT */

If the current SQL Router connection already has this QOS, nothing would happen. If the QOS of the current connection is different, the connector would switch to a new connection with the correct QOS.

The syntax should not conflict with SQL syntax in anyway. In the foregoing example, the command is embedded in a comment.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Gilles Rayrat (JIRA)
2009-06-15 08:42:47 UTC
Permalink
[ https://forge.continuent.org/jira/browse/MYO-89?page=all ]

Gilles Rayrat closed MYO-89:
----------------------------

Resolution: Fixed

FIxed in svn
Post by Robert Hodges (JIRA)
Add simple escape syntax to support switching SQL Router qos during a session
-----------------------------------------------------------------------------
Key: MYO-89
URL: https://forge.continuent.org/jira/browse/MYO-89
Project: Tungsten Connector
Type: New Feature
Versions: 0.6.5
Environment: All
Reporter: Robert Hodges
Assignee: Gilles Rayrat
Fix For: 0.6.6
/* TUNGSTEN: qos=RW_STRICT */
If the current SQL Router connection already has this QOS, nothing would happen. If the QOS of the current connection is different, the connector would switch to a new connection with the correct QOS.
The syntax should not conflict with SQL syntax in anyway. In the foregoing example, the command is embedded in a comment.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Gilles Rayrat (JIRA)
2009-06-15 08:49:46 UTC
Permalink
[ https://forge.continuent.org/jira/browse/MYO-89?page=all ]

Gilles Rayrat reopened MYO-89:
------------------------------


Postgres implementation is missing
Post by Robert Hodges (JIRA)
Add simple escape syntax to support switching SQL Router qos during a session
-----------------------------------------------------------------------------
Key: MYO-89
URL: https://forge.continuent.org/jira/browse/MYO-89
Project: Tungsten Connector
Type: New Feature
Versions: 0.6.5
Environment: All
Reporter: Robert Hodges
Assignee: Gilles Rayrat
Fix For: 0.6.6
/* TUNGSTEN: qos=RW_STRICT */
If the current SQL Router connection already has this QOS, nothing would happen. If the QOS of the current connection is different, the connector would switch to a new connection with the correct QOS.
The syntax should not conflict with SQL syntax in anyway. In the foregoing example, the command is embedded in a comment.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Gilles Rayrat (JIRA)
2009-08-20 10:13:46 UTC
Permalink
[ https://forge.continuent.org/jira/browse/MYO-89?page=comments#action_15723 ]

Gilles Rayrat commented on MYO-89:
----------------------------------

TODO: decide if this code should be removed or not, since MYO-103 offers a better alternative for it
Post by Robert Hodges (JIRA)
Add simple escape syntax to support switching SQL Router qos during a session
-----------------------------------------------------------------------------
Key: MYO-89
URL: https://forge.continuent.org/jira/browse/MYO-89
Project: Tungsten Connector
Type: New Feature
Versions: 0.6.5
Environment: All
Reporter: Robert Hodges
Assignee: Gilles Rayrat
Fix For: 0.6.8
/* TUNGSTEN: qos=RW_STRICT */
If the current SQL Router connection already has this QOS, nothing would happen. If the QOS of the current connection is different, the connector would switch to a new connection with the correct QOS.
The syntax should not conflict with SQL syntax in anyway. In the foregoing example, the command is embedded in a comment.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Gilles Rayrat (JIRA)
2010-02-08 18:42:46 UTC
Permalink
[ https://forge.continuent.org/jira/browse/MYO-89?page=all ]

Gilles Rayrat closed MYO-89:
----------------------------

Resolution: Fixed

Code transferred to ProtocolHandler superclass, so feature works for PostgreSQL as well
Post by Robert Hodges (JIRA)
Add simple escape syntax to support switching SQL Router qos during a session
-----------------------------------------------------------------------------
Key: MYO-89
URL: https://forge.continuent.org/jira/browse/MYO-89
Project: Tungsten Connector
Type: New Feature
Versions: 0.6.5
Environment: All
Reporter: Robert Hodges
Assignee: Gilles Rayrat
Fix For: 0.6.8
/* TUNGSTEN: qos=RW_STRICT */
If the current SQL Router connection already has this QOS, nothing would happen. If the QOS of the current connection is different, the connector would switch to a new connection with the correct QOS.
The syntax should not conflict with SQL syntax in anyway. In the foregoing example, the command is embedded in a comment.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Loading...