import com.atlassian.jira.component.ComponentAccessor
import com.onresolve.scriptrunner.db.DatabaseUtil
import groovy.sql.Sql
//import java.sql.Connection
//import org.ofbiz.core.entity.ConnectionFactory
//import org.ofbiz.core.entity.DelegatorInterface

import org.apache.log4j.Level
import org.apache.log4j.Logger
log = Logger.getLogger("com.acme.CreateIssue")
log.setLevel(Level.DEBUG)


def lot = "009-002-913"
def value = DatabaseUtil.withSql('KFSS Test') {
    //sql.call("{call ksas_exp.pr\$get_lot_photo(?,?,?)}",  ['009-002-913', Sql.VARCHAR, Sql.VARCHAR])
    //it.call("{call KSAS_EXP.PR\$GET_LOT_BY_UTCODE(?,?)}", ['00165606', Sql.VARCHAR,])
    it.callWithAllRows "{call KSAS_EXP.PR\$GET_LOT_BY_UTCODE(?,?,?)}", ['00165606', Sql.VARCHAR, Sql.VARCHAR], { rows ->
    }
}