Configure the database driver

Genero Studio for Report Writer uses to test database connection and to create the
database meta-schema file. For Java implementations, Genero also uses JDBC to connect to the
database.

Note: The Genero environment is set up by default to use a JDBC driver for SQLite. Follow the
procedure below only if you want to change the defaults.

Download the JDBC driver for your database.

JDBC drivers are files with the extension .jar. They are usually provided
by the database software vendor.

Select Tools >> Genero Configurations.

Select the environment set, and update the CLASSPATH environment variable to include the path
to the JDBC driver.

For example, the default DB-SQLite environment set sets the CLASSPATH
environment variable to include the .jar package that contains the SQLite
database driver.

Example

To validate the configuration of the database driver, you must test by connecting to a
database. You will need to provide the database driver name and the connection string, and then use
the Test Connection functionality. Follow one of these procedures: