Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-2428

JWS only datasource configuration is missing elements

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • 7.6.0.GA
    • 7.4.0.GA, 7.5.0.GA
    • Installer
    • None
    • Release Notes
    • CR1
    • Workaround Exists
    • Hide

      Modify the resource in `context.xml` to contain missing elements, refer to documentation :
      Example minimal config for oracle datasource (comments indicate what was added):

      <Resource auth="Container"
		 type="oracle.jdbc.xa.client.OracleXADataSource" // add this type and remove driverClassName entry
                   // also remove type="javax.sql.DataSource" and add it as in documentation
		 maxIdle="30" maxTotal="100"
		 maxWaitMillis="10000"
		 name="your-datasource-name"
		 password="password"
		 factory="org.apache.tomcat.jdbc.naming.GenericNamingResourcesFactory" // add this
		 url="jdbc:oracle:thin:@oracle-12cr1.rhev-ci-vms.eng.rdu2.redhat.com:1521:dballo"
		 URL="jdbc:oracle:thin:@oracle-12cr1.rhev-ci-vms.eng.rdu2.redhat.com:1521:dballo" // add this, depends on database, some need URL some need url
		 username="username"/>
      Show
      Modify the resource in `context.xml` to contain missing elements, refer to documentation : Example minimal config for oracle datasource (comments indicate what was added): <Resource auth= "Container" type= "oracle.jdbc.xa.client.OracleXADataSource" // add this type and remove driverClassName entry // also remove type= "javax.sql.DataSource" and add it as in documentation maxIdle= "30" maxTotal= "100" maxWaitMillis= "10000" name= "your-datasource-name" password= "password" factory= "org.apache.tomcat.jdbc.naming.GenericNamingResourcesFactory" // add this url= "jdbc:oracle:thin:@oracle-12cr1.rhev-ci-vms.eng.rdu2.redhat.com:1521:dballo" URL= "jdbc:oracle:thin:@oracle-12cr1.rhev-ci-vms.eng.rdu2.redhat.com:1521:dballo" // add this , depends on database, some need URL some need url username= "username" />
    • Hide

      1. Install on JWS
      2. Configure database settings
      3. Setup database, leave defaults, change URL to desired one and add username and password
      4. Try running the server

      Show
      1. Install on JWS 2. Configure database settings 3. Setup database, leave defaults, change URL to desired one and add username and password 4. Try running the server
    • 2019 Week 41-43 (from Okt 7), 2019 Week 44-46 (from Okt 28)

    Description

      When you configure Data Source on JWS container, there are some missing elements that are needed for the setup to work properly.

      Currently the configuration for Oracle looks like this:

      <Resource auth="Container"
 driverClassName="oracle.jdbc.OracleDriver"
 maxIdle="30"
 maxTotal="100"
 maxWaitMillis="10000"
 name="processServerDS"
 password="dballo17"
 type="javax.sql.DataSource"
 url="jdbc:oracle:thin:@oracle-12cr1.rhev-ci-vms.eng.rdu2.redhat.com:1521:dballo"
 username="dballo17"
/>

      it should look like this:

      <Resource auth="Container"
		 type="oracle.jdbc.xa.client.OracleXADataSource" // changed from javax.sql.DataSource
		 maxIdle="30" maxTotal="100"
		 maxWaitMillis="10000"
		 name="processServerDS"
		 password="dballo17"
		 factory="org.apache.tomcat.jdbc.naming.GenericNamingResourcesFactory" // Added
		 url="jdbc:oracle:thin:@oracle-12cr1.rhev-ci-vms.eng.rdu2.redhat.com:1521:dballo"
		 URL="jdbc:oracle:thin:@oracle-12cr1.rhev-ci-vms.eng.rdu2.redhat.com:1521:dballo" // Added
		 username="dballo17"/>

      Attachments

        Activity

          People

            almorale Alberto Morales Pérez (Inactive)
            dhanak@redhat.com Dominik Hanak
            Dominik Hanak Dominik Hanak
            Dominik Hanak Dominik Hanak
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: