jira-db-access.groovy

package com.ast.scripts.db

import groovy.sql.Sql
import org.ofbiz.core.entity.TransactionFactory
import org.ofbiz.core.entity.ConnectionFactory

import java.sql.Connection

Connection connection = TransactionFactory.getConnection("defaultDS")
Connection connection2 = ConnectionFactory.getConnection("defaultDS")

Sql sql = new Sql(connection)


String GET_EMPL_CARD_FIELD_VALUE_QUERY =
        """SELECT ID FROM AO_8C2830_EMPLOYEE_CARD where EMPLOYEE_NAME = 'a.user'"""

String value = sql.firstRow(GET_EMPL_CARD_FIELD_VALUE_QUERY)["ID"]

sql.close()

value