Databases supported by DBMaster

DBMaster is designed to work with virtually any relational database. Drivers and dialects are stored externally and can be added dynamically.

Tested Databases
Microsoft SQL Server 2005+
Oracle MySQL 5.1+

How to add a new database

Drivers are configured in file [dbmaster_home]/data/drivers.ini. It is necessary to restart dbmaster in order for modifications to be reloaded.

Driver configuration properties
Property Description
driver.[driver_key].name This name will be displayed to user in driver selection combobox.
driver.[driver_key].enabled Possible values for this parameter are true and false. When value is false driver will not be available for users.
driver.[driver_key].class Full qualified java class name of jdbc driver.
driver.[driver_key].url_format This is a help string displayed for users for connection url.
driver.[driver_key].dialect DBMaster will try to find a groovy script in file data\dialects\[dialect].groovy. Multiple drivers can refer to the same dialect. For example Microsoft, ODBC, and JTD drivers can refer to sqlserver dialect.
driver.[driver_key].property.[property_key].key Key will bed displayed to user and used in database driver.
driver.[driver_key].property.[property_key].value Optional 'default' value of the property. Can be overwritten by user.
driver.[driver_key].property.[property_key].description User-friendly description to help user to define property value.

Sample driver definition SQL Server
driver.mssql2008.dialect=sqlserver whether SSL encryption is used to encrypt data...

Implementing a dialect

Dialects for DBMaster are defined with Groovy language. A dialect must extend abstract com.branegy.dbmaster.connection.JDBCDialect class and define all methods for communicating with database.