ODBC, JDBC, and proprietary programming interfaces

The solidDB server provides ODBC, JDBC and proprietary interfaces for clients. For more details, see Programming.

Compatibility	JDBC 2.0, with selected features of JDBC 2.0 Optional Package
Driver location	solidDB-install-dir/jdbc/SolidDriver2.0.jar
JDBC URL format	jdbc:solid://hostname:port/username/password[?property-name=value]... For example: jdbc:solid://localhost:1964/dba/dba
Driver class name	solid.jdbc.SolidDriver

The solidDB JDBC 2.0 driver supports the JDBC 2.0 specification. Additionally, connection pooling, JNDI data sources, and rowsets of the JDBC 2.0 Optional Package (known before as Standard Extension) are supported too.

Non-standard features include support for IBM WebSphere and timeout control extensions.

The following features of the Optional Package are currently supported by the solidDB JDBC 2.0 driver:

▪ JTA (Java Transaction API) – XA interface for Java (implements javax.transaction.xa.XAResource and javax.transaction.xa.Xid)

For full details about the solidDB JDBC driver see solidDB JDBC driver.

The solidDB JDBC driver supports the following non-standard extensions. For more information, see solidDB JDBC driver extensions.

You can set the connection property values in the URL string.

Connection timeout refers to the response timeout of any JDBC call that invokes data transmission over a connection socket. If the response message is not received within the time that is specified, an I/O exception is thrown. The JDBC standard (2.0/3.0) does not support setting of the connection timeout. The solidDB product has two ways for setting the timeout: one using a non-standard driver manager extension method and the other using the property mechanisms. The time unit in either case is 1 ms.

The timeout fires at the connect time. The setting is implemented with a connection property. The property overrides the login timeout for JDBC specified by other means (like login timeout parameter in the driver manager).

If the connection is inactive for the amount of time specified with the idle timeout property, the server closes the connection. The connection idle timeout property overrides the server parameter setting for the session.

You can set the size of the statement cache for a connection.

The solidDB JDBC driver fully supports solidDB Transparent Connectivity (TC) including transparent failover and load balancing. For more information about usage of TC, see Transparent Connectivity.

The SMA connection property defines that the driver connects to a SMA server with a local connection, bypassing network protocols.

You can set the catalog and schema names for the connection.

To support WebSphere, a data source adapter SolidDataStoreHelper is provided in a separate file SolidDataStoreHelper.jar, in the jdbc directory of the solidDB package.

solidDB provides two ODBC drivers, one for Unicode and one for ASCII character sets. For more information about these drivers, see solidDB ODBC API.

The following functions are not supported:

The solidDB ODBC driver incorporates several extensions, for example, for timeout controls, statement cache behavior, and support for Transparent Connectivity. For more information, see solidDB extensions for ODBC API.

The solidDB Application Programming Interface (SA API) and solidDB Server Control API (SSC API) allow, for example, C programs to directly call functions inside the database server. These proprietary interfaces are provided with the solidDB Shared Memory Access (SMA) and Linked Library Access (LLA) libraries.