Camunda cockpit with MVC project

Camunda 7 Topics Discussion & Questions
,
1

Hello,
We have created web application with camunda BPNM. However when we are trying to configure the same project with camunda cockpit facing issue with configuration.

I have added my DB details in “camunda-webapp-jboss-standalone-7.12.0.war” file download from the camunda site (Install the Standalone Webapplication (.war) | docs.camunda.org) post that deploying both application .war file and camunda .war file in wildFly server. I’m getting this below error.

IMG_20200414_172402
IMG_20200414_1724024000×821 1.98 MB

Does anyone has an idea to solve this problem?

2

@akshay17 make sure oracle jdbc driver dependency is in classpath (\webapps\ROOT\WEB-INF\lib). If it’s present then check version matrix for oracle db & oracle driver versions compatibility.

Some tips:

  • Only use the DriverManagerDataSource class should only be used for testing purposes since it does not provide pooling and will perform poorly when multiple requests for a connection are made.

  • If connection pooling required, then use Apache DBCP/HikariCP.

3

Installing Oracle JDBC-Driver On Wildfly / JBoss

  1. Download the driver: ojdbc[VERSION].jar
  2. Create subfolders [WILDFLY_HOME]/modules/system/layers/base/com/oracle/main/
  3. Copy the downloaded ojdbc[VERSION].jar into the freshly created folder
  4. Create a file module.xml , in the same folder as above, with the contents:
<module xmlns="urn:jboss:module:1.1" name="com.oracle">
  <resources>
    <resource-root path="ojdbc[VERSION].jar"/>
  </resources>
  <dependencies>
    <module name="javax.api"/>
    <module name="javax.transaction.api"/>
  </dependencies>
</module>
  1. In the configuration file standalone.xml add the entry:
<driver name="oracle" module="com.oracle">
 <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
</driver>

within the <drivers> tag.

  1. Add a datasource definition within the <datasources> tag (next to ExampleDS ):
<datasource jndi-name="java:/[NAME]" pool-name="OracleDS" enabled="true">
 <connection-url>jdbc:oracle:thin:@[HOST_NAME]:1521:[SID]</connection-url>
  <driver>oracle[has to match the driver name]</driver>
  <pool>
   <min-pool-size>1</min-pool-size>
   <max-pool-size>5</max-pool-size>
   <prefill>true</prefill>
  </pool>
  <security>
   <user-name>[USER]</user-name>
   <password>[PWD]</password>
  </security>
</datasource>