juarezjuniorgithub’s gists

juarezjuniorgithub / HikariCP properties that have exact UCP equivalences.csv

Last active January 17, 2024 11:37

HikariCP properties that have exact UCP equivalences

HikariCP	UCP	Comments
dataSourceClassName	ConnectionFactoryClassName	(1) ConnectionFactoryClassName also covers java.sql.DriverManager cases.(2) HikariCP doesn't support XA.
jdbcUrl	URL
username	User
password	Password
connectionTimeout (ms)	ConnectionWaitTimeout	UCP 23.2 supports ms and pre-23.2 supports sec. HikariCP lowest acceptable value 250ms.
idleTimeout	InactiveConnectionTimeout	HikariCP won't drop below minimumIdle.
maxLifeTime	MaxConnectionReuseTime
connectionTestQuery	SQLForValidateConnection
maximumPoolSize	MaxPoolSize

juarezjuniorgithub / OracleR2dbcProjectReactor.java

Created November 14, 2023 14:33

OracleR2dbcProjectReactor.java

	package com.oracle.dev.jdbc.r2dbc;

	import io.r2dbc.spi.Connection;
	import io.r2dbc.spi.ConnectionFactory;
	import reactor.core.publisher.Flux;
	import reactor.core.publisher.Mono;

	public class OracleR2dbcProjectReactor {

	private static final String QUERY = "SELECT * FROM CUSTOMERS";

juarezjuniorgithub / SQLStatementWithAsynchronousJDBC.java

Last active November 14, 2023 12:12

SQLStatementWithAsynchronousJDBC.java

	package com.oracle.jdbc.reactive;

	import java.sql.SQLException;
	import java.util.concurrent.Flow;

	import oracle.jdbc.OracleConnection;
	import oracle.jdbc.OraclePreparedStatement;
	import oracle.jdbc.pool.OracleDataSource;

	public class SQLStatementWithAsynchronousJDBC {

juarezjuniorgithub / 23c-SpringBoot-JPA_Hibernate-UCP.sql

Created November 13, 2023 12:56

23c-SpringBoot-JPA_Hibernate-UCP.sql

	CREATE USER ORACLE_23C_USER IDENTIFIED BY <YOUR_PASSWORD>;
	GRANT DB_DEVELOPER_ROLE TO ORACLE_23C_USER;
	GRANT CREATE SESSION TO ORACLE_23C_USER;
	GRANT UNLIMITED TABLESPACE TO ORACLE_23C_USER;

	CREATE TABLE Employee
	(id NUMBER(10) CONSTRAINT pk_employee PRIMARY KEY,
	name VARCHAR2(20),
	job VARCHAR2(20),
	salary NUMBER(10),

juarezjuniorgithub / application.properties

Last active August 15, 2024 10:16

application.properties

	micronaut.application.name=micronautguide

	flyway.datasources.default.enabled=true
	flyway.datasources.default.baseline-on-migrate=true
	flyway.datasources.default.baseline-version=1.0.0

	datasources.default.dialect=ORACLE
	datasources.default.ocid=<YOUR_DB_OCID>
	datasources.default.username=<YOUR_DB_ADMIN_USERNAME>
	datasources.default.password=<YOUR_PASSWORD>

juarezjuniorgithub / application-oraclecloud.yml

Last active August 14, 2024 15:20

application-oraclecloud.yml

	datasources:
	default:
	ocid: <YOUR_DB_OCID>
	walletPassword: <YOUR_WALLET_PASSWORD>
	username: <YOUR_DB_ADMIN_USERNAME>
	password: <YOUR_WALLET_PASSWORD>
	oci:
	config:
	profile: DEFAULT

juarezjuniorgithub / ThingRepository.java

Created November 10, 2023 11:26

ThingRepository.java

	package com.oracle.dev.jdbc.micronaut.repository;

	import io.micronaut.core.annotation.NonNull;
	import io.micronaut.data.jdbc.annotation.JdbcRepository;
	import io.micronaut.data.model.query.builder.sql.Dialect;
	import io.micronaut.data.repository.CrudRepository;

	import java.util.List;
	import java.util.Optional;

juarezjuniorgithub / Things.java

Created November 10, 2023 11:26

Things.java

	package com.oracle.dev.jdbc.micronaut.domain;

	import io.micronaut.core.annotation.Creator;
	import io.micronaut.data.annotation.GeneratedValue;
	import io.micronaut.data.annotation.Id;
	import io.micronaut.data.annotation.MappedEntity;
	import io.micronaut.serde.annotation.Serdeable;

	@MappedEntity
	@Serdeable

juarezjuniorgithub / ThingsController.java

Created November 10, 2023 11:24

ThingsController.java

	package com.oracle.dev.jdbc.micronaut.controller;

	import io.micronaut.http.annotation.Controller;
	import io.micronaut.http.annotation.Get;
	import io.micronaut.scheduling.TaskExecutors;
	import io.micronaut.scheduling.annotation.ExecuteOn;

	import jakarta.validation.constraints.NotBlank;
	import java.util.List;
	import java.util.Optional;

juarezjuniorgithub / Application.java

Created November 10, 2023 11:24

Application.java

	package com.oracle.dev.jdbc.micronaut;

	import io.micronaut.runtime.Micronaut;

	public class Application {

	public static void main(String[] args) {
	Micronaut.run(Application.class, args);
	}
	}

Juarez Barbosa Junior juarezjuniorgithub