[jira] Issue Comment Edited: (ODE-460) Improve InstanceManagement.listInstancesSummary() to include failure information

["Sean Ahn (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ODE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12655893#action_12655893 ] 

seanahn edited comment on ODE-460 at 12/12/08 5:20 PM:
--------------------------------------------------------

Patch file attached.

1. For hibernate DAO, the basic form of query is:
  select count(*), max(last_failed_date) from instance where failed_count > 0
2. For OpenJPA DAO, the basic form of query is:
  select count(*), max(last_failed_date) from instance where exists(select * from activity_recovery where instance.id = activity_recovery.instance_id)

      was (Author: seanahn):
    Patch file attached.

1. For hibernate DAO, the basic form of query is:
  select count(*), last_failed_date from instance where failed_count > 0
2. For OpenJPA DAO, the basic form of query is:
  select count(*), last_failed_date from instance where exists(select * from activity_recovery where instance.id = activity_recovery.instance_id)
  
> Improve InstanceManagement.listInstancesSummary() to include failure information
> --------------------------------------------------------------------------------
>
>                 Key: ODE-460
>                 URL: https://issues.apache.org/jira/browse/ODE-460
>             Project: ODE
>          Issue Type: Improvement
>          Components: Management API
>            Reporter: Alex Boisvert
>             Fix For: 1.3
>
>         Attachments: ode-460.1x.patch
>
>
> Improve InstanceManagement.listInstancesSummary() to include failure information

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