Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-18124

[GSS](7.2.z) Need to configure PREFIX_TX_ISOLATION with NONXA datasource on Openshift

XMLWordPrintable

    • +
    • Hide

      1. Confiurare a PREFIX_TX_ISOLATION.

      $ oc new-app --template=eap72-openjdk11-basic-s2i \
       -p IMAGE_STREAM_NAMESPACE=eap-demo \
       -p SOURCE_REPOSITORY_URL=https://github.com/jboss-developer/jboss-eap-quickstarts.git \
       -p SOURCE_REPOSITORY_REF=openshift \
       -p CONTEXT_DIR=helloworld
      $ oc set env dc/eap-app \
       DB_SERVICE_PREFIX_MAPPING=H2DS-TEST=DS1 \
       DS1_URL=jdbc:h2:mem:test \
       DS1_JNDI=java:jboss/H2DS \
       DS1_DRIVER=h2 \
       DS1_USERNAME=sa \
       DS1_PASSWORD=sa \
       DS1_MAX_POOL_SIZE=10 \
       DS1_MIN_POOL_SIZE=0 \
       DS1_TX_ISOLATION=TRANSACTION_READ_COMMITTED \
       DS1_NONXA=true
      

      2 . There is no a transaction-isolation attribute in a datasource configuration.

      sh-4.4$ vi /opt/eap/standalone/configuration/standalone-openshift.xml
      --- snip ---
              <subsystem xmlns="urn:jboss:domain:datasources:5.0">
                  <datasources>
                      <datasource jta="true" jndi-name="java:jboss/H2DS" pool-name="h2ds_test-DS1" enabled="true" use-java-context="true" statistics-enabled="${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}"> <conne
      ction-url>jdbc:h2:mem:test</connection-url> <driver>h2</driver> <pool> <min-pool-size>0</min-pool-size> <max-pool-size>10</max-pool-size> </pool> <security> <user-name>sa</user-name> <password>sa</password> </security> </datasource>
      
      Show
      1. Confiurare a PREFIX_TX_ISOLATION . $ oc new-app --template=eap72-openjdk11-basic-s2i \ -p IMAGE_STREAM_NAMESPACE=eap-demo \ -p SOURCE_REPOSITORY_URL=https://github.com/jboss-developer/jboss-eap-quickstarts.git \ -p SOURCE_REPOSITORY_REF=openshift \ -p CONTEXT_DIR=helloworld $ oc set env dc/eap-app \ DB_SERVICE_PREFIX_MAPPING=H2DS-TEST=DS1 \ DS1_URL=jdbc:h2:mem:test \ DS1_JNDI=java:jboss/H2DS \ DS1_DRIVER=h2 \ DS1_USERNAME=sa \ DS1_PASSWORD=sa \ DS1_MAX_POOL_SIZE=10 \ DS1_MIN_POOL_SIZE=0 \ DS1_TX_ISOLATION=TRANSACTION_READ_COMMITTED \ DS1_NONXA=true 2 . There is no a transaction-isolation attribute in a datasource configuration. sh-4.4$ vi /opt/eap/standalone/configuration/standalone-openshift.xml --- snip --- <subsystem xmlns="urn:jboss:domain:datasources:5.0"> <datasources> <datasource jta="true" jndi-name="java:jboss/H2DS" pool-name="h2ds_test-DS1" enabled="true" use-java-context="true" statistics-enabled="${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}"> <conne ction-url>jdbc:h2:mem:test</connection-url> <driver>h2</driver> <pool> <min-pool-size>0</min-pool-size> <max-pool-size>10</max-pool-size> </pool> <security> <user-name>sa</user-name> <password>sa</password> </security> </datasource>

      PREFIX_TX_ISOLATION of Datasource Configuration Environment Variables cannot work with NONXA datasource.

              istudens@redhat.com Ivo Studensky
              rhn-support-enagai Eiichi Nagai (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: