[jboss-user] [jBPM] - Trying to connect to database through jBPM script task.

avatarkim [https://community.jboss.org/people/avatarkim] created the discussion "Trying to connect to database through jBPM script task." To view the discussion, visit: https://community.jboss.org/message/828814#828814 -------------------------------------------------------------- Hi, I'm trying to access MySql database through jBPM workflow's script task but I'm getting the error code below when the workflow run the script task. I already uploaded the MySQL driver jar file as POJO in the Guvnor and I'm still getting this error. "No suitable driver found for jdbc:mysql://localhost:3306/test" so I'm assuming the jBPM need some other way for it to handle MySQL driver jar but I don't know where and what should I do this for this to work. Below is my code in my Workflow's Script Task java.sql.Connection con = null; java.sql.PreparedStatement pst = null; java.sql.ResultSet rs = null; java.sql.ResultSetMetaData rsmd = null; String url = "jdbc:mysql://localhost:3306/test"; String user = "root"; String password = "password"; String temp = "DEBUG: "; try {     con = java.sql.DriverManager.getConnection(url, user, password);     pst = con.prepareStatement("SELECT * FROM aquitimber_messages");     rs = pst.executeQuery();     rsmd = rs.getMetaData();     int rowSize = 0;     rs.last();     rowSize = rs.getRow();     rs.first();     for (int countRow = 0; countRow < rowSize; countRow++)     {               for (int count = 1; count < rsmd.getColumnCount(); count++)         {                               System.out.print(rs.getString(count) + ", ");                               temp = temp + rs.getString(count) + ", ";         }         System.out.println();         rs.next();     } } catch (java.sql.SQLException ex) {           System.out.println(ex.getMessage());           temp = temp +ex.getMessage(); } finally {           try           {                     if (rs != null)                     {                               rs.close();                     }                     if (pst != null)                     {                               pst.close();                     }                     if (con != null)                     {                               con.close();                     }           } catch (java.sql.SQLException ex)           {                     System.out.println(ex.getMessage());                     temp = temp +ex.getMessage();           } } kcontext.setVariable("approvalVar_history", temp); Any help on this would be greatly appreciated. Thank you. -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/828814#828814] Start a new discussion in jBPM at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]