-
Task
-
Resolution: Done
-
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
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
- documents
-
RHPAM-3304 Images do not support EJB_JBOSS_TIMER separate datasource
-
- Closed
-
1.
|
SME Review |
|
Resolved | 
|
Filippe Spolti |
2.
|
Peer review |
|
Resolved |
|
Brian Dooley |
