Kuassim

/*
 * Setting TNS_ADMIN to point to the locatioon of the tnsnames.ora file and/or the
 * property files (e.g., ojdbc.properties, new with DB18c)
 * by default $ORACLE_HOME/network/admin but you must explicly set its value
 *
 * 
 *
 * option 1 -- non-intrusive
 */
  java -Doracle.net.tns_admin=<location of tnsnames.ora>

Kuassim

alias =(DESCRIPTION =
        (CONNECT_TIMEOUT=120) (RETRY_COUNT=20)(RETRY_DELAY=3)(TRANSPORT_CONNECT_TIMEOUT=3)
            (ADDRESS_LIST =
                  (LOAD_BALANCE=on)
                  ( ADDRESS = (PROTOCOL = TCP)(HOST=primary-scan)(PORT=1521)))
            (ADDRESS_LIST =
                  (LOAD_BALANCE=on)
                  ( ADDRESS = (PROTOCOL = TCP)(HOST=secondary-scan)(PORT=1521)))
            (CONNECT_DATA=(SERVICE_NAME = <ATP-D service name>)))

Kuassim

Node Down, Public Network Down 
Instance Down, Instance Up
Service Down, Service Up, Service member Down, Service member Up 
Database Down, Database Up

Kuassim

final static String DB_PASSWORD = "<my password>"; // Can also be recup'ed from environment
final static String DB_USER ="<my user>"; // can also be recup'ed from env
  
String DB_URL = System.getenv("url");
        if (DB_URL == null ) {
          System.out.println("Environment variables url must be set");
          System.exit(1);
        }
    Properties info = new Properties();
    info.put(OracleConnection.CONNECTION_PROPERTY_USER_NAME, DB_USER);

Kuassim

export url=jdbc:oracle:thin:@java_tpurgent_tls?TNS_ADMIN=/home/opc/jdbctest/wallet_java
export TNS_ADMIN=/home/opc/jdbctest/wallet_java

Kuassim

...
String DB_URL = System.getenv("url");
        if (DB_URL == null ) {
          System.out.println("Environment variable url must be set");
          System.exit(1);
        }
 PoolDataSource pds = PoolDataSourceFactory.getPoolDataSource();
 pds.setConnectionFactoryClassName("oracle.jdbc.replay.OracleDataSourceImpl");
 pds.setURL(DB_URL); pds.setUser(DB_USER);pds.setPassword(DB_PASSWORD);
 pds.setConnectionPoolName("JDBC_UCP_POOL");

Kuassim

export url=jdbc:oracle:thin:@java_tpurgent_tls?TNS_ADMIN=/home/opc/credentials

export foo=/home/opc/credentials
java -Doracle.ons.walletfile=$foo/cwallet.sso \
     -Doracle.ons.walletpassword= ... \
     -cp ./lib/ojdbc10.jar:./lib/ucp.jar:./lib/ons.jar:$foo/oraclepki.jar:$foo/osdt_cert.jar:$foo/osdt_core.jar:. UCP

Kuassim

export url=jdbc:oracle:thin:@java_tpurgent_tls?TNS_ADMIN=/home/opc/credentials
export foo=/home/opc/credentials
java -Doracle.ons.walletfile=$foo/cwallet.sso \
     -Doracle.ons.walletpassword=WE10come12## \
     -Djavax.net.ssl.trustStore=$TNS_ADMIN/truststore.jks\
     -Djavax.net.ssl.trustStorePassword=WE10come12## \
     -Djavax.net.ssl.trustStoreType="JKS" \
     -cp ./lib/ojdbc10.jar:./lib/ucp.jar:./lib/ons.jar:$foo/oraclepki.jar:. UCP

Kuassim

export url=jdbc:oracle:thin:@java_tpurgent_tls?TNS_ADMIN=/home/opc/jdbctest/wallet_java
export TNS_ADMIN=/home/opc/jdbctest/wallet_java
export sso=/home/opc/jdbctest/wallet_java
java -Doracle.ons.walletfile=/home/opc/jdbctest/wallet_java/cwallet.sso \
     -Doracle.ons.walletpassword=WE10come12## \
     -Djavax.net.ssl.trustStore=$TNS_ADMIN/truststore.jks\
     -Djavax.net.ssl.trustStorePassword=WE10come12## \
     -Djavax.net.ssl.trustStoreType="JKS" \
     -cp ./lib/ojdbc10.jar:./lib/ucp.jar:./lib/ons.jar:$sso/oraclepki.jar:. UCP
 

Kuassim

<?xml version="1.0" encoding="UTF-8"?>
<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.oracle.prod</groupId>
  <artifactId>jdbc-driver-prod</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>jar</packaging>
  <name>jdbc-driver-prod</name>

  <dependencies>