borland Packages  Class Hierarchy  datastore.jdbc Package 

DataStoreDriver component

java.lang.Object
   +----com.borland.datastore.jdbc.DataStoreDriver

About the DataStoreDriver component

Constructors  Properties  Methods  

Implements Driver

DataStoreDriver is the JDBC driver for the DataStore. The driver supports both local and remote access. Both types of access require a user name (any string, with no setup required) and an empty password.

Local access provides exclusive, transactional, single-user access to a DataStore file that is accessible by the machine requesting the connection. Exclusive access means that the DataStore file cannot be opened by another process. You can open other connections from the same process, using another JDBC connection, the DataExpress API, or the DataStore API. The JDBC URL for local access is:

    jdbc:borland:dslocal:<filename>

Remote access requires a DataStore server. By routing all requests through a single DataStore server process, you get transactional multi-user access to a DataStore. The DataStore file must be accessible from the DataStore server. The JDBC URL for remote access is:

    jdbc:borland:dsremote://<hostname>/<filename>

For example, a simple JDBC local connection might look like:

    Class.forName( "com.borland.datastore.jdbc.DataStoreDriver" );
    Connection con = DriverManager.getConnection(
            "jdbc:borland:dslocal:c:/mydir/mystore.jds",
            "MyUserName", "" );

A remote connection using DataExpress might look like:

    ConnectionDescriptor con = new ConnectionDescriptor(
            "jdbc:borland:dsremote://MYSERVER/c:/serverdir/serverdb.jds",
            "MyUserName", "", false,
            "com.borland.datastore.jdbc.DataStoreDriver" );

Driver properties

The DataStore JDBC driver supports the following properties:

DataStore JDBC driver properties

Property name Value (all strings)
user Any name (no setup required)
password Password. There is no security with DataStoreDriver, so this should be an empty string.
port Port to connect on; the default is 2508.
readonly "true" or "false": whether to open the connection read-only.
lockWaitTime Time to wait for lock before aborting transaction, in milliseconds; default 10000 (10 seconds)

The following example gets a read-only connection on port 9876 using driver properties:

    Class.forName( "com.borland.datastore.jdbc.DataStoreDriver" );
    java.util.Properties info = new java.util.Properties();
    info.setProperty( "user"    , "MyUserName" );
    info.setProperty( "password", "" );
    info.setProperty( "port"    , "9876" );
    info.setProperty( "readonly", "true" );
    Connection con = DriverManager.getConnection(
            "jdbc:borland:dsremote://MYSERVER/c:/serverdir/serverdb.jds", info );

SQL support

DataStoreDriver supports a subset of the ANSI/ISO SQL-92 standard. In general, it provides:

For more details, see the DataStore SQL Reference.

DataStoreDriver constructors

DataStoreDriver properties

*Read-only properties **Write-only properties

Properties implemented in this class

Properties implemented in java.lang.Object

DataStoreDriver methods

Methods implemented in this class

Methods implemented in java.lang.Object


DataStoreDriver constructors

DataStoreDriver()

  public DataStoreDriver()
The DataStoreDriver constructor is usually not called directly. Typically, JDBC drivers register themselves with the JDBC driver manager when their class is loaded (for example, when using Class.forName).

DataStoreDriver properties

majorVersion

 public int getMajorVersion()
The part of the version number that indicates significant changes in the driver. For example, for version 1.02, the major version number is 1.

minorVersion

 public int getMinorVersion()
The part of the version number that indicates maintenance changes in the driver. For example, for version 1.02, the minor version number is 2.