You can use the example settings below for Oracle, SQL Server, and DB2.
Get Your JDBC Driver
You can choose to use the provided TIBCO JDBC driver or download a native JDBC Driver. By default, deploy-tibco-drivers is set to false.
Use the TIBCO JDBC Driver:
Copy the driver from:
tibco-driver-repo/tibcosoftwareinc/jdbc/TI<dbtype>-driver/<version>/TI<dbtype>-driver-<version>.jar
to:
jasperserver/buildomatic/conf_source/db/<dbtype>/jdbc
Configure default_master.properties.
For example, for SQL Server, you'd copy the driver from:
tibco-driver-repo/tibcosoftwareinc/jdbc/TIsqlserver-driver/5.14/TIsqlserver-driver-5.14.jar
to
jasperserver/buildomatic/conf_source/db/sqlserver/jdbc
Download a JDBC Driver:
You can download a JDBC driver appropriate for your database. In this case, additional configurations are required. You can download a JDBC driver from one of these vendor sites:
| • | 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) |
Copy the downloaded JDBC jar to the following location:
| • | <js-src>/buildomatic/conf_source/db/<dbType>/native.jdbc |
For example, for SQL Server the driver would go here:
| • | <js-src>/buildomatic/conf_source/db/sqlserver/native.jdbc |
Set Up Your Database
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. | Open the new default_master.properties file for editing. |
| 4. | Set the following properties for your local environment: |
| Property | Examples |
| appServerType | |
| appServerDir | appServerDir = /home/<user>/apache-tomcat-7.0.26[/code] |
| sysUsername | |
| sysPassword | |
| dbUsername | |
| dbPassword | |
| dbHost | |
| maven | maven = C:\apache-maven-3.0.4\bin\mvn.bat[/code] maven = /home/<user>/apache-maven-3.0.4/bin/mvn[/code] |
| js-path | |
| js-pro-path | |
| repo-path | repo-path = C:\jasperreports-server-6.2.1-src\jasperserver-repo[/code]repo-path = /home/<user>/jasperreports-server-6.2.1-src/jasperserver-repo[/code] |
| deploy-tibco-drivers | deploy-tibco-drivers = true |
| tibco-driver-path | tibco-driver-path = C:\jasperreports-server-6.2.1-src\tibco-driver-repo tibco-driver-path = /home/<user>/jasperreports-server-6.2.1-src/tibco-driver-repo |
| 5. | If you use native drivers instead of TIBCO drivers, follow the instructions to uncomment the required properties and enable your driver. The following example shows how to set up default_master.properties to point to a driver named ojdbc6-11.2.0.3.jar using SID: |
# 1) Setup Standard Oracle JDBC Driver## Uncomment and modify the value to nativejdbcDriverMaker=native## Uncomment and modify the value in order to change the default# 1a) Driver will be found here: <path>/buildomatic/conf_source/db/oracle/native.jdbc#maven.jdbc.groupId=oraclemaven.jdbc.artifactId=ojdbc6maven.jdbc.version=11.2.0. [/code] |
| 6. | Save the default_master.properties file. |
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 | appServerDir = /home/<user>/apache-tomcat-7.0.26[/code] |
| dbUsername | |
| dbPassword | |
| dbHost | |
| js-path | |
| js-pro-path | |
| repo-path | repo-path = C:\jasperreports-server-6.2.1-src\jasperserver-repo[/code]repo-path = /home/<user>/jasperreports-server-6.2.1-src/jasperserver-repo[/code] |
| deploy-tibco-drivers | deploy-tibco-drivers = true |
| tibco-driver-path | tibco-driver-path = C:\jasperreports-server-6.2.1-src\tibco-driver-repo tibco-driver-path = /home/<user>/jasperreports-server-6.2.1-src/tibco-driver-repo |
| 4. | If you use native drivers instead of TIBCO drivers, uncomment the required properties and enable your driver. The following example shows how to set up default_master.properties to point to a driver named sqljdbc-1.6.jar: |
# 1) Setup Standard SQLServer JDBC Driver## Uncomment and modify the value to nativejdbcDriverMaker=native## Uncomment and modify the value in order to change the default# Driver will be found here: <path>/buildomatic/conf_source/db/sqlserver/native.jdbc#maven.jdbc.groupId=sqlservermaven.jdbc.artifactId=sqljdbcmaven.jdbc.version=1.6[/code] |
| 5. | Save the default_master.properties file. |
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 | appServerDir = /home/<user>/apache-tomcat-7.0.26[/code] |
| dbUsername | |
| dbPassword | |
| dbHost | |
| js-path | |
| js-pro-path | |
| repo-path | repo-path = C:\jasperreports-server-6.2.1-src\jasperserver-repo[/code]repo-path = /home/<user>/jasperreports-server-6.2.1-src/jasperserver-repo[/code] |
| deploy-tibco-drivers | deploy-tibco-drivers = true |
| tibco-driver-path | tibco-driver-path = C:\jasperreports-server-6.2.1-src\tibco-driver-repo tibco-driver-path = /home/<user>/jasperreports-server-6.2.1-src/tibco-driver-repo |
| 4. | If you use native drivers instead of TIBCO drivers, uncomment the required properties and enable your driver. |
# 1) Setup Standard DB2 JDBC Driver## Uncomment and modify the value to nativejdbcDriverMaker=native## Uncomment and modify the value in order to change the default# Driver will be found here: <path>/buildomatic/conf_source/db/db2/native.jdbc#maven.jdbc.groupId=ibmmaven.jdbc.artifactId=db2jccmaven.jdbc.version=9.7[/code] |
| 5. | Add the following additional properties, setting the correct values for your installation. For example: |
| 6. | Save the default_master.properties file. |
Note: For DB2, the database must be created manually, because it is not possible to use a JDBC call to automatically create a database on DB2.
Recommended Comments
There are no comments to display.