Package oracle.pg.rdbms.pgql.jdbc

Class PgqlJdbcRdbmsDriver

  • All Implemented Interfaces:
    java.sql.Driver, oracle.jdbc.internal.Monitor
    public class PgqlJdbcRdbmsDriver
extends oracle.jdbc.OracleDriver
    JDBC Driver for PGQL on RDBMS. Example usage: 
     String jdbcUrl = "jdbc:oracle:pgql:@myhost:1521/myService";
 try (Connection conn = DriverManager.getConnection(jdbcUrl, "scott", "tiger")) {

   String query = "SELECT n.NAME FROM MATCH(n) ON test_graph WHERE id(n) = ?";

   try (PreparedStatement pstmt = conn.prepareStatement(query)) {
     pstmt.setLong(1, 10L);
     pstmt.execute();

     try (ResultSet rs = pstmt.getResultSet()) {
       while (rs.next()) {
         rs.getString("NAME");
       }
     }
   }
 }
    Since:
    21.2

    • Nested Class Summary

      • Nested classes/interfaces inherited from interface oracle.jdbc.internal.Monitor

        oracle.jdbc.internal.Monitor.CloseableLock, oracle.jdbc.internal.Monitor.WaitableMonitor

    • Field Summary

      • Fields inherited from class oracle.jdbc.driver.OracleDriver

        accumulate_batch_result, batch_string, convert_nchar_literals_string, database_string, dataSizeBytes, dataSizeChars, dataSizeUnitsPropertyName, default_execute_batch_string, default_row_prefetch_string, defaultnchar_string, defaultncharprop_string, disable_defineColumnType_string, dll_string, dms_parent_name_string, dms_parent_type_string, dms_stmt_caching_metrics_string, dms_stmt_metrics_string, execute_batch_string, fixed_string_string, include_synonyms_string, j2ee_compliance, jdbc_string, logon_as_internal_str, nls_lang_backdoor, no_caching_buffers, oracle_string, password_string, permit_timestamp_date_mismatch_string, prefetch_string, prelim_auth_string, process_escapes_string, protocol_string, proxy_client_name, read_timeout, remarks_string, report_remarks_string, restrict_getTables_string, retain_v9_bind_behavior_string, row_prefetch_string, server_string, set_new_password_string, SetFloatAndDoubleUseBinary_string, synonyms_string, systemTypeMap, tcp_no_delay, useFetchSizeWithLongColumn_prop_string, useFetchSizeWithLongColumn_string, user_string, v8compatible_string

    • Method Summary

      All Methods Static Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      boolean acceptsURL​(java.lang.String url)  
      java.sql.Connection connect​(java.lang.String url, java.util.Properties info)  
      static boolean isRegistered()  
      static void register()  

      • Methods inherited from class oracle.jdbc.OracleDriver

        getBuildDate, getDriverVersion, getJDBCVersion, isDebug, isDMS, isInServer, isPrivateDebug, main

      • Methods inherited from class oracle.jdbc.driver.OracleDriver

        _INTERNAL_ORACLE_connectAsync, connect, defaultConnection, getCompileTime, getExecutorService, getMajorVersion, getMinorVersion, getMonitorLock, getParentLogger, getPropertyInfo, getSystemPropertyDateZeroTime, getSystemPropertyDateZeroTimeExtra, getSystemPropertyFastConnectionFailover, jdbcCompliant, processSqlEscapes, registerMBeans, setExecutorService, unRegisterMBeans

      • Methods inherited from class java.lang.Object

        equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

      • Methods inherited from interface oracle.jdbc.internal.Monitor

        acquireCloseableLock, acquireLock, releaseLock

    • Constructor Detail

      • PgqlJdbcRdbmsDriver

        public PgqlJdbcRdbmsDriver()

    • Method Detail

      • register

        public static void register()
                     throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • isRegistered

        public static boolean isRegistered()

      • acceptsURL

        public boolean acceptsURL​(java.lang.String url)
                   throws java.sql.SQLException
        Specified by:
        acceptsURL in interface java.sql.Driver
        Overrides:
        acceptsURL in class oracle.jdbc.driver.OracleDriver
        Throws:
        java.sql.SQLException

      • connect

        public java.sql.Connection connect​(java.lang.String url,
                                   java.util.Properties info)
                            throws java.sql.SQLException
        Specified by:
        connect in interface java.sql.Driver
        Overrides:
        connect in class oracle.jdbc.driver.OracleDriver
        Throws:
        java.sql.SQLException