HSQLDB is a relational database engine written in Java that is bundled with DatabaseLink, which also contains a JDBC driver and necessary configuration. It offers a small (about 100k), fast database engine, which can run in a variety of ways, including server, in‐process, and in‐memory modes. DatabaseLink is configured to use an in‐process standalone mode. This makes it very simple to run and use (no special configuration is required). However, it means that nothing else can connect to the database and only one connection to a particular database can be made at any one time (even by multiple copies of the Wolfram System).
Support for Microsoft SQL Server is provided by the jTDS driver. The jTDS driver is strongly recommended over ODBC for SQL Server applications.
The details of the SQL Server driver in DatabaseLink can be seen as follows.
To connect to a Microsoft SQL Server database, you would typically set the server, database, username, and password as in the following example.
For more information, see jtds.sourceforge.net, an open source driver for Microsoft SQL Server and Sybase.
Derby is an open source pure Java relational database maintained by the Apache Software Foundation, emphasizing small footprint and standards compliance. Derby operates in embedded and server modes. In embedded mode, as in HSQLDB, the engine is started by DatabaseLink and databases may be automatically created on connection.
The details of the Derby driver in DatabaseLink can be seen as follows.
To connect to a new Derby database, you would typically set the path to a directory along with a property directive for database creation.
H2 is an open source pure Java relational database emphasizing small footprint, performance, concurrency, and security. H2 runs in server, embedded, and in-memory modes. In the latter two modes, DatabaseLink starts the H2 engine and creates databases as necessary.
The details of the H2 driver in DatabaseLink can be seen as follows.
To connect to an embedded H2 database, you would typically set a path terminating in a stem that H2 will use to name its resource files.