If connecting to a named instance e.g. if you are using SQL Server 2008 Express, use a JDBC url like the following
jdbc:jtds:sqlserver://localhost/mydatabase;instance=SQLEXPRESS
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.
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
To migrate between different RDBMSs e.g. from a PostgreSQL database to a MySQL database, use an ETL tool e.g. Pentaho Data Integration
These steps illustrate the steps to migrate an ART repository database on PostgreSQL to MySQL.
Run the following statement on your destination database e.g. using HeidiSQL
update art_jobs set migrated_to_quartz='N'
The migration is done. You can now launch ART and define this new database as your ART repository.
These steps illustrate the steps to migrate the demo ART repository database (HSQLDB) to MySQL using Pentaho Data Integration.
art_
i.e. don't select the qrtz_xx tables. This is so that you don't run into foreign key constraint issues when you run the job.Run the following statement on your destination database
update art_jobs set migrated_to_quartz='N'
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.
jdbc:hsqldb:c:\my\ArtRepositoryDB
To deploy ART on JBoss 7, or WildFly, take the following steps.
localhost
, try using 127.0.0.1
.For more details about application deployment on JBoss 7, see https://docs.jboss.org/author/display/AS7/Application+deployment
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.
C:\windows\fonts\arialuni.ttf
and click on NextIdentity-H
would enable the display of text in most languages. You can select the option to Embed the font in the PDF document if your users may not have the font installed on their machines. This results in larger PDF files.C:\temp\arialuni.jar
Legend Font
etc. Preview the report in iReport to confirm that the report displays as desired. Ensure to also use the PDF Preview to confirm how pdf output will look like..jrxml
fileOn 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/