Making a connection and a SQL query in a Task, using Flowable Modeler

How can I make a connection and a SQL query in a Task, using Flowable Modeler?

If I write a Java Class, where should I place it? Should it be packaged as a Jar?

Thanks

I have the same question, I wanna to populate a dropbox select with my client list, I have this on a DB table. I don’t know how to proceed.

What is better? create a table on flowable DB or make a rest service?

Hi,

Flowable allows you to easily plugin Java or script code in your process definition.
Implementing a database query in a Java service task class is one of the options and you could use a Spring bean to make this a bit easier. As an alternative you could use the HTTP task to do a REST call to retrieve the data from a REST service you implemented. There’s not really a good or bad option in this case, just go for the approach that works best for you. And yes, your service task should be included in the classpath and packaged as a JAR file like you would do with any other Java logic in an application.

Best regards,

Tijs

1 Like