You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "David Van Couvering (JIRA)" <de...@db.apache.org> on 2005/05/16 22:52:06 UTC

[jira] Created: (DERBY-293) Correlate client connection with embedded connection

Correlate client connection with embedded connection
----------------------------------------------------

         Key: DERBY-293
         URL: http://issues.apache.org/jira/browse/DERBY-293
     Project: Derby
        Type: Improvement
    Versions: 10.1.0.0    
 Environment: N/A
    Reporter: David Van Couvering
    Priority: Minor
     Fix For: 10.1.0.0


There should be a way for someone to correlate a given embedded connection with its matching network client connection, if such a client connection exists.  

See 

http://article.gmane.org/gmane.comp.apache.db.derby.devel/3748

and

http://article.gmane.org/gmane.comp.apache.db.derby.devel/3942

for some background info on how to get useful information out of the DRDA protocol
stream to accomplish this.

This could be done either by modifying the toString() method of an embedded
connection to show its associated network client connection information or (my
preference) include this information in the proposed Connection VTI (see DERBY-292).  I am worried that if we use toString() for this, the output will be overly long and complicated; also, over a period of time the same embedded connection may be associated with multiple client connections, resulting in a changing toString() value for the embedded connection.  This seems problematic if we are intending toString() to uniquely identify a connection for the lifetime of the connection -- this would be a good goal to have as it would enable us to do some useful debugging using the VTIs.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Updated: (DERBY-293) Correlate client connection with embedded connection

Posted by "Mike Matrigali (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-293?page=all ]

Mike Matrigali updated DERBY-293:
---------------------------------

    Component: JDBC

> Correlate client connection with embedded connection
> ----------------------------------------------------
>
>          Key: DERBY-293
>          URL: http://issues.apache.org/jira/browse/DERBY-293
>      Project: Derby
>         Type: Improvement
>   Components: Network Server
>     Versions: 10.1.1.0
>  Environment: N/A
>     Reporter: David Van Couvering
>     Priority: Minor
>      Fix For: 10.2.0.0

>
> There should be a way for someone to correlate a given embedded connection with its matching network client connection, if such a client connection exists.  
> See 
> http://article.gmane.org/gmane.comp.apache.db.derby.devel/3748
> and
> http://article.gmane.org/gmane.comp.apache.db.derby.devel/3942
> for some background info on how to get useful information out of the DRDA protocol
> stream to accomplish this.
> This could be done either by modifying the toString() method of an embedded
> connection to show its associated network client connection information or (my
> preference) include this information in the proposed Connection VTI (see DERBY-292).  I am worried that if we use toString() for this, the output will be overly long and complicated; also, over a period of time the same embedded connection may be associated with multiple client connections, resulting in a changing toString() value for the embedded connection.  This seems problematic if we are intending toString() to uniquely identify a connection for the lifetime of the connection -- this would be a good goal to have as it would enable us to do some useful debugging using the VTIs.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Commented: (DERBY-293) Correlate client connection with embedded connection

Posted by "David Van Couvering (JIRA)" <de...@db.apache.org>.
    [ http://issues.apache.org/jira/browse/DERBY-293?page=comments#action_12314329 ] 

David Van Couvering commented on DERBY-293:
-------------------------------------------

Derby log messages print out the SESSID, which now can be correlated with the embedded client connection toString value, and the DRDAID, which is the DRDA correlation token (CRRTKN) + a connection id.  

I would like to propose that this item can be resolved by having the client connection toString() include the CRRTKN in the same display format as the derbylog file.  This would allow a debugger to correlate the output from the error log with the specific client connection they want to trace.


> Correlate client connection with embedded connection
> ----------------------------------------------------
>
>          Key: DERBY-293
>          URL: http://issues.apache.org/jira/browse/DERBY-293
>      Project: Derby
>         Type: Improvement
>     Versions: 10.1.1.0
>  Environment: N/A
>     Reporter: David Van Couvering
>     Priority: Minor
>      Fix For: 10.2.0.0

>
> There should be a way for someone to correlate a given embedded connection with its matching network client connection, if such a client connection exists.  
> See 
> http://article.gmane.org/gmane.comp.apache.db.derby.devel/3748
> and
> http://article.gmane.org/gmane.comp.apache.db.derby.devel/3942
> for some background info on how to get useful information out of the DRDA protocol
> stream to accomplish this.
> This could be done either by modifying the toString() method of an embedded
> connection to show its associated network client connection information or (my
> preference) include this information in the proposed Connection VTI (see DERBY-292).  I am worried that if we use toString() for this, the output will be overly long and complicated; also, over a period of time the same embedded connection may be associated with multiple client connections, resulting in a changing toString() value for the embedded connection.  This seems problematic if we are intending toString() to uniquely identify a connection for the lifetime of the connection -- this would be a good goal to have as it would enable us to do some useful debugging using the VTIs.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Commented: (DERBY-293) Correlate client connection with embedded connection

Posted by "Kathey Marsden (JIRA)" <de...@db.apache.org>.
    [ http://issues.apache.org/jira/browse/DERBY-293?page=comments#action_12319439 ] 

Kathey Marsden commented on DERBY-293:
--------------------------------------

With David's change to embedded connection toString (DERBY-412), the Client connection   toString() method could print the same DRDAID.


> Correlate client connection with embedded connection
> ----------------------------------------------------
>
>          Key: DERBY-293
>          URL: http://issues.apache.org/jira/browse/DERBY-293
>      Project: Derby
>         Type: Improvement
>   Components: Network Server
>     Versions: 10.1.1.0
>  Environment: N/A
>     Reporter: David Van Couvering
>     Priority: Minor
>      Fix For: 10.2.0.0

>
> There should be a way for someone to correlate a given embedded connection with its matching network client connection, if such a client connection exists.  
> See 
> http://article.gmane.org/gmane.comp.apache.db.derby.devel/3748
> and
> http://article.gmane.org/gmane.comp.apache.db.derby.devel/3942
> for some background info on how to get useful information out of the DRDA protocol
> stream to accomplish this.
> This could be done either by modifying the toString() method of an embedded
> connection to show its associated network client connection information or (my
> preference) include this information in the proposed Connection VTI (see DERBY-292).  I am worried that if we use toString() for this, the output will be overly long and complicated; also, over a period of time the same embedded connection may be associated with multiple client connections, resulting in a changing toString() value for the embedded connection.  This seems problematic if we are intending toString() to uniquely identify a connection for the lifetime of the connection -- this would be a good goal to have as it would enable us to do some useful debugging using the VTIs.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Updated: (DERBY-293) Correlate client connection with embedded connection

Posted by "Samuel Andrew McIntyre (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-293?page=all ]

Samuel Andrew McIntyre updated DERBY-293:
-----------------------------------------

    Fix Version: 10.2.0.0
                     (was: 10.1.0.0)
    Description: 
There should be a way for someone to correlate a given embedded connection with its matching network client connection, if such a client connection exists.  

See 

http://article.gmane.org/gmane.comp.apache.db.derby.devel/3748

and

http://article.gmane.org/gmane.comp.apache.db.derby.devel/3942

for some background info on how to get useful information out of the DRDA protocol
stream to accomplish this.

This could be done either by modifying the toString() method of an embedded
connection to show its associated network client connection information or (my
preference) include this information in the proposed Connection VTI (see DERBY-292).  I am worried that if we use toString() for this, the output will be overly long and complicated; also, over a period of time the same embedded connection may be associated with multiple client connections, resulting in a changing toString() value for the embedded connection.  This seems problematic if we are intending toString() to uniquely identify a connection for the lifetime of the connection -- this would be a good goal to have as it would enable us to do some useful debugging using the VTIs.

  was:
There should be a way for someone to correlate a given embedded connection with its matching network client connection, if such a client connection exists.  

See 

http://article.gmane.org/gmane.comp.apache.db.derby.devel/3748

and

http://article.gmane.org/gmane.comp.apache.db.derby.devel/3942

for some background info on how to get useful information out of the DRDA protocol
stream to accomplish this.

This could be done either by modifying the toString() method of an embedded
connection to show its associated network client connection information or (my
preference) include this information in the proposed Connection VTI (see DERBY-292).  I am worried that if we use toString() for this, the output will be overly long and complicated; also, over a period of time the same embedded connection may be associated with multiple client connections, resulting in a changing toString() value for the embedded connection.  This seems problematic if we are intending toString() to uniquely identify a connection for the lifetime of the connection -- this would be a good goal to have as it would enable us to do some useful debugging using the VTIs.


> Correlate client connection with embedded connection
> ----------------------------------------------------
>
>          Key: DERBY-293
>          URL: http://issues.apache.org/jira/browse/DERBY-293
>      Project: Derby
>         Type: Improvement
>     Versions: 10.1.0.0
>  Environment: N/A
>     Reporter: David Van Couvering
>     Priority: Minor
>      Fix For: 10.2.0.0

>
> There should be a way for someone to correlate a given embedded connection with its matching network client connection, if such a client connection exists.  
> See 
> http://article.gmane.org/gmane.comp.apache.db.derby.devel/3748
> and
> http://article.gmane.org/gmane.comp.apache.db.derby.devel/3942
> for some background info on how to get useful information out of the DRDA protocol
> stream to accomplish this.
> This could be done either by modifying the toString() method of an embedded
> connection to show its associated network client connection information or (my
> preference) include this information in the proposed Connection VTI (see DERBY-292).  I am worried that if we use toString() for this, the output will be overly long and complicated; also, over a period of time the same embedded connection may be associated with multiple client connections, resulting in a changing toString() value for the embedded connection.  This seems problematic if we are intending toString() to uniquely identify a connection for the lifetime of the connection -- this would be a good goal to have as it would enable us to do some useful debugging using the VTIs.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Updated: (DERBY-293) Correlate client connection with embedded connection

Posted by "Kathey Marsden (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-293?page=all ]

Kathey Marsden updated DERBY-293:
---------------------------------

    Fix Version/s:     (was: 10.2.0.0)

removing from 10.2. see:
http://www.nabble.com/10.2-High-Value-Fix-Candidates-and-Fix-Version-Adjustments-tf2007999.html

> Correlate client connection with embedded connection
> ----------------------------------------------------
>
>                 Key: DERBY-293
>                 URL: http://issues.apache.org/jira/browse/DERBY-293
>             Project: Derby
>          Issue Type: Improvement
>          Components: Network Server
>    Affects Versions: 10.1.1.0
>         Environment: N/A
>            Reporter: David Van Couvering
>            Priority: Minor
>
> There should be a way for someone to correlate a given embedded connection with its matching network client connection, if such a client connection exists.  
> See 
> http://article.gmane.org/gmane.comp.apache.db.derby.devel/3748
> and
> http://article.gmane.org/gmane.comp.apache.db.derby.devel/3942
> for some background info on how to get useful information out of the DRDA protocol
> stream to accomplish this.
> This could be done either by modifying the toString() method of an embedded
> connection to show its associated network client connection information or (my
> preference) include this information in the proposed Connection VTI (see DERBY-292).  I am worried that if we use toString() for this, the output will be overly long and complicated; also, over a period of time the same embedded connection may be associated with multiple client connections, resulting in a changing toString() value for the embedded connection.  This seems problematic if we are intending toString() to uniquely identify a connection for the lifetime of the connection -- this would be a good goal to have as it would enable us to do some useful debugging using the VTIs.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Updated: (DERBY-293) Correlate client connection with embedded connection

Posted by "Mike Matrigali (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-293?page=all ]

Mike Matrigali updated DERBY-293:
---------------------------------

    Component: Network Server
                   (was: JDBC)

> Correlate client connection with embedded connection
> ----------------------------------------------------
>
>          Key: DERBY-293
>          URL: http://issues.apache.org/jira/browse/DERBY-293
>      Project: Derby
>         Type: Improvement
>   Components: Network Server
>     Versions: 10.1.1.0
>  Environment: N/A
>     Reporter: David Van Couvering
>     Priority: Minor
>      Fix For: 10.2.0.0

>
> There should be a way for someone to correlate a given embedded connection with its matching network client connection, if such a client connection exists.  
> See 
> http://article.gmane.org/gmane.comp.apache.db.derby.devel/3748
> and
> http://article.gmane.org/gmane.comp.apache.db.derby.devel/3942
> for some background info on how to get useful information out of the DRDA protocol
> stream to accomplish this.
> This could be done either by modifying the toString() method of an embedded
> connection to show its associated network client connection information or (my
> preference) include this information in the proposed Connection VTI (see DERBY-292).  I am worried that if we use toString() for this, the output will be overly long and complicated; also, over a period of time the same embedded connection may be associated with multiple client connections, resulting in a changing toString() value for the embedded connection.  This seems problematic if we are intending toString() to uniquely identify a connection for the lifetime of the connection -- this would be a good goal to have as it would enable us to do some useful debugging using the VTIs.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Updated: (DERBY-293) Correlate client connection with embedded connection

Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-293?page=all ]

Rick Hillegas updated DERBY-293:
--------------------------------

    Urgency: Low

> Correlate client connection with embedded connection
> ----------------------------------------------------
>
>                 Key: DERBY-293
>                 URL: http://issues.apache.org/jira/browse/DERBY-293
>             Project: Derby
>          Issue Type: Improvement
>          Components: Network Server
>    Affects Versions: 10.1.1.0
>         Environment: N/A
>            Reporter: David Van Couvering
>            Priority: Minor
>             Fix For: 10.2.0.0
>
>
> There should be a way for someone to correlate a given embedded connection with its matching network client connection, if such a client connection exists.  
> See 
> http://article.gmane.org/gmane.comp.apache.db.derby.devel/3748
> and
> http://article.gmane.org/gmane.comp.apache.db.derby.devel/3942
> for some background info on how to get useful information out of the DRDA protocol
> stream to accomplish this.
> This could be done either by modifying the toString() method of an embedded
> connection to show its associated network client connection information or (my
> preference) include this information in the proposed Connection VTI (see DERBY-292).  I am worried that if we use toString() for this, the output will be overly long and complicated; also, over a period of time the same embedded connection may be associated with multiple client connections, resulting in a changing toString() value for the embedded connection.  This seems problematic if we are intending toString() to uniquely identify a connection for the lifetime of the connection -- this would be a good goal to have as it would enable us to do some useful debugging using the VTIs.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira