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 de...@db.apache.org on 2004/09/29 21:16:32 UTC

[jira] Created: (DERBY-22) Exception XCL16 incorrectly raised for ResultSet of method return after nested commit.

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:
  http://issues.apache.org/jira/browse/DERBY-22

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: DERBY-22
    Summary: Exception XCL16 incorrectly raised for ResultSet of method return after nested commit.
       Type: Bug

     Status: Unassigned
   Priority: Minor

    Project: Derby
 Components: 
             SQL
   Versions:
             10.0.2.0

   Assignee: 
   Reporter: Tulika Agrawal

    Created: Wed, 29 Sep 2004 12:15 PM
    Updated: Wed, 29 Sep 2004 12:15 PM

Description:
Reporting for Daniel John Debrunner.

A static method calls commit() with the nested connection and 
then returns a value to the outer statement. Processing this 
result set incorrectly hits a XCL16 exception. Logically the 
result set is created after the commit, since the value is 
returned after the commit.



---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


Re: [jira] Commented: (DERBY-22) Exception XCL16 incorrectly raised for ResultSet of method return after nested commit.

Posted by Shreyas Kaushik <Sh...@Sun.COM>.
Any updates on this?

~ Shreyas

Shreyas Kaushik wrote:

> Can anyone update this ?
>
> ~ Shreyas
>
> Shreyas Kaushik (JIRA) wrote:
>
>>     [ 
>> http://issues.apache.org/jira/browse/DERBY-22?page=comments#action_58554 
>> ]
>>     Shreyas Kaushik commented on DERBY-22:
>> --------------------------------------
>>
>> Can there be a repro posted for this here?
>>
>>  
>>
>>> Exception XCL16 incorrectly raised for ResultSet of method return 
>>> after nested commit.
>>> -------------------------------------------------------------------------------------- 
>>>
>>>
>>>         Key: DERBY-22
>>>         URL: http://issues.apache.org/jira/browse/DERBY-22
>>>     Project: Derby
>>>        Type: Bug
>>>  Components: SQL
>>>    Versions: 10.0.2.0
>>>    Reporter: Tulika Agrawal
>>>    Priority: Minor
>>>   
>>
>>
>>  
>>
>>> Reporting for Daniel John Debrunner.
>>> A static method calls commit() with the nested connection and then 
>>> returns a value to the outer statement. Processing this result set 
>>> incorrectly hits a XCL16 exception. Logically the result set is 
>>> created after the commit, since the value is returned after the commit.
>>>   
>>
>>
>>  
>>

Re: [jira] Commented: (DERBY-22) Exception XCL16 incorrectly raised for ResultSet of method return after nested commit.

Posted by Shreyas Kaushik <Sh...@Sun.COM>.
Can anyone update this ?

~ Shreyas

Shreyas Kaushik (JIRA) wrote:

>     [ http://issues.apache.org/jira/browse/DERBY-22?page=comments#action_58554 ]
>     
>Shreyas Kaushik commented on DERBY-22:
>--------------------------------------
>
>Can there be a repro posted for this here?
>
>  
>
>>Exception XCL16 incorrectly raised for ResultSet of method return after nested commit.
>>--------------------------------------------------------------------------------------
>>
>>         Key: DERBY-22
>>         URL: http://issues.apache.org/jira/browse/DERBY-22
>>     Project: Derby
>>        Type: Bug
>>  Components: SQL
>>    Versions: 10.0.2.0
>>    Reporter: Tulika Agrawal
>>    Priority: Minor
>>    
>>
>
>  
>
>>Reporting for Daniel John Debrunner.
>>A static method calls commit() with the nested connection and 
>>then returns a value to the outer statement. Processing this 
>>result set incorrectly hits a XCL16 exception. Logically the 
>>result set is created after the commit, since the value is 
>>returned after the commit.
>>    
>>
>
>  
>

[jira] Commented: (DERBY-22) Exception XCL16 incorrectly raised for ResultSet of method return after nested commit.

Posted by "Shreyas Kaushik (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-22?page=comments#action_58554 ]
     
Shreyas Kaushik commented on DERBY-22:
--------------------------------------

Can there be a repro posted for this here?

> Exception XCL16 incorrectly raised for ResultSet of method return after nested commit.
> --------------------------------------------------------------------------------------
>
>          Key: DERBY-22
>          URL: http://issues.apache.org/jira/browse/DERBY-22
>      Project: Derby
>         Type: Bug
>   Components: SQL
>     Versions: 10.0.2.0
>     Reporter: Tulika Agrawal
>     Priority: Minor

>
> Reporting for Daniel John Debrunner.
> A static method calls commit() with the nested connection and 
> then returns a value to the outer statement. Processing this 
> result set incorrectly hits a XCL16 exception. Logically the 
> result set is created after the commit, since the value is 
> returned after the commit.

-- 
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
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


[jira] Updated: (DERBY-22) Exception XCL16 incorrectly raised for ResultSet of method return after nested commit.

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-22?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-22:
--------------------------------

    Attachment: derby22reproattempt.zip

Here is another attempt to reproduce, setting the connection to CLOSE_CURSORS_AT_COMMIT, but still cannot reproduce.  Ideas?




> Exception XCL16 incorrectly raised for ResultSet of method return after nested commit.
> --------------------------------------------------------------------------------------
>
>                 Key: DERBY-22
>                 URL: https://issues.apache.org/jira/browse/DERBY-22
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.0.2.0
>            Reporter: Tulika Agrawal
>            Priority: Minor
>         Attachments: derby22reproattempt.zip, derby22reproattempt.zip
>
>
> Reporting for Daniel John Debrunner.
> A static method calls commit() with the nested connection and 
> then returns a value to the outer statement. Processing this 
> result set incorrectly hits a XCL16 exception. Logically the 
> result set is created after the commit, since the value is 
> returned after the commit.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-22) Exception XCL16 incorrectly raised for ResultSet of method return after nested commit.

Posted by "Daniel John Debrunner (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-22?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12516730 ] 

Daniel John Debrunner commented on DERBY-22:
--------------------------------------------

Try with the connection in close cursors on commit mode.

> Exception XCL16 incorrectly raised for ResultSet of method return after nested commit.
> --------------------------------------------------------------------------------------
>
>                 Key: DERBY-22
>                 URL: https://issues.apache.org/jira/browse/DERBY-22
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.0.2.0
>            Reporter: Tulika Agrawal
>            Priority: Minor
>         Attachments: derby22reproattempt.zip
>
>
> Reporting for Daniel John Debrunner.
> A static method calls commit() with the nested connection and 
> then returns a value to the outer statement. Processing this 
> result set incorrectly hits a XCL16 exception. Logically the 
> result set is created after the commit, since the value is 
> returned after the commit.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-22) Exception XCL16 incorrectly raised for ResultSet of method return after nested commit.

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-22?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-22:
--------------------------------

    Attachment: derby22reproattempt.zip

Attached is an attempted repro of this issue based on the description, but it doesn't seem to fail.  Perhaps it has been already fixed or perhaps I errored in trying to reproduce the issue.  Dan could you comment on which might be the case.

Thanks

Kathey


> Exception XCL16 incorrectly raised for ResultSet of method return after nested commit.
> --------------------------------------------------------------------------------------
>
>                 Key: DERBY-22
>                 URL: https://issues.apache.org/jira/browse/DERBY-22
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.0.2.0
>            Reporter: Tulika Agrawal
>            Priority: Minor
>         Attachments: derby22reproattempt.zip
>
>
> Reporting for Daniel John Debrunner.
> A static method calls commit() with the nested connection and 
> then returns a value to the outer statement. Processing this 
> result set incorrectly hits a XCL16 exception. Logically the 
> result set is created after the commit, since the value is 
> returned after the commit.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Resolved: (DERBY-22) Exception XCL16 incorrectly raised for ResultSet of method return after nested commit.

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-22?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden resolved DERBY-22.
---------------------------------

    Resolution: Cannot Reproduce

Was not able to reproduce this error. The issue can be reopened if we get a repro.

Kathey


> Exception XCL16 incorrectly raised for ResultSet of method return after nested commit.
> --------------------------------------------------------------------------------------
>
>                 Key: DERBY-22
>                 URL: https://issues.apache.org/jira/browse/DERBY-22
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.0.2.0
>            Reporter: Tulika Agrawal
>            Priority: Minor
>         Attachments: derby22reproattempt.zip, derby22reproattempt.zip
>
>
> Reporting for Daniel John Debrunner.
> A static method calls commit() with the nested connection and 
> then returns a value to the outer statement. Processing this 
> result set incorrectly hits a XCL16 exception. Logically the 
> result set is created after the commit, since the value is 
> returned after the commit.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.