Setup Oracle DB with docker

1) docker run -d -p 49161:1521 wnameless/oracle-xe-11g

2)download Oracle SQL Studio 

https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

3)configure the connection

4) create table

5) create stored procedure

6) download JDBC driver (ojdbc8.jar)

https://www.oracle.com/technetwork/database/application-development/jdbc/downloads/jdbc-ucp-183-5013470.html

6) test with groovy

import groovy.sql.Sql

import oracle.jdbc.OracleTypes

import oracle.jdbc.pool.OracleDataSource

import java.sql.CallableStatement

import java.sql.ResultSet

def ds = new OracleDataSource();

ds.setDriverType("thin")

ds.setServerName("192.168.250.35")

ds.setPortNumber(49101)

ds.setDatabaseName("xe")

ds.setUser("system")

ds.setPassword("oracle")

def conn = ds.getConnection();

println conn.class.toString();

println conn.isValid(1000)

CallableStatement cstmt = conn.prepareCall("{call GETDATA(?, ?)}")

cstmt.setInt(1, 5);

cstmt.registerOutParameter(2, OracleTypes.CURSOR);

cstmt.executeUpdate()

def rs = (ResultSet) cstmt.getObject(2);

while (rs.next()) {

    println rs.getInt("COLUMN1")

    println rs.getFloat("COLUMN2")

    println rs.getString("COLUMN3")

}