public class PgqlJdbcRdbmsDriver
extends oracle.jdbc.OracleDriver
String jdbcUrl = "jdbc:oracle:pgql:@<host>:<port>/<service_name>";
try (Connection conn = DriverManager.getConnection(jdbcUrl, "userName", "password")) {
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");
}
}
}
}
access_string, 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, 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, protocolFullName_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, xa_trans_loose| Constructor and Description |
|---|
PgqlJdbcRdbmsDriver() |
| Modifier and Type | Method and Description |
|---|---|
boolean |
acceptsURL(java.lang.String url) |
java.sql.Connection |
connect(java.lang.String url, java.util.Properties info) |
static boolean |
isRegisterd() |
static void |
register() |
getBuildDate, getDriverVersion, getJDBCVersion, isDebug, isDMS, isInServer, isJDK14, isPrivateDebug, maindefaultConnection, getCompileTime, getMajorVersion, getMinorVersion, getParentLogger, getPropertyInfo, getSystemPropertyDateZeroTime, getSystemPropertyFastConnectionFailover, jdbcCompliant, processSqlEscapes, registerMBeans, unRegisterMBeanspublic boolean acceptsURL(java.lang.String url)
throws java.sql.SQLException
acceptsURL in interface java.sql.DriveracceptsURL in class oracle.jdbc.driver.OracleDriverjava.sql.SQLExceptionpublic java.sql.Connection connect(java.lang.String url,
java.util.Properties info)
throws java.sql.SQLException
connect in interface java.sql.Driverconnect in class oracle.jdbc.driver.OracleDriverjava.sql.SQLExceptionpublic static boolean isRegisterd()
public static void register()
throws java.sql.SQLException
java.sql.SQLException