Scarab - Database Independence

Using Torque, Scarab is able to connect to many different database types.

Some of the difference between databases cannot be completely handled using Torque, however.

One prime example is the initial data load. The default date format recognized by Oracle is inconsistent with the more commonly used date format recognized by several other databases including MySQL.

Another example is the ability to select a constant or a database function result separate from a database query. MySQL allows the following syntax: 

    SELECT 1

while Oracle requires a select statement to include a from clause, and supplies a system table called DUAL which contains only one row for use similar to the following: 

    SELECT 1 FROM DUAL

Database Configuration

The following properties in build.properties can be used to select and customize the database.

  • scarab.database.type

Data Load Configuration

The following properties in build.properties can be used to customize the database load.

  • scarab.database.loadorder
  • scarab.database.validationQuery
  • skip.seed.data
  • seed.data.sql