JBAS-7195: On executing readonly query, WrappedConnection.checkTransactionStatus...

Activity

CR-21 0

Keyboard shortcuts  
  • Summarize the review outcomes (optional)
     
    #permalink

    Details

    Warning: no files are visible, they have all been filtered.
    Participant Role Time Spent Comments Latest Comment
    Author      
    Moderator 2m    
    Total   2m 0  
    #permalink

    Objectives

    Hi,
    When using jboss 4.2.3 with our app, we got an error of this sort (not exact):
    Cannot Execute query.....Transaction status marked rollback
    Caused by: jboss.util.NestedSQLException
    at ...WrappedConnection.checkTransactionStatus


    Scenario when the above error happens:

    a) User submits request from a web page
    b) A jta transaction is started in a filter
    c) From UI layer, transaction is propagated to service layer with "Propation Required" setting.
    d) Service layer throws an exception (validation) and transaction is marked for rollback. Note that it is marked for rollback and not rolledback
    e) The ui layer now prepares the view which requires some db queries to be executed. As soon as the first query is tried to be executed, the above exception is thrown.

    I tried the above same steps with jboss 4.2.1 and it works fine. On further probing, found that in jboss 4.2.3, there was a change made as part of:
    https://jira.jboss.org/jira/browse/JBAS-5080
    https://jira.jboss.org/jira/browse/JB...

    Branches in review

    #permalink

    Issues Raised From Comments

    Key Summary State Assignee
    #permalink

    General Comments

    There are no general comments on this review.
    /trunk/.../connectionmanager/SecurityActions.java Changed
    Open in IDE #permalink
    /trunk/.../connectionmanager/TxConnectionManager.java Changed

    Review updated: Reload | Ignore | Collapse

    You cannot reload the review while writing a comment.

    Log time against