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 "A B (JIRA)" <de...@db.apache.org> on 2005/08/04 21:04:36 UTC

[jira] Created: (DERBY-492) Server hangs when trying to return high number (hundreds) of columns from a Java procedure to the client.

Server hangs when trying to return high number (hundreds) of columns from a Java procedure to the client.
---------------------------------------------------------------------------------------------------------

         Key: DERBY-492
         URL: http://issues.apache.org/jira/browse/DERBY-492
     Project: Derby
        Type: Sub-task
  Components: Network Server  
    Versions: 10.0.2.2, 10.1.1.0, 10.2.0.0    
 Environment: Derby Network Server running with either JDBC or ODBC driver.
    Reporter: A B
 Attachments: storedProcs.java, stored_proc_repro.java

Server hangs in communication with client when it (the server) tries to send a DSS continuation header to accommodate a high number (hundreds) of return columns from a Java procedure. Problem appears to be in the way the server creates the DSS continuation header. Repro can be found in the "stored_proc_repro.java" file, which uses the stored procedure "LOTS_O_COLS" declared in "storedProcs.java". Both files are attached to this bug.

-- 
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] Closed: (DERBY-492) Server hangs when trying to return high number (hundreds) of columns from a Java procedure to the client.

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


Resolved and ported to 10.1 as part of DERBY-491.

> Server hangs when trying to return high number (hundreds) of columns from a Java procedure to the client.
> ---------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-492
>          URL: http://issues.apache.org/jira/browse/DERBY-492
>      Project: Derby
>         Type: Sub-task

>   Components: Network Server
>     Versions: 10.0.2.2, 10.1.1.0, 10.2.0.0
>  Environment: Derby Network Server running with either JDBC or ODBC driver.
>     Reporter: A B
>     Assignee: Bryan Pendleton
>  Attachments: storedProcs.java, stored_proc_repro.java
>
> Server hangs in communication with client when it (the server) tries to send a DSS continuation header to accommodate a high number (hundreds) of return columns from a Java procedure. Problem appears to be in the way the server creates the DSS continuation header. Repro can be found in the "stored_proc_repro.java" file, which uses the stored procedure "LOTS_O_COLS" declared in "storedProcs.java". Both files are attached to this bug.

-- 
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-492) Server hangs when trying to return high number (hundreds) of columns from a Java procedure to the client.

Posted by "Bryan Pendleton (JIRA)" <de...@db.apache.org>.
    [ http://issues.apache.org/jira/browse/DERBY-492?page=comments#action_12362694 ] 

Bryan Pendleton commented on DERBY-492:
---------------------------------------

I believe that this bug, although it has dramatically different symptoms, is actually the same bug as DERBY-491. Please see DERBY-491 for more details about this bug, and for a proposed fix to the problem.

> Server hangs when trying to return high number (hundreds) of columns from a Java procedure to the client.
> ---------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-492
>          URL: http://issues.apache.org/jira/browse/DERBY-492
>      Project: Derby
>         Type: Sub-task
>   Components: Network Server
>     Versions: 10.1.1.0, 10.2.0.0, 10.0.2.2
>  Environment: Derby Network Server running with either JDBC or ODBC driver.
>     Reporter: A B
>     Assignee: Bryan Pendleton
>  Attachments: storedProcs.java, stored_proc_repro.java
>
> Server hangs in communication with client when it (the server) tries to send a DSS continuation header to accommodate a high number (hundreds) of return columns from a Java procedure. Problem appears to be in the way the server creates the DSS continuation header. Repro can be found in the "stored_proc_repro.java" file, which uses the stored procedure "LOTS_O_COLS" declared in "storedProcs.java". Both files are attached to this bug.

-- 
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-492) Server hangs when trying to return high number (hundreds) of columns from a Java procedure to the client.

Posted by "Bryan Pendleton (JIRA)" <de...@db.apache.org>.
    [ http://issues.apache.org/jira/browse/DERBY-492?page=comments#action_12360749 ] 

Bryan Pendleton commented on DERBY-492:
---------------------------------------

Please see DERBY-125 for information on a proposed fix to this bug.

> Server hangs when trying to return high number (hundreds) of columns from a Java procedure to the client.
> ---------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-492
>          URL: http://issues.apache.org/jira/browse/DERBY-492
>      Project: Derby
>         Type: Sub-task
>   Components: Network Server
>     Versions: 10.1.1.0, 10.2.0.0, 10.0.2.2
>  Environment: Derby Network Server running with either JDBC or ODBC driver.
>     Reporter: A B
>     Assignee: Bryan Pendleton
>  Attachments: storedProcs.java, stored_proc_repro.java
>
> Server hangs in communication with client when it (the server) tries to send a DSS continuation header to accommodate a high number (hundreds) of return columns from a Java procedure. Problem appears to be in the way the server creates the DSS continuation header. Repro can be found in the "stored_proc_repro.java" file, which uses the stored procedure "LOTS_O_COLS" declared in "storedProcs.java". Both files are attached to this bug.

-- 
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-492) Server hangs when trying to return high number (hundreds) of columns from a Java procedure to the client.

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

A B updated DERBY-492:
----------------------

    Attachment: storedProcs.java
                stored_proc_repro.java

Attaching repro files (same as for DERBY-170).

> Server hangs when trying to return high number (hundreds) of columns from a Java procedure to the client.
> ---------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-492
>          URL: http://issues.apache.org/jira/browse/DERBY-492
>      Project: Derby
>         Type: Sub-task
>   Components: Network Server
>     Versions: 10.0.2.2, 10.1.1.0, 10.2.0.0
>  Environment: Derby Network Server running with either JDBC or ODBC driver.
>     Reporter: A B
>  Attachments: storedProcs.java, stored_proc_repro.java
>
> Server hangs in communication with client when it (the server) tries to send a DSS continuation header to accommodate a high number (hundreds) of return columns from a Java procedure. Problem appears to be in the way the server creates the DSS continuation header. Repro can be found in the "stored_proc_repro.java" file, which uses the stored procedure "LOTS_O_COLS" declared in "storedProcs.java". Both files are attached to this bug.

-- 
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] Resolved: (DERBY-492) Server hangs when trying to return high number (hundreds) of columns from a Java procedure to the client.

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

    Resolution: Duplicate

The symptoms are different, but the underlying bug is the same as DERBY-491.

> Server hangs when trying to return high number (hundreds) of columns from a Java procedure to the client.
> ---------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-492
>          URL: http://issues.apache.org/jira/browse/DERBY-492
>      Project: Derby
>         Type: Sub-task
>   Components: Network Server
>     Versions: 10.1.1.0, 10.2.0.0, 10.0.2.2
>  Environment: Derby Network Server running with either JDBC or ODBC driver.
>     Reporter: A B
>     Assignee: Bryan Pendleton
>  Attachments: storedProcs.java, stored_proc_repro.java
>
> Server hangs in communication with client when it (the server) tries to send a DSS continuation header to accommodate a high number (hundreds) of return columns from a Java procedure. Problem appears to be in the way the server creates the DSS continuation header. Repro can be found in the "stored_proc_repro.java" file, which uses the stored procedure "LOTS_O_COLS" declared in "storedProcs.java". Both files are attached to this bug.

-- 
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-492) Server hangs when trying to return high number (hundreds) of columns from a Java procedure to the client.

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

Bryan Pendleton updated DERBY-492:
----------------------------------

    Comment: was deleted

> Server hangs when trying to return high number (hundreds) of columns from a Java procedure to the client.
> ---------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-492
>          URL: http://issues.apache.org/jira/browse/DERBY-492
>      Project: Derby
>         Type: Sub-task
>   Components: Network Server
>     Versions: 10.1.1.0, 10.2.0.0, 10.0.2.2
>  Environment: Derby Network Server running with either JDBC or ODBC driver.
>     Reporter: A B
>     Assignee: Bryan Pendleton
>  Attachments: storedProcs.java, stored_proc_repro.java
>
> Server hangs in communication with client when it (the server) tries to send a DSS continuation header to accommodate a high number (hundreds) of return columns from a Java procedure. Problem appears to be in the way the server creates the DSS continuation header. Repro can be found in the "stored_proc_repro.java" file, which uses the stored procedure "LOTS_O_COLS" declared in "storedProcs.java". Both files are attached to this bug.

-- 
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] Assigned: (DERBY-492) Server hangs when trying to return high number (hundreds) of columns from a Java procedure to the client.

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

Bryan Pendleton reassigned DERBY-492:
-------------------------------------

    Assign To: Bryan Pendleton

> Server hangs when trying to return high number (hundreds) of columns from a Java procedure to the client.
> ---------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-492
>          URL: http://issues.apache.org/jira/browse/DERBY-492
>      Project: Derby
>         Type: Sub-task
>   Components: Network Server
>     Versions: 10.1.1.0, 10.2.0.0, 10.0.2.2
>  Environment: Derby Network Server running with either JDBC or ODBC driver.
>     Reporter: A B
>     Assignee: Bryan Pendleton
>  Attachments: storedProcs.java, stored_proc_repro.java
>
> Server hangs in communication with client when it (the server) tries to send a DSS continuation header to accommodate a high number (hundreds) of return columns from a Java procedure. Problem appears to be in the way the server creates the DSS continuation header. Repro can be found in the "stored_proc_repro.java" file, which uses the stored procedure "LOTS_O_COLS" declared in "storedProcs.java". Both files are attached to this bug.

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