Using DB connector

Hi everyone!

I would like to know if someone can help me how to use the DB Connector for SQL Server.

I have already created the Connector to an automatic task, configure the sql query and use the graphical mode (N to N in this case) to assign the resultset to a variable type java.util.List

Is it okay to use a java.util.List variable to load the tableResult?

I get data from the query result as a String ([Field1, Field2, Field3]), but I think it would be ideal to convert each row to an object, is it possible to do it when the resultTable is assigned to the variable?

So I can get a field from the query result, but I'm sure it can be done better than this:

import java.util.logging.Logger

Logger logger = Logger.getLogger ("org.bonitasoft")
logger.severe ("Amount of logs:" + reports.size (). toString ())

for (var in reports) {

String [] clientList = var.toString (). Split (",")
def customer = customerList [3]

logger.severe ("The Client is:" + client)
}