cannot disable workflow engagements
@@ -92,7 +92,8 @@ public class AssociationDAO {
} else {
prepStmt.setString(5, "0");
}
- prepStmt.setString(6, associationDTO.getAssociationId());
+ // As the WF_WORKFLOW_ASSOCIATION.ID is integer, this has to be set as a int to work with postgre
+ prepStmt.setInt(6, Integer.parseInt(associationDTO.getAssociationId()));
prepStmt.executeUpdate();
connection.commit();
} catch (SQLException e) {
@@ -162,7 +163,8 @@ public class AssociationDAO {
String query = SQLConstants.GET_ASSOCIATION_FOR_ASSOC_ID_QUERY;
try {
prepStmt = connection.prepareStatement(query);
- prepStmt.setString(1, associationId);
+ // As the WF_WORKFLOW_ASSOCIATION.ID is integer, this has to be set as a int to work with postgre
+ prepStmt.setInt(1, Integer.parseInt(associationId));
rs = prepStmt.executeQuery();
