Can't connect sql server from camunda

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?

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