[overlord-issues] [JBoss JIRA] (RTGOV-374) Support for JPA ActivityStore

[Gary Brown (JIRA)]

    [ https://issues.jboss.org/browse/RTGOV-374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12962245#comment-12962245 ] 

Gary Brown commented on RTGOV-374:
----------------------------------

[~brmeyer] In the latest version of Karaf, they have an approach for managing different databases when configuring the data sources: http://karaf.apache.org/manual/latest/users-guide/jdbc.html

Unfortunately this is not available in the version of Karaf being used in Fuse 6.1, so we need an equivalent (but possibly interim) solution until Fuse updates to Karaf 3.0.0.

When I originally started looking into this task, I experimented with creating a bundle specific for h2 (rtgov/release/karaf/ds/activity-store-jpa-h2) - but not sure now if this is the right way to go, so feel free to remove.

Would be great if you could suggest the best way forward to support the JPA activity store on a range of databases - and feel free to improve the jpa support in rtgov in general, as this is more your area of expertise.

Another JPA related area is the JPAEventProcessor (modules/event-processor/ep-jpa). We have also recently introduced a situations-store-jpa module as part of the new rtgov ui work, which uses an entity manager callback mechanism to manage use of entity manager across multiple calls. If that is a better approach, then would be good to get some consistency across these areas.

Ideally this area needs improvement to provide support for J2EE and other environments (karaf, jetty8 and tomcat). Any advice/work you feel is appropriate, would be appreciated. Next release is likely to be mid May, so let me know what can be achieved in that timeframe, and whether other resources may be required.

                
> Support for JPA ActivityStore
> -----------------------------
>
>                 Key: RTGOV-374
>                 URL: https://issues.jboss.org/browse/RTGOV-374
>             Project: RTGov (Run Time Governance)
>          Issue Type: Sub-task
>            Reporter: Gary Brown
>            Assignee: Brett Meyer
>             Fix For: 2.0.0.Final
>
>   Original Estimate: 2 weeks
>  Remaining Estimate: 2 weeks
>
> Need to be able to use JPAActivityStore within Karaf/OSGi environment, with different databases (e.g. h2, mysql etc)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira