Oracle ADWへのJavaからの接続

ほぼサンプルプログラムのまんまですが...

JDBCに必要なjarは

ojdbc8.jar
ucp.jar
oraclepki.jar
osdt_core.jar
osdt_cert.jar

の５つ

これを IntelliJの External Libraryに追加し、下記をコンパイル 

package com.hatenablog.gikoha;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

import oracle.jdbc.pool.OracleDataSource;
import oracle.jdbc.OracleConnection;
import java.sql.DatabaseMetaData;

public class Main {

    public static void main(String[] args) throws SQLException {
        try {

            Class.forName("oracle.jdbc.driver.OracleDriver");

        } catch (ClassNotFoundException e) {

            System.out.println("Where is your Oracle JDBC Driver?");
            e.printStackTrace();
            return;

        }

        System.out.println("Connecting...");

        Properties info = new Properties();
        info.put(OracleConnection.CONNECTION_PROPERTY_USER_NAME, "admin");
        info.put(OracleConnection.CONNECTION_PROPERTY_PASSWORD, “tigerXXXXmask”);
        info.put(OracleConnection.CONNECTION_PROPERTY_DEFAULT_ROW_PREFETCH, "20");

        OracleDataSource ods = new OracleDataSource();
        ods.setURL("jdbc:oracle:thin:@YOURDB_tp");
        ods.setConnectionProperties(info);

        Connection connection = null;

        try
        {

            connection = ods.getConnection();
        } catch (SQLException e) {
            System.out.println("Connection Failed! Check output console");
            e.printStackTrace();
            return;
        }

        try (Statement statement = connection.createStatement())
        {
            try (ResultSet resultSet = statement
                    .executeQuery("select sysdate from dual"))
            {
                while (resultSet.next())
                    System.out.println(resultSet.getString(1));
            }
        }

    }
    

}

実行結果

Connecting...
2020-06-02 11:21:31

jarで起動するときは、

java -cp oracleJDBCtest.jar:ojdbc8.jar:oraclepki.jar:ucp.jar:osdt_cert.jar:osdt_core.jar com.hatenablog.gikoha.Main