1. Using the jTDS driver
  2. Migrating the ART Database
    1. Migrating between the same RDBMS
    2. Migrating between different RDBMSs
      1. Using Pentaho Data Integration
      2. Migrating the demo database
  3. Upgrading a HSQLDB database
  4. Deployment on JBoss 7
  5. Using custom fonts in JasperReports
  6. Strange characters with charts

Using the jTDS driver

Migrating the ART Database

ART doesn't provide any in-built tools to migrate the repository from one database to another. The following are suggested techniques for such a migration.

Migrating between the same RDBMS

To migrate between the same RDBMS e.g. from a MySQL database to another MySQL database, use the backup/restore tools provided for your RDBMS

Migrating between different RDBMSs

To migrate between different RDBMSs e.g. from a PostgreSQL database to a MySQL database, use an ETL tool e.g. Pentaho Data Integration

Using Pentaho Data Integration

These steps illustrate the steps to migrate an ART repository database on PostgreSQL to MySQL.

The migration is done. You can now launch ART and define this new database as your ART repository.

Migrating the demo database

These steps illustrate the steps to migrate the demo ART repository database (HSQLDB) to MySQL using Pentaho Data Integration.

Upgrading a HSQLDB database

If you are upgrading your ART installation and are using a hsqldb database for the art repository, you can use the SQuirrel SQL Client to run the upgrade scripts to update your repository.

Deployment on JBoss 7

To deploy ART on JBoss 7, or WildFly, take the following steps.

For more details about application deployment on JBoss 7, see https://docs.jboss.org/author/display/AS7/Application+deployment

Using custom fonts in JasperReports

If you want to use custom fonts in a jasper report, take the following steps to ensure the text is displayed correctly, especially in pdf view mode.

Strange characters with charts

On a linux server, if you have strange characters displayed for a Chart report type, try and install msttcorefonts. See https://sourceforge.net/p/art/discussion/352129/thread/b3b80ead/