I want to get form data from camunda and submit my table in sql server , for this i have added:
-
sqljdbc4.jar in camunda server lib
-
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?