aalmiray

plugins {
    id 'com.github.johnrengelman.shadow'
    id 'java'
    id 'application'
}

application {
    mainClassName = 'com.acme.example.helidon.Main'
}

aalmiray

package main

import (
	"fmt"
	"log"

	_ "github.com/godror/godror"
	"github.com/jmoiron/sqlx"
)

aalmiray

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.acme</groupId>
    <artifactId>example</artifactId>
    <version>0.0.0</version>

    <properties>
        <oracle.jdbc.version>19.7.0.0</oracle.jdbc.version>
    </properties>

aalmiray

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.acme</groupId>
    <artifactId>consumer1</artifactId>
    <version>0.0.0</version>

    <dependencies>
        <dependency>
            <groupId>com.acme</groupId>

aalmiray

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.acme</groupId>
    <artifactId>consumer1</artifactId>
    <version>0.0.0</version>

    <dependencies>
        <dependency>
            <groupId>com.acme</groupId>

aalmiray

<?xml version="1.0" encoding="UTF-8"?>
<project xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"
    xmlns="http://maven.apache.org/POM/4.0.0"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <modelVersion>4.0.0</modelVersion>

  <groupId>com.acme</groupId>
  <artifactId>consumer</artifactId>
  <version>1.0.0</version>

aalmiray

package com.acme;

import io.agroal.api.AgroalDataSource;

import javax.inject.Inject;
import javax.inject.Named;
import javax.ws.rs.GET;
import javax.ws.rs.Path;
import javax.ws.rs.Produces;
import javax.ws.rs.core.MediaType;

aalmiray

package com.acme.ucp;

import oracle.ucp.jdbc.PoolDataSource;
import oracle.ucp.jdbc.PoolDataSourceFactory;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;

import javax.sql.DataSource;

aalmiray

datasources:
  default:
    url: ${JDBC_URL:`jdbc:oracle:thin:@localhost:1521/XEPDB1`}
    username: ${JDBC_USER:system}
    password: ${JDBC_PASSWORD:S3cr3TP4$$wd}
    driverClassName: ${JDBC_DRIVER:oracle.jdbc.driver.OracleDriver}

aalmiray

<properties>
    <version.lib.ojdbc8>19.6.0.0</version.lib.ojdbc8>
</properties>

<dependency>
    <groupId>io.helidon.integrations.cdi</groupId>
    <artifactId>helidon-integrations-cdi-datasource-ucp</artifactId>
</dependency>