Example 5: Setting up a connection via Amazon RDS

Assume that:

You have already installed the JDBC driver, and have appended the archive file (mysql-connector-java-5.0.4-bin.jar) of the driver to the ADDCLASSPATH variable in the file setenv.bat in <designer_install_root>\bin.
The RDS database server is with the following information:
Driver: com.mysql.jdbc.Driver
URL: jdbc:mysql://jrdbtest.c4fb8hiicidz.us-west-2.rds.amazonaws.com:3306/sampledb1110 (The URL is dynamically generated when you apply an instance.)
User: dbadmin
Password: test1234
A catalog has been created with a default data source.

For details about how to install Amazon RDS, refer to Getting Started with Amazon RDS.

Take the following steps to set up a connection which connects JReport Designer to a database via Amazon RDS:

Start JReport Designer and open the catalog.
In the Data tab of the Catalog Browser, expand the node of the default data source, right-click the Relational node and select Add JDBC Connection from the shortcut menu.
In the Get JDBC Connection Information dialog, uncheck the Use ODBC Data Source option.
Check the Driver checkbox, and enter the JDBC driver class name com.mysql.jdbc.Driver in the Driver text field.
In the URL text field, specify the URL as jdbc:mysql://jrdbtest.c4fb8hiicidz.us-west-2.rds.amazonaws.com:3306/sampledb1110.
Input the user name dbadmin and password test1234 respectively.
Click OK to set up the connection.

Notes:

It is not recommended to use RDS for small data query since it costs longer time on the cloud.
The RDS MySQL database is case sensitive, which may result in that JReport sample reports cannot run.