The Bridge uses a generic SQL Database Management System (DBMS) adapter that works with the following DBMSs:
DB2
Informix
InterBase
MySQL
Oracle
PostgreSQL
SQLBase
SQLite
SQLServer
Sybase
The Bridge also supports MongoDB with a dedicated adapter. See MongoDB Adapter for more details.
Preliminary Notes
It is of crucial importance to note that all these databases are accessed via the same adapter. The actual database configuration is described in the component only (see chapter SQL Deployment). This facilitates the management and redirecting of logically equivalent SQL statements to different databases.
ODBC Support
Additionally, the Bridge supports the ODBC protocol. Note, that some ODBC drivers have the constraint that only one BLOB is allowed per table. Additionally, the blob type may be defined as last column only. To evade such constraints, use native database drivers whenever possible (see example model odbc.xml referenced below).