| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
| <!--NewPage--> |
| <HTML> |
| <HEAD> |
| <!-- Generated by javadoc (build 1.6.0_20) on Sun Jun 06 23:05:46 EDT 2010 --> |
| <META http-equiv="Content-Type" content="text/html; charset=UTF-8"> |
| <TITLE> |
| JDBCDriver (HSQLDB 2.0.0 API) |
| </TITLE> |
| |
| <META NAME="date" CONTENT="2010-06-06"> |
| |
| <LINK REL ="stylesheet" TYPE="text/css" HREF="../../../javadoc.css" TITLE="Style"> |
| |
| <SCRIPT type="text/javascript"> |
| function windowTitle() |
| { |
| if (location.href.indexOf('is-external=true') == -1) { |
| parent.document.title="JDBCDriver (HSQLDB 2.0.0 API)"; |
| } |
| } |
| </SCRIPT> |
| <NOSCRIPT> |
| </NOSCRIPT> |
| |
| </HEAD> |
| |
| <BODY BGCOLOR="white" onload="windowTitle();"> |
| <HR> |
| |
| |
| <!-- ========= START OF TOP NAVBAR ======= --> |
| <A NAME="navbar_top"><!-- --></A> |
| <A HREF="#skip-navbar_top" title="Skip navigation links"></A> |
| <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY=""> |
| <TR> |
| <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> |
| <A NAME="navbar_top_firstrow"><!-- --></A> |
| <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY=""> |
| <TR ALIGN="center" VALIGN="top"> |
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD> |
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD> |
| <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD> |
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="class-use/JDBCDriver.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A> </TD> |
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD> |
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD> |
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD> |
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD> |
| </TR> |
| </TABLE> |
| </TD> |
| <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM> |
| </EM> |
| </TD> |
| </TR> |
| |
| <TR> |
| <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> |
| <A HREF="../../../org/hsqldb/jdbc/JDBCDataSourceFactory.html" title="class in org.hsqldb.jdbc"><B>PREV CLASS</B></A> |
| <A HREF="../../../org/hsqldb/jdbc/JDBCNClob.html" title="class in org.hsqldb.jdbc"><B>NEXT CLASS</B></A></FONT></TD> |
| <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> |
| <A HREF="../../../index.html?org/hsqldb/jdbc/JDBCDriver.html" target="_top"><B>FRAMES</B></A> |
| <A HREF="JDBCDriver.html" target="_top"><B>NO FRAMES</B></A> |
| <SCRIPT type="text/javascript"> |
| <!-- |
| if(window==top) { |
| document.writeln('<A HREF="../../../allclasses-noframe.html"><B>All Classes</B></A>'); |
| } |
| //--> |
| </SCRIPT> |
| <NOSCRIPT> |
| <A HREF="../../../allclasses-noframe.html"><B>All Classes</B></A> |
| </NOSCRIPT> |
| |
| |
| </FONT></TD> |
| </TR> |
| <TR> |
| <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> |
| SUMMARY: NESTED | FIELD | <A HREF="#constructor_summary">CONSTR</A> | <A HREF="#method_summary">METHOD</A></FONT></TD> |
| <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> |
| DETAIL: FIELD | <A HREF="#constructor_detail">CONSTR</A> | <A HREF="#method_detail">METHOD</A></FONT></TD> |
| </TR> |
| </TABLE> |
| <A NAME="skip-navbar_top"></A> |
| <!-- ========= END OF TOP NAVBAR ========= --> |
| |
| <HR> |
| <!-- ======== START OF CLASS DATA ======== --> |
| <H2> |
| <FONT SIZE="-1"> |
| org.hsqldb.jdbc</FONT> |
| <BR> |
| Class JDBCDriver</H2> |
| <PRE> |
| <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">java.lang.Object</A> |
| <IMG SRC="../../../resources/inherit.gif" ALT="extended by "><B>org.hsqldb.jdbc.JDBCDriver</B> |
| </PRE> |
| <DL> |
| <DT><B>All Implemented Interfaces:</B> <DD><A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Driver.html?is-external=true" title="class or interface in java.sql">Driver</A></DD> |
| </DL> |
| <HR> |
| <DL> |
| <DT><PRE>public class <B>JDBCDriver</B><DT>extends <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A><DT>implements <A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Driver.html?is-external=true" title="class or interface in java.sql">Driver</A></DL> |
| </PRE> |
| |
| <P> |
| Provides the java.sql.Driver interface implementation required by |
| the JDBC specification. <p> |
| |
| The Java SQL framework allows for multiple database drivers. <p> |
| |
| The DriverManager will try to load as many drivers as it can find and |
| then for any given connection request, it will ask each driver in turn |
| to try to connect to the target URL. <p> |
| |
| The application developer will normally not need to call any function of |
| the Driver directly. All required calls are made by the DriverManager. <p> |
| |
| <!-- start release-specific documentation --> |
| <div class="ReleaseSpecificDocumentation"> |
| <h3>HSQLDB-Specific Information:</h3> <p> |
| |
| When the HSQL Database Engine Driver class is loaded, it creates an |
| instance of itself and register it with the DriverManager. This means |
| that a user can load and register the HSQL Database Engine driver by |
| calling: |
| <pre> |
| <code>Class.forName("org.hsqldb.jdbc.JDBCDriver")</code> |
| </pre> |
| |
| For detailed information about how to obtain HSQLDB JDBC Connections, |
| please see <A HREF="../../../org/hsqldb/jdbc/JDBCConnection.html" title="class in org.hsqldb.jdbc"><CODE>JDBCConnection</CODE></A>.<p> |
| |
| <hr> |
| |
| <b>JRE 1.1.x Notes:</b> <p> |
| |
| In general, JDBC 2 support requires Java 1.2 and above, and JDBC3 requires |
| Java 1.4 and above. In HSQLDB, support for methods introduced in different |
| versions of JDBC depends on the JDK version used for compiling and building |
| HSQLDB.<p> |
| |
| Since 1.7.0, it is possible to build the product so that |
| all JDBC 2 methods can be called while executing under the version 1.1.x |
| <em>Java Runtime Environment</em><sup><font size="-2">TM</font></sup>. |
| However, in addition to this technique requiring explicit casts to the |
| org.hsqldb.jdbc.* classes, some of the method calls also require |
| <code>int</code> values that are defined only in the JDBC 2 or greater |
| version of the <A HREF="http://java.sun.com/javase/6/docs/api/java/sql/ResultSet.html?is-external=true" title="class or interface in java.sql"><CODE>ResultSet</CODE></A> interface. For this |
| reason, when the product is compiled under JDK 1.1.x, these values are |
| defined in <A HREF="../../../org/hsqldb/jdbc/JDBCResultSet.html" title="class in org.hsqldb.jdbc"><CODE>JDBCResultSet</CODE></A>. <p> |
| |
| In a JRE 1.1.x environment, calling JDBC 2 methods that take or return the |
| JDBC2-only <code>ResultSet</code> values can be achieved by referring |
| to them in parameter specifications and return value comparisons, |
| respectively, as follows: <p> |
| |
| <pre class="JavaCodeExample"> |
| JDBCResultSet.FETCH_FORWARD |
| JDBCResultSet.TYPE_FORWARD_ONLY |
| JDBCResultSet.TYPE_SCROLL_INSENSITIVE |
| JDBCResultSet.CONCUR_READ_ONLY |
| // etc. |
| </pre> |
| |
| However, please note that code written to use HSQLDB JDBC 2 features under |
| JDK 1.1.x will not be compatible for use with other JDBC 2 drivers. Please |
| also note that this feature is offered solely as a convenience to developers |
| who must work under JDK 1.1.x due to operating constraints, yet wish to |
| use some of the more advanced features available under the JDBC 2 |
| specification. <p> |
| |
| <hr> |
| |
| <b>JDBC 4.0 notes:</b><p> |
| |
| Starting with JDBC 4.0 (JDK 1.6), the <code>DriverManager</code> methods |
| <code>getConnection</code> and <code>getDrivers</code> have been |
| enhanced to support the Java Standard Edition Service Provider mechanism. |
| When built under a Java runtime that supports JDBC 4.0, HSQLDB distribution |
| jars containing the Driver implementation also include the file |
| <code>META-INF/services/java.sql.Driver</code>. This file contains the fully |
| qualified class name ('org.hsqldb.jdbc.JDBCDriver') of the HSQLDB implementation |
| of <code>java.sql.Driver</code>. <p> |
| |
| Hence, under JDBC 4.0 or greater, applications no longer need to explictly |
| load the HSQLDB JDBC driver using <code>Class.forName()</code>. Of course, |
| existing programs which do load JDBC drivers using |
| <code>Class.forName()</code> will continue to work without modification. <p> |
| |
| <hr> |
| <P> |
| |
| <P> |
| <DL> |
| <DT><B>Author:</B></DT> |
| <DD>Campbell Boucher-Burnett (boucherb@users dot sourceforge.net), Fred Toussi (fredt@users dot sourceforge.net)</DD> |
| <DT><B>See Also:</B><DD><A HREF="../../../org/hsqldb/jdbc/JDBCConnection.html" title="class in org.hsqldb.jdbc"><CODE>JDBCConnection</CODE></A></DL> |
| <HR> |
| |
| <P> |
| |
| <!-- ======== CONSTRUCTOR SUMMARY ======== --> |
| |
| <A NAME="constructor_summary"><!-- --></A> |
| <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> |
| <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> |
| <TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2"> |
| <B>Constructor Summary</B></FONT></TH> |
| </TR> |
| <TR BGCOLOR="white" CLASS="TableRowColor"> |
| <TD><CODE><B><A HREF="../../../org/hsqldb/jdbc/JDBCDriver.html#JDBCDriver()">JDBCDriver</A></B>()</CODE> |
| |
| <BR> |
| Default constructor</TD> |
| </TR> |
| </TABLE> |
| |
| <!-- ========== METHOD SUMMARY =========== --> |
| |
| <A NAME="method_summary"><!-- --></A> |
| <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> |
| <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> |
| <TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2"> |
| <B>Method Summary</B></FONT></TH> |
| </TR> |
| <TR BGCOLOR="white" CLASS="TableRowColor"> |
| <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
| <CODE> boolean</CODE></FONT></TD> |
| <TD><CODE><B><A HREF="../../../org/hsqldb/jdbc/JDBCDriver.html#acceptsURL(java.lang.String)">acceptsURL</A></B>(<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> url)</CODE> |
| |
| <BR> |
| Returns true if the driver thinks that it can open a connection to |
| the given URL.</TD> |
| </TR> |
| <TR BGCOLOR="white" CLASS="TableRowColor"> |
| <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
| <CODE> <A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A></CODE></FONT></TD> |
| <TD><CODE><B><A HREF="../../../org/hsqldb/jdbc/JDBCDriver.html#connect(java.lang.String, java.util.Properties)">connect</A></B>(<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> url, |
| <A HREF="http://java.sun.com/javase/6/docs/api/java/util/Properties.html?is-external=true" title="class or interface in java.util">Properties</A> info)</CODE> |
| |
| <BR> |
| Attempts to make a database connection to the given URL.</TD> |
| </TR> |
| <TR BGCOLOR="white" CLASS="TableRowColor"> |
| <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
| <CODE>static <A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A></CODE></FONT></TD> |
| <TD><CODE><B><A HREF="../../../org/hsqldb/jdbc/JDBCDriver.html#getConnection(java.lang.String, java.util.Properties)">getConnection</A></B>(<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> url, |
| <A HREF="http://java.sun.com/javase/6/docs/api/java/util/Properties.html?is-external=true" title="class or interface in java.util">Properties</A> info)</CODE> |
| |
| <BR> |
| The static equivalent of the <code>connect(String,Properties)</code> |
| method.</TD> |
| </TR> |
| <TR BGCOLOR="white" CLASS="TableRowColor"> |
| <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
| <CODE> int</CODE></FONT></TD> |
| <TD><CODE><B><A HREF="../../../org/hsqldb/jdbc/JDBCDriver.html#getMajorVersion()">getMajorVersion</A></B>()</CODE> |
| |
| <BR> |
| Gets the driver's major version number.</TD> |
| </TR> |
| <TR BGCOLOR="white" CLASS="TableRowColor"> |
| <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
| <CODE> int</CODE></FONT></TD> |
| <TD><CODE><B><A HREF="../../../org/hsqldb/jdbc/JDBCDriver.html#getMinorVersion()">getMinorVersion</A></B>()</CODE> |
| |
| <BR> |
| Gets the driver's minor version number.</TD> |
| </TR> |
| <TR BGCOLOR="white" CLASS="TableRowColor"> |
| <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
| <CODE> <A HREF="http://java.sun.com/javase/6/docs/api/java/sql/DriverPropertyInfo.html?is-external=true" title="class or interface in java.sql">DriverPropertyInfo</A>[]</CODE></FONT></TD> |
| <TD><CODE><B><A HREF="../../../org/hsqldb/jdbc/JDBCDriver.html#getPropertyInfo(java.lang.String, java.util.Properties)">getPropertyInfo</A></B>(<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> url, |
| <A HREF="http://java.sun.com/javase/6/docs/api/java/util/Properties.html?is-external=true" title="class or interface in java.util">Properties</A> info)</CODE> |
| |
| <BR> |
| Gets information about the possible properties for this driver.</TD> |
| </TR> |
| <TR BGCOLOR="white" CLASS="TableRowColor"> |
| <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
| <CODE> boolean</CODE></FONT></TD> |
| <TD><CODE><B><A HREF="../../../org/hsqldb/jdbc/JDBCDriver.html#jdbcCompliant()">jdbcCompliant</A></B>()</CODE> |
| |
| <BR> |
| Reports whether this driver is a genuine JDBC Compliant<sup><font |
| size=-2>TM</font></sup> driver.</TD> |
| </TR> |
| </TABLE> |
| <A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A> |
| <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> |
| <TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor"> |
| <TH ALIGN="left"><B>Methods inherited from class java.lang.<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A></B></TH> |
| </TR> |
| <TR BGCOLOR="white" CLASS="TableRowColor"> |
| <TD><CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#equals(java.lang.Object)" title="class or interface in java.lang">equals</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#getClass()" title="class or interface in java.lang">getClass</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#hashCode()" title="class or interface in java.lang">hashCode</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#notify()" title="class or interface in java.lang">notify</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#notifyAll()" title="class or interface in java.lang">notifyAll</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#toString()" title="class or interface in java.lang">toString</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#wait()" title="class or interface in java.lang">wait</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#wait(long)" title="class or interface in java.lang">wait</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#wait(long, int)" title="class or interface in java.lang">wait</A></CODE></TD> |
| </TR> |
| </TABLE> |
| |
| <P> |
| |
| <!-- ========= CONSTRUCTOR DETAIL ======== --> |
| |
| <A NAME="constructor_detail"><!-- --></A> |
| <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> |
| <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> |
| <TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2"> |
| <B>Constructor Detail</B></FONT></TH> |
| </TR> |
| </TABLE> |
| |
| <A NAME="JDBCDriver()"><!-- --></A><H3> |
| JDBCDriver</H3> |
| <PRE> |
| public <B>JDBCDriver</B>()</PRE> |
| <DL> |
| <DD>Default constructor |
| <P> |
| </DL> |
| |
| <!-- ============ METHOD DETAIL ========== --> |
| |
| <A NAME="method_detail"><!-- --></A> |
| <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> |
| <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> |
| <TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2"> |
| <B>Method Detail</B></FONT></TH> |
| </TR> |
| </TABLE> |
| |
| <A NAME="connect(java.lang.String, java.util.Properties)"><!-- --></A><H3> |
| connect</H3> |
| <PRE> |
| public <A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> <B>connect</B>(<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> url, |
| <A HREF="http://java.sun.com/javase/6/docs/api/java/util/Properties.html?is-external=true" title="class or interface in java.util">Properties</A> info) |
| throws <A HREF="http://java.sun.com/javase/6/docs/api/java/sql/SQLException.html?is-external=true" title="class or interface in java.sql">SQLException</A></PRE> |
| <DL> |
| <DD>Attempts to make a database connection to the given URL.<p> |
| |
| Returns "null" if this is the wrong kind of driver to connect to the |
| given URL. This will be common, as when the JDBC driver manager is asked |
| to connect to a given URL it passes the URL to each loaded driver in |
| turn. <p> |
| |
| <P>The driver throws an <code>SQLException</code> if it is the right |
| driver to connect to the given URL but has trouble connecting to |
| the database. <p> |
| |
| <P>The <code>java.util.Properties</code> argument can be used to pass |
| arbitrary string tag/value pairs as connection arguments. |
| Normally at least "user" and "password" properties should be |
| included in the <code>Properties</code> object. <p> |
| |
| <!-- start release-specific documentation --> |
| <div class="ReleaseSpecificDocumentation"> |
| <h3>HSQLDB-Specific Information:</h3> <p> |
| |
| For the HSQL Database Engine, at least "user" and |
| "password" properties should be included in the Properties.<p> |
| |
| From version 1.7.1, two optional properties are supported:<p> |
| |
| <ul> |
| <li><code>get_column_name</code> (default true) - if set to false, |
| a ResultSetMetaData.getColumnName() call will return the user |
| defined label (getColumnLabel()) instead of the column |
| name.<br/> |
| |
| This property is available in order to achieve |
| compatibility with certain non-HSQLDB JDBC driver |
| implementations.</li> |
| |
| <li><code>strict_md</code> if set to true, some ResultSetMetaData |
| methods return more strict values for compatibility |
| reasons.</li> |
| </ul> <p> |
| |
| From version 1.8.0.x, <code>strict_md</code> is deprecated (ignored) |
| because metadata reporting is always strict (JDBC-compliant), and |
| three new optional properties are supported: <p> |
| |
| <ul> |
| <li><code>ifexits</code> (default false) - when true, an exception |
| is raised when attempting to connect to an in-process |
| file: or mem: scheme database instance if it has not yet been |
| created. When false, an in-process file: or mem: scheme |
| database instance is created automatically if it has not yet |
| been created. This property does not apply to requests for |
| network or res: (i.e. files_in_jar) scheme connections. <li> |
| |
| <li><code>shutdown</code> (default false) - when true, the |
| the target database mimics the behaviour of 1.7.1 and older |
| versions. When the last connection to a database is closed, |
| the database is automatically shut down. The property takes |
| effect only when the first connection is made to the database. |
| This means the connection that opens the database. It has no |
| effect if used with subsequent, simultaneous connections. <br/> |
| |
| This command has two uses. One is for test suites, where |
| connections to the database are made from one JVM context, |
| immediately followed by another context. The other use is for |
| applications where it is not easy to configure the environment |
| to shutdown the database. Examples reported by users include |
| web application servers, where the closing of the last |
| connection conicides with the web app being shut down.</li> |
| |
| <li><code>default_schema</code> - backwards compatibility feature. |
| To be used for clients written before HSQLDB schema support. |
| Denotes whether to use the default schema when a schema |
| qualifier is not included in a database object's SQL identifier |
| character sequence. Also affects the semantics of |
| DatabaseMetaData calls that supply null-valued schemaNamePattern |
| parameter values.</li> |
| </ul> |
| |
| |
| </div> <!-- end release-specific documentation --> |
| <P> |
| <DD><DL> |
| <DT><B>Specified by:</B><DD><CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Driver.html?is-external=true#connect(java.lang.String, java.util.Properties)" title="class or interface in java.sql">connect</A></CODE> in interface <CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Driver.html?is-external=true" title="class or interface in java.sql">Driver</A></CODE></DL> |
| </DD> |
| <DD><DL> |
| <DT><B>Parameters:</B><DD><CODE>url</CODE> - the URL of the database to which to connect<DD><CODE>info</CODE> - a list of arbitrary string tag/value pairs as connection |
| arguments. Normally at least a "user" and "password" property |
| should be included. |
| <DT><B>Returns:</B><DD>a <code>Connection</code> object that represents a |
| connection to the URL |
| <DT><B>Throws:</B> |
| <DD><CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/sql/SQLException.html?is-external=true" title="class or interface in java.sql">SQLException</A></CODE> - if a database access error occurs</DL> |
| </DD> |
| </DL> |
| <HR> |
| |
| <A NAME="getConnection(java.lang.String, java.util.Properties)"><!-- --></A><H3> |
| getConnection</H3> |
| <PRE> |
| public static <A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> <B>getConnection</B>(<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> url, |
| <A HREF="http://java.sun.com/javase/6/docs/api/java/util/Properties.html?is-external=true" title="class or interface in java.util">Properties</A> info) |
| throws <A HREF="http://java.sun.com/javase/6/docs/api/java/sql/SQLException.html?is-external=true" title="class or interface in java.sql">SQLException</A></PRE> |
| <DL> |
| <DD>The static equivalent of the <code>connect(String,Properties)</code> |
| method. <p> |
| <P> |
| <DD><DL> |
| </DL> |
| </DD> |
| <DD><DL> |
| <DT><B>Parameters:</B><DD><CODE>url</CODE> - the URL of the database to which to connect<DD><CODE>info</CODE> - a list of arbitrary string tag/value pairs as connection |
| arguments including at least at a "user" and a "password" property |
| <DT><B>Returns:</B><DD>a <code>Connection</code> object that represents a |
| connection to the URL |
| <DT><B>Throws:</B> |
| <DD><CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/sql/SQLException.html?is-external=true" title="class or interface in java.sql">SQLException</A></CODE> - if a database access error occurs</DL> |
| </DD> |
| </DL> |
| <HR> |
| |
| <A NAME="acceptsURL(java.lang.String)"><!-- --></A><H3> |
| acceptsURL</H3> |
| <PRE> |
| public boolean <B>acceptsURL</B>(<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> url)</PRE> |
| <DL> |
| <DD>Returns true if the driver thinks that it can open a connection to |
| the given URL. Typically drivers will return true if they understand |
| the subprotocol specified in the URL and false if they don't. |
| <P> |
| <DD><DL> |
| <DT><B>Specified by:</B><DD><CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Driver.html?is-external=true#acceptsURL(java.lang.String)" title="class or interface in java.sql">acceptsURL</A></CODE> in interface <CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Driver.html?is-external=true" title="class or interface in java.sql">Driver</A></CODE></DL> |
| </DD> |
| <DD><DL> |
| <DT><B>Parameters:</B><DD><CODE>url</CODE> - the URL of the database |
| <DT><B>Returns:</B><DD>true if this driver can connect to the given URL</DL> |
| </DD> |
| </DL> |
| <HR> |
| |
| <A NAME="getPropertyInfo(java.lang.String, java.util.Properties)"><!-- --></A><H3> |
| getPropertyInfo</H3> |
| <PRE> |
| public <A HREF="http://java.sun.com/javase/6/docs/api/java/sql/DriverPropertyInfo.html?is-external=true" title="class or interface in java.sql">DriverPropertyInfo</A>[] <B>getPropertyInfo</B>(<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> url, |
| <A HREF="http://java.sun.com/javase/6/docs/api/java/util/Properties.html?is-external=true" title="class or interface in java.util">Properties</A> info)</PRE> |
| <DL> |
| <DD>Gets information about the possible properties for this driver. <p> |
| |
| The getPropertyInfo method is intended to allow a generic GUI tool |
| to discover what properties it should prompt a human for in order to |
| get enough information to connect to a database. Note that depending |
| on the values the human has supplied so far, additional values may |
| become necessary, so it may be necessary to iterate though several |
| calls to getPropertyInfo.<p> |
| |
| <!-- start release-specific documentation --> |
| <div class="ReleaseSpecificDocumentation"> |
| <h3>HSQLDB-Specific Information:</h3> <p> |
| |
| HSQLDB uses the values submitted in info to set the value for |
| each DriverPropertyInfo object returned. It does not use the default |
| value that it would use for the property if the value is null. <p> |
| |
| </div> <!-- end release-specific documentation --> |
| <P> |
| <DD><DL> |
| <DT><B>Specified by:</B><DD><CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Driver.html?is-external=true#getPropertyInfo(java.lang.String, java.util.Properties)" title="class or interface in java.sql">getPropertyInfo</A></CODE> in interface <CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Driver.html?is-external=true" title="class or interface in java.sql">Driver</A></CODE></DL> |
| </DD> |
| <DD><DL> |
| <DT><B>Parameters:</B><DD><CODE>url</CODE> - the URL of the database to which to connect<DD><CODE>info</CODE> - a proposed list of tag/value pairs that will be sent on |
| connect open |
| <DT><B>Returns:</B><DD>an array of DriverPropertyInfo objects describing possible |
| properties. This array may be an empty array if no properties |
| are required.</DL> |
| </DD> |
| </DL> |
| <HR> |
| |
| <A NAME="getMajorVersion()"><!-- --></A><H3> |
| getMajorVersion</H3> |
| <PRE> |
| public int <B>getMajorVersion</B>()</PRE> |
| <DL> |
| <DD>Gets the driver's major version number. |
| <P> |
| <DD><DL> |
| <DT><B>Specified by:</B><DD><CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Driver.html?is-external=true#getMajorVersion()" title="class or interface in java.sql">getMajorVersion</A></CODE> in interface <CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Driver.html?is-external=true" title="class or interface in java.sql">Driver</A></CODE></DL> |
| </DD> |
| <DD><DL> |
| |
| <DT><B>Returns:</B><DD>this driver's major version number</DL> |
| </DD> |
| </DL> |
| <HR> |
| |
| <A NAME="getMinorVersion()"><!-- --></A><H3> |
| getMinorVersion</H3> |
| <PRE> |
| public int <B>getMinorVersion</B>()</PRE> |
| <DL> |
| <DD>Gets the driver's minor version number. |
| <P> |
| <DD><DL> |
| <DT><B>Specified by:</B><DD><CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Driver.html?is-external=true#getMinorVersion()" title="class or interface in java.sql">getMinorVersion</A></CODE> in interface <CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Driver.html?is-external=true" title="class or interface in java.sql">Driver</A></CODE></DL> |
| </DD> |
| <DD><DL> |
| |
| <DT><B>Returns:</B><DD>this driver's minor version number</DL> |
| </DD> |
| </DL> |
| <HR> |
| |
| <A NAME="jdbcCompliant()"><!-- --></A><H3> |
| jdbcCompliant</H3> |
| <PRE> |
| public boolean <B>jdbcCompliant</B>()</PRE> |
| <DL> |
| <DD>Reports whether this driver is a genuine JDBC Compliant<sup><font |
| size=-2>TM</font></sup> driver. A driver may only report |
| <code>true</code> here if it passes the JDBC compliance tests; otherwise |
| it is required to return <code>false</code>. <p> |
| |
| JDBC compliance requires full support for the JDBC API and full support |
| for SQL 92 Entry Level. <p> |
| |
| <!-- start release-specific documentation --> |
| <div class="ReleaseSpecificDocumentation"> |
| <h3>HSQLDB-Specific Information:</h3> <p> |
| |
| HSQLDB 2.0 is aimed to be compliant with JDBC 4.0 specification. |
| It supports SQL 92 Entry Level and beyond. |
| </div> <!-- end release-specific documentation --> |
| |
| This method is not intended to encourage the development of non-JDBC |
| compliant drivers, but is a recognition of the fact that some vendors |
| are interested in using the JDBC API and framework for lightweight |
| databases that do not support full database functionality, or for |
| special databases such as document information retrieval where a SQL |
| implementation may not be feasible. |
| <P> |
| <DD><DL> |
| <DT><B>Specified by:</B><DD><CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Driver.html?is-external=true#jdbcCompliant()" title="class or interface in java.sql">jdbcCompliant</A></CODE> in interface <CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/sql/Driver.html?is-external=true" title="class or interface in java.sql">Driver</A></CODE></DL> |
| </DD> |
| <DD><DL> |
| |
| <DT><B>Returns:</B><DD><code>true</code> if this driver is JDBC Compliant; |
| <code>false</code> otherwise</DL> |
| </DD> |
| </DL> |
| <!-- ========= END OF CLASS DATA ========= --> |
| <HR> |
| |
| |
| <!-- ======= START OF BOTTOM NAVBAR ====== --> |
| <A NAME="navbar_bottom"><!-- --></A> |
| <A HREF="#skip-navbar_bottom" title="Skip navigation links"></A> |
| <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY=""> |
| <TR> |
| <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> |
| <A NAME="navbar_bottom_firstrow"><!-- --></A> |
| <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY=""> |
| <TR ALIGN="center" VALIGN="top"> |
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD> |
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD> |
| <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD> |
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="class-use/JDBCDriver.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A> </TD> |
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD> |
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD> |
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD> |
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD> |
| </TR> |
| </TABLE> |
| </TD> |
| <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM> |
| </EM> |
| </TD> |
| </TR> |
| |
| <TR> |
| <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> |
| <A HREF="../../../org/hsqldb/jdbc/JDBCDataSourceFactory.html" title="class in org.hsqldb.jdbc"><B>PREV CLASS</B></A> |
| <A HREF="../../../org/hsqldb/jdbc/JDBCNClob.html" title="class in org.hsqldb.jdbc"><B>NEXT CLASS</B></A></FONT></TD> |
| <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> |
| <A HREF="../../../index.html?org/hsqldb/jdbc/JDBCDriver.html" target="_top"><B>FRAMES</B></A> |
| <A HREF="JDBCDriver.html" target="_top"><B>NO FRAMES</B></A> |
| <SCRIPT type="text/javascript"> |
| <!-- |
| if(window==top) { |
| document.writeln('<A HREF="../../../allclasses-noframe.html"><B>All Classes</B></A>'); |
| } |
| //--> |
| </SCRIPT> |
| <NOSCRIPT> |
| <A HREF="../../../allclasses-noframe.html"><B>All Classes</B></A> |
| </NOSCRIPT> |
| |
| |
| </FONT></TD> |
| </TR> |
| <TR> |
| <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> |
| SUMMARY: NESTED | FIELD | <A HREF="#constructor_summary">CONSTR</A> | <A HREF="#method_summary">METHOD</A></FONT></TD> |
| <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> |
| DETAIL: FIELD | <A HREF="#constructor_detail">CONSTR</A> | <A HREF="#method_detail">METHOD</A></FONT></TD> |
| </TR> |
| </TABLE> |
| <A NAME="skip-navbar_bottom"></A> |
| <!-- ======== END OF BOTTOM NAVBAR ======= --> |
| |
| <HR> |
| <i>Copyright © 2001 - 2009 HSQL Development Group.</i> |
| </BODY> |
| </HTML> |