Setup for Additional Databases
If you are building the source code using a database other than PostgreSQL or MySQL, you can use the example settings below for Oracle, SQL Server, and DB2.
Download a JDBC Driver
You do not need a JDBC driver jar in order to build the source code. However, if you plan to build the source code and also populate the core data into the jasperserver repository database then you will need a JDBC driver.
You can download a JDBC driver appropriate for you database from one of the vendor sites listed below:
| • | http://www.oracle.com/technetwork/indexes/downloads (Oracle) |
| • | http://www.microsoft.com/en-us/download/details.aspx?id=11774 (SQL Server) |
| • | http://www-01.ibm.com/software/data/db2/linux-unix-windows/downloads.html (DB2) |
The downloaded JDBC jar should be copied into the following location:
| • | <js-src>/buildomatic/conf_source/db/<dbType>/jdbc |
For instance, for Oracle the driver would go here:
| • | <js-src>/buildomatic/conf_source/db/oracle/jdbc |
Additionally, in order to execute the database related steps (if desired), you will need to update your default_master.properties file to specify the name and version of the JDBC driver jar. To make this update, do the following (using Oracle as an example):
cd <js-src>/jasperserver/buildomatic
Edit default_master.properties
Uncomment these two properties:
# maven.jdbc.artifactId=ojdbc5
# maven.jdbc.version=11.2.0
If your Oracle JDBC driver is the following file name (for example):
ojdbc6-11.2.0.2.jar
Then set the two properties to the following values:
maven.jdbc.artifactId=ojdbc6
maven.jdbc.version=11.2.0.2
Oracle
| 1. | Go to the buildomatic directory in the source distribution: |
cd <js-src>/jasperserver/buildomatic
| 2. | Copy the Oracle specific file to the current directory and change its name to default_master.properties: |
| Windows: | copy sample_conforacle_master.properties default_master.properties |
| Linux: | cp sample_conf/oracle_master.properties default_master.properties |
| 3. | Edit the new default_master.properties file and set the following properties for your local environment: |
| Property | Examples |
| appServerType | |
| appServerDir | |
| sysUsername | |
| sysPassword | |
| dbUsername | |
| dbPassword | |
| dbHost | |
| maven
| maven = C:\apache-maven-3.0.4\bin\mvn.bat maven = /home/devuser/apache-maven-3.0.4/bin/mvn |
| js-path | |
| js-pro-path | |
| repo-path | repo-path = C:\jasperreports-server-5.6.0-src\jasperserver-repo[/code] repo-path = /home/<user>/jasperreports-server-5.6.0-src/jasperserver-repo[/code] |
SQL Server
| 1. | Go to the buildomatic directory in the source distribution: |
cd <js-src>/jasperserver/buildomatic
| 2. | Copy the SQL Server specific file to the current directory and change its name to default_master.properties: |
| Windows: | copy sample_confsqlserver_master.properties default_master.properties |
| Linux: | cp sample_conf/sqlserver_master.properties default_master.properties |
| 3. | Edit the new default_master.properties file and set the following properties for your local environment: |
| Property | Examples |
|---|---|
| appServerType | |
| appServerDir | |
| dbUsername | |
| dbPassword | |
| dbHost | |
| js-path | |
| js-pro-path | |
| repo-path | repo-path = C:\jasperreports-server-5.6.0-src\jasperserver-repo[/code] repo-path = /home/<user>/jasperreports-server-5.6.0-src/jasperserver-repo[/code] |
DB2
| 1. | Go to the buildomatic directory in the source distribution: |
cd <js-src>/jasperserver/buildomatic
| 2. | Copy the DB2 specific file to the current directory and change its name to default_master.properties: |
| Windows: | copy sample_confdb2_master.properties default_master.properties |
| Linux: | cp sample_conf/db2_master.properties ./default_master.properties |
| 3. | Edit the new default_master.properties file and set the following properties for your local environment: |
| Property | Examples |
| appServerType | |
| appServerDir | |
| dbUsername | |
| dbPassword | |
| dbHost | |
| js-path | |
| js-pro-path | |
| repo-path | repo-path = C:\jasperreports-server-5.6.0-src\jasperserver-repo[/code] repo-path = /home/<user>/jasperreports-server-5.6.0-src/jasperserver-repo[/code] |
Note: For DB2, the database must be created manually. This is because it is not possible to use a JDBC call to automatically create a database under DB2.
Recommended Comments
There are no comments to display.