import groovy.sql.Sql
import com.eviware.soapui.support.GroovyUtils

log.info("")
log.info("  init DB connection...")

def scriptServer = "db.db.test.db.db.ru"
def scriptPassword = "password"
def scriptSid = testRunner.testCase.testSuite.project.getPropertyValue( "oraSid" )
def scriptUsername = "dbUser"
def scriptDBport = "1111"

com.eviware.soapui.support.GroovyUtils.registerJdbcDriver("oracle.jdbc.driver.OracleDriver")
sql = Sql.newInstance("jdbc:oracle:thin:@${scriptServer }:${scriptDBport}:${scriptSid}", "${scriptUsername}", "${scriptPassword}", "oracle.jdbc.OracleDriver")

def queryUserId= "" +
"select userId from " +
"  (select userId from " +
"  users_table " +
"  order by dbms_random.value) " +
"where rownum = 1"

def res = sql.firstRow(queryUserId)
def user_id = res[0].toString()

testRunner.testCase.setPropertyValue( "user_id" , user_id)

sql.close()

<ServiceProperties>
   <UserId>${#TestCase#user_id}</UserId>
</ServiceProperties>