Can't connect sql server from camunda

Camunda 7 Topics Discussion & Questions
1

I want to get form data from camunda and submit my table in sql server , for this i have added:

  1. sqljdbc4.jar in camunda server lib

  2. add appropriate maven dependency in maven
    3.i have added read and write opertaion in camunda javadelegate class but when i run program camunda project can’t load jdbc driver but when i run this code in java main class it works perfectly, here is my code example:
    try {
    Class.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver”);

                 Connection connection = null;
        

             String url = "jdbc:sqlserver://localhost:1433;Database=test";
        
             String username = "sa";
            String password = "*****";
            connection = DriverManager.getConnection(url, username, password);
            Connection connection1 = DriverManager.getConnection(url,username,password); 
            String sql ="INSERT INTO testData(Type,Number,name,Date) VALUES(?,?,?,?)";
            PreparedStatement pstmt = connection.prepareStatement(sql); 
            pstmt.setString(1,Type);
            pstmt.setString(2, Number);
            pstmt.setString(3, name);
            pstmt.setString(4,java.sql.Date) ConvertDate(Date));
                pstmt.executeUpdate();
            

        
 		connection1.close();
         }catch (Exception e) { 
 	          System.err.println("Got an exception! "); 
 	          System.err.println(e.getMessage()); 
 	      }  
 

         
     }
 
 static java.sql.Date ConvertDate(String strDate) throws ParseException {
 	DateFormat userDateFormat = new SimpleDateFormat("yyyy-MM-dd");
     Date date = userDateFormat.parse(strDate);
     java.sql.Date sqlDate = new java.sql.Date(date.getTime());
 	return sqlDate;
 }

what should i change to make jdbc driver load in camunda? @thorben you are always helpfull do you have any idea about it?

2

you need to configure the bean “TransactionManager” and “Datasource”. Inject the Jdbcproperties to datasource.