Uploaded image for project: 'BxMS Documentation'
  1. BxMS Documentation
  2. BXMSDOC-8230

Document that RHPAM Runtime DB Schema and EJB_JBOSS_TIMER should not share the same DB Shema and how to disable the EJB timer auto configuration.

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Done
    • Icon: Major Major
    • None
    • None
    • None
    • None
    • 2021 Week 40-42 (from Oct 4), 2021 Week 43-45 (from Oct 25)
    • 3
    • Documentation (Ref Guide, User Guide, etc.)

      Document that RHPAM Runtime DB Schema and EJB_JBOSS_TIMER should not share the same DB Shema and how to disable the EJB timer auto configuration.

      References:
      RHPAM-3304
      KBase Article: Does EJB timers in RHPAM require a separate database https://access.redhat.com/solutions/4895901

      SME: rhn-support-fspolti

      Notes: See https://issues.redhat.com/browse/RHPAM-3304?focusedCommentId=18803477&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-18803477

      This can be achieved by disabling the ejb timer auto configuration.

      here is a example on how this configuration can be done:

      apiVersion: app.kiegroup.org/v2
kind: KieApp
metadata:
  name: test
spec:
  environment: rhpam-authoring
  objects:
    servers:
      - id: 'test-kieserver'
        name: 'test-kieserver'
        env:
          - name: DATASOURCES
            value: 'EJB_TIMER,RHPAM'
          - name: RHPAM_JNDI
            value: 'java:jboss/datasources/rhpam'
          - name: RHPAM_CONNECTION_CHECKER
            value: 'oracle-connection-checker'
          - name: RHPAM_EXCEPTION_SORTER
            value: 'oracle-exception-sorter'
          - name: RHPAM_NONXA
            value: 'true'  
          - name: RHPAM_URL
            value: 'my-jdbc-url'
          - name: RHPAM_DRIVER
            value: 'oracle'
          - name: KIE_SERVER_PERSISTENCE_DIALECT
            value: oracle-dialect
          - name: RHPAM_USERNAME
            value: user
          - name: RHPAM_PASSWORD
            value: pwd
          - name: EJB_TIMER_XA_CONNECTION_PROPERTY_URL
            value: ''
          - name: EJB_TIMER_JNDI
            value: 'java:jboss/datasources/ejb_timer'
          - name: EJB_TIMER_TX_ISOLATION
            value: TRANSACTION_READ_COMMITTED
          - name: EJB_TIMER_CONNECTION_CHECKER
            value: 'oracle-connection-checker'
          - name: EJB_TIMER_EXCEPTION_SORTER
            value: 'oracleExceptionSorter'
          - name: EJB_TIMER_DRIVER
            value: 'oracle'
          - name: EJB_TIMER_USERNAME
            value: user
          - name: EJB_TIMER_PASSWORD
            value: pwd
          - name: EJB_TIMER_NONXA
            value: 'false'            
          - name: TIMER_SERVICE_DATA_STORE
            value: EJB_TIMER
          - name: JAVA_OPTS_APPEND
            value: '-Dorg.jbpm.ejb.timer.tx=true -Dorg.jbpm.ejb.timer.local.cache=false'
          - name: AUTO_CONFIGURE_EJB_TIMER
            value: 'false'

      This manual configuration requires a few steps to be followed:

      The second database must be already available so JBoss EAP can create the EJB timer scheme.
      To disable the auto configuration the env AUTO_CONFIGURE_EJB_TIMER must be set to true.
      The EJB_TIMER datasource prefix must be before the RHPAM database on the DATASOURCES env, example:
      DATASOURCES="EJB_TIMER,RHPAM"
      The EJB Timer needs to be XA, use the following envs:
      EJB_TIMER_XA_CONNECTION_PROPERTY_URL=<url>
      EJB_TIMER_NONXA=false"
      The following system properties must be configured using the JAVA_OPTS_APPEND env:
      -Dorg.jbpm.ejb.timer.tx=true
      -Dorg.jbpm.ejb.timer.local.cache=false

          1.
          		 SME Review Sub-task Resolved Major Filippe Spolti
          2.
          		 Peer review Sub-task Resolved Major Brian Dooley

              csherrar Clifton Sherrard
              csherrar Clifton Sherrard
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: