Camunda 7.17 unable to connect postgres 12

Camunda 7 Topics Discussion & Questions
,
1

I am unable to call the database service using the java class.

error camunda
error camunda864×415 28.6 KB

here is the Java class code (eclipse):

Blockquote package org.camunda.bpm.getstarted;

import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import org.camunda.bpm.engine.delegate.DelegateExecution;
import org.camunda.bpm.engine.delegate.JavaDelegate;

public class dbCompany implements JavaDelegate
{
public void execute(final DelegateExecution execution) throws Exception {
System.out.println(“Database work start”);
String JdbcURL = “jdbc:postgresql://localhost:5432/postgres”;
String Username = “postgres”;
String password = “admin”;
Connection con = null;
Statement query = null;
try {
System.out.println(“Connecting to database…” + JdbcURL);
con = DriverManager.getConnection(JdbcURL, Username, password);
System.out.println(“Connection Sucess”);
con.setAutoCommit(false);
}
catch (Exception e) {
e.printStackTrace();
}
try {
query = con.createStatement();
final String sql = “INSERT INTO COMPANY VALUES (5,‘Afzal’, null, ‘Senior Consultant’,‘test’,‘afzal.saeed@systemsltd.com’ );”;
System.out.println(“Current Query:” + sql);
query.executeUpdate(sql);
query.close();
con.commit();
con.close();
System.out.println(“Records created successfully”);
}
catch (Exception e) {
System.err.println(e.getClass().getName() + ": " + e.getMessage());
System.exit(0);
}
}
}

Blockquote

and my POM.xml:

4.0.0 org.camunda.bpm.getstarted STZA_Maven 0.0.1-SNAPSHOT war 7.17.0 1.8 1.8 org.camunda.bpm camunda-bom ${camunda.version} import pom 
<dependency>
  <groupId>org.camunda.bpm</groupId>
  <artifactId>camunda-engine</artifactId>
  <scope>provided</scope>
</dependency>

<dependency>
  <groupId>org.camunda.spin</groupId>
  <artifactId>camunda-spin-dataformat-json-jackson</artifactId>
  <scope>provided</scope>
</dependency>

<dependency>
  <groupId>org.camunda.connect</groupId>
  <artifactId>camunda-connect-core</artifactId>
</dependency>

<dependency>
    <groupId>org.apache.chemistry.opencmis</groupId>
    <artifactId>chemistry-opencmis-client-impl</artifactId>
    <version>0.13.0</version>
 </dependency>

<dependency>
<groupId>org.camunda.bpm</groupId>
<artifactId>camunda-engine-plugin-spin</artifactId>
<scope>provided</scope>
</dependency>	

<dependency>
  <groupId>org.camunda.bpm</groupId>
  <artifactId>camunda-engine-plugin-connect</artifactId>
</dependency>

<dependency>
  <groupId>com.sun.xml.bind</groupId>
  <artifactId>jaxb-impl</artifactId>
  <version>2.3.5</version>
</dependency>

<dependency>
  <groupId>org.camunda.connect</groupId>
  <artifactId>camunda-connect-connectors-all</artifactId>
</dependency>

    <!--for email-->
org.camunda.bpm.extension camunda-bpm-mail-core 1.2.0 com.sun.mail javax.mail 1.4.5 
<dependency>
  <groupId>javax.servlet</groupId>
  <artifactId>javax.servlet-api</artifactId>
  <version>4.0.1</version>
  <scope>provided</scope>
</dependency>

<dependency>
    <groupId>org.slf4j</groupId>
    <artifactId>slf4j-log4j12</artifactId>
    <version>1.7.5</version>
</dependency>

<dependency>
  <groupId>org.slf4j</groupId>
  <artifactId>slf4j-api</artifactId>
  <version>1.7.5</version>
</dependency>

<dependency>
   <groupId>org.codehaus.woodstox</groupId>
   <artifactId>stax2-api</artifactId>
   <version>3.1.4</version>
</dependency>

<dependency>
    <groupId>org.codehaus.woodstox</groupId>
    <artifactId>woodstox-core-asl</artifactId>
    <version>4.4.0</version>
</dependency>	

<dependency>
   <groupId>org.jvnet.mimepull</groupId>
   <artifactId>mimepull</artifactId>
   <version>1.9.4</version>
</dependency>

<dependency>
    <groupId>log4j</groupId>
    <artifactId>log4j</artifactId>
    <version>1.2.17</version>
</dependency>

<dependency>
    <groupId>com.google.zxing</groupId>
    <artifactId>javase</artifactId>
    <version>2.2</version>
</dependency>

<dependency>
    <groupId>org.codehaus.groovy</groupId>
    <artifactId>groovy-all</artifactId>
    <version>2.4.1</version>
</dependency>

<dependency>
<groupId>org.camunda.spin</groupId>
<artifactId>camunda-spin-bom</artifactId>
 <scope>provided</scope>
<type>pom</type>
<version>1.9.0</version>

<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-email</artifactId>
<version>1.5</version>

    <dependency>
        <groupId>org.camunda.connect</groupId>
        <artifactId>camunda-connect-http-client</artifactId>
        <version>1.5.2</version>
    </dependency>
    
   <dependency>
        <groupId>org.camunda.connect</groupId>
        <artifactId>camunda-connect-soap-http-client</artifactId>
        <version>1.3.0</version>
    </dependency>
    

<dependency>
  <groupId>org.camunda.template-engines</groupId>
  <artifactId>camunda-template-engines-freemarker</artifactId>
  <scope>provided</scope>
org.postgresql postgresql 42.2.12 
<repositories>
<repository>
  <id>camunda-bpm-nexus</id>
  <name>camunda-bpm-nexus</name>
  <url>https://artifacts.camunda.com/artifactory/public/</url>
</repository>
org.apache.maven.plugins maven-war-plugin 3.3.2 false
2