JDBC Drivers

DSQL uses the JDBC protocol to communicate with databases, which makes most major databases available. The drivers functionalities are defined in dbmsdefs.sql.

Drivers defined in DSQL

IdAvailabilityDistribution Supported Databases
Connector/Jv3.0.8 included in DSQLMySQL (GPL) MySQL
JDBC-ODBC-Bridgewith the JRESun (JDK) Any ODBC source: SQL Server, Access, MySQL, etc.
Free-TDSv2.0 included in DSQL FreeTDS.org (Open Source) MS SQL, Sybase
jTDSv0.5.1 included in DSQLSourceForge.net MS SQL, Sybase
MSSQL microsoft.com Microsoft MS SQL, Sybase

Note: other drivers can be added in dbmsdefs.sql.

Drivers parameters

The following table shows the parameters to include in a connect element. (also defined in dbmsdefs.sql)

Connector/J <hostname>, <port> (optional), <dbname>, <username>, <password>
JDBC-ODBC-Bridge <dsn>, <username>, <password>
Free-TDS <hostname>, <port> (optional), <dbname>, <username>, <password>
jTDS <hostname>, <port> (optional), <dbname>, <username>, <password>
MSSQL <hostname>, <port> (optional), <dbname>, <username>, <password>

Compatibility issues

The following driver issues are automatically handled by DSQL.

IdIssueResolution in DSQL
Free-TDS does not support backward scrolling resend the query if a request is made for a previous record
jTDS claims to have some scroll support, but the result sets are forward only check that the results sets actually support backward scrolling; if not, handle as Free-TDS
JDBC-ODBC-Bridge requires the columns to be read in the same order as they appear in the query (only on Windows?) check if this is the case the first time a result is read with this driver; if so cache columns as they are read