Nonstop Database, HiRDB Version 9 UAP Development Guide
The Driver interface provides the following principal functions:
The table below lists the methods of the Driver interface. The interface does not support methods that are not listed in the table. If an unsupported method is specified, the interface throws an SQLException.
Table 18-7 Driver interface methods
Subsection | Method | Function |
---|---|---|
(a) | acceptsURL(String url) | Checks whether the driver can connect to the specified URL. |
(b) | connect(String url, Properties info) | Attempts database connection to the specified URL. |
(c) | getMajorVersion() | Acquires the driver's major version. |
(d) | getMinorVersion() | Acquires the driver's minor version. |
(e) | getPropertyInfo(String url, Properties info) | Acquires information about the driver's valid properties. |
(f) | jdbcCompliant() | Reports whether the driver is JDBC CompliantTM. |
public boolean acceptsURL(String url) throws SQLException
public Connection connect(String url, Properties info) throws SQLException
public synchronized int getMajorVersion()
public synchronized int getMinorVersion()
public synchronized DriverPropertyInfo[] getPropertyInfo(String url, Properties info) throws SQLException
Table 18-8 Settings for fields of DriverPropertyInfo
Property name | DriverPropertyInfo field | ||||
---|---|---|---|---|---|
name | value | description | required | choices | |
user | Same as the property name | null | "UserID" | false | null |
password | ditto | "" | "Password" | false | null |
UAPNAME | ditto | "" | "UAPNAME" | false | null |
JDBC_IF | ditto | "OFF" | "JDBC Interface Trace" | false | {"ON","OFF"} |
TRC_NO | ditto | "500" | "Trace Entry Number" | false | null |
ENCODELANG | ditto | null | "Encode Lang" | false | null |
HIRDB_CURSOR | ditto | "FALSE" | "HiRDB Cursor across commit" | false | null |
LONGVARBINARY_ACCESS | ditto | "REAL" | "Longvarbinary locator access" | false | null |
HiRDB_for_Java_SQL_IN_NUM | ditto | "300" | "SQL In Number" | false | null |
HiRDB_for_Java_SQL_OUT_NUM | ditto | "300" | "SQL Out Number" | false | null |
HiRDB_for_Java_SQLWARNING_LEVEL | ditto | "SQLWARN" | "SQL Warning Level" | false | null |
HiRDB_for_Java_ENV_VARIABLES | ditto | null | "HiRDB Environment Variables" | false | null |
HiRDB_for_Java_STATEMENT_COMMIT_BEHAVIOR | ditto | "TRUE" | "HiRDB Statement across commit" | false | {"TRUE","FALSE"} |
HiRDB_for_Java_LONGVARBINARY_ACCESS_SIZE | ditto | 0 | "Longvarbinary locator access size" | false | null |
HiRDB_for_Java_MAXBINARYSIZE | ditto | null | "Longvarbinary maximum binary size" | false | null |
HiRDB_for_Java_LONGVARBINARY_TRUNCERROR | ditto | "TRUE" | "Longvarbinary truncate error" | false | {"TRUE","FALSE"} |
HiRDB_for_Java_DBID | ditto | null | "Port number of HiRDB server or Environment variable group of HiRDB" | false | null |
HiRDB_for_Java_DBHOST | ditto | null | "Host name with HiRDB" | false | null |
HiRDB_for_Java_HiRDB_INI | ditto | null | "HiRDB.ini file " | false | null |
HiRDB_for_Java_BATCHEXCEPTION_BEHAVIOR | ditto | "TRUE" | "BatchUpdateException UpdateCounts that conforms to JDBC standard" | false | {"TRUE","FALSE"} |
SQLWARNING_IGNORE | ditto | "FALSE" | "Warning generated by the Connection object is not maintained with the Connection object" | false | {"TRUE","FALSE"} |
XDSHOST | ditto | null | "Host name of XDS" | false | null |
XDSPORT | ditto | null | "Port number of XDS" | false | null |
XDSSRVTYPE | ditto | "WS" | "Server type of XDS" | false | {"PC","WS"} |
HiRDB_for_Java_STATEMENT_CLOSE_BEHAVIOR | ditto | "FALSE" | "HiRDB Statement close behavior" | false | {"TRUE","FALSE"} |
public synchronized boolean jdbcCompliant()
The names of the package and class for installing this interface are as follows:
The part enclosed in curly brackets ({ }) in SQL statements is called the escape clause. An escape clause consists of a keyword and parameters. The keyword is not case sensitive.
The following table lists the escape clauses.
Table 18-9 List of escape clauses
Type of escape clause | Keyword |
---|---|
Date, time, timestamp | d, t, ts |
LIKE escape character | escape |
Outer join | oj |
Procedure call | call |
Scalar function | fn |
Assignment | set |
For details about the scalar functions that can be specified in an escape clause, see Appendix I. Scalar Functions That Can Be Specified in the Escape Clause.
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.