import oracle.jdbc.OracleConnection;

import oracle.jdbc.pool.OracleDataSource;

import java.sql.ResultSet;

import java.sql.Statement;

import java.sql.SQLException;

import java.util.Properties;

public class OracleOCI {

        public static void main(String[] args) {

                try {

                        // Set the connection properties.

                        // required: SYSDBA

                        Properties prop = new Properties();

                        // prop.setProperty("user","sys");

                        // prop.setProperty("password","password");

                        prop.setProperty("internal_logon", "sysdba");

                        String sql = "select banner from v$version";

                        OracleDataSource ods = new OracleDataSource();

                        ods.setConnectionProperties(prop);

                        ods.setURL("jdbc:oracle:oci8:@");

                        OracleConnection conn = (OracleConnection) ods.getConnection();

                        System.out.println("Connected");

                        Statement stmt = conn.createStatement();

                        ResultSet rs = stmt.executeQuery(sql);

                        while (rs.next()) {

                                System.out.println(rs.getString("banner"));

                        }

                        rs.close();

                        stmt.close();

                        conn.close();

                } catch (SQLException e) {

                        System.out.println(e.getMessage());

                }

        }

}