Source Build Setup for Other Databases

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_conf\oracle_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

appServerType=tomcat8 (or tomcat5/6/7, jboss, or glassfish2/3)

appServerDir

appServerDir = C:\\Program Files\\Apache Software Foundation\\Tomcat 7.0appServerDir = /home/<user>/apache-tomcat-7.0.26

sysUsername

sysUsername=system

sysPassword

sysPassword=password

dbUsername

dbUsername=jasperserver

dbPassword

dbPassword=password

dbHost

<span class="Code">dbHost=localhost</span>
maven maven = C:\\apache-maven-3.0.4\\bin\\mvn.batmaven = /home/<user>/apache-maven-3.0.4/bin/mvn

js-path

js-path = C:\\jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src\\jasperserverjs-path = /home/<user>/jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src/jasperserver

js-pro-path

js-pro-path = C:\\jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src\\jasperserver-projs-pro-path = /home/<user>/jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src/jasperserver-pro

repo-path

repo-path = C:\\jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src\\jasperserver-reporepo-path = /home/<user>/jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src/jasperserver-repo
deploy-tibco-drivers deploy-tibco-drivers = true
tibco-driver-path

tibco-driver-path = C:\\jasperreports-server-6.3.0-src\\tibco-driver-repo

tibco-driver-path = /home/<user>/jasperreports-server-6.3.0-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 native
jdbcDriverMaker=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=oracle
maven.jdbc.artifactId=ojdbc6
maven.jdbc.version=11.2.0.					
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_conf\sqlserver_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

appServerType=tomcat8 (or tomcat5/6/7, jboss, or glassfish2/3)

appServerDir

appServerDir = C:\\Program Files\\Apache Software Foundation\\Tomcat 7.0appServerDir = /home/<user>/apache-tomcat-7.0.26

dbUsername

<span class="Code">dbUsername=sa</span>

dbPassword

<span class="Code">dbPassword=sa</span>

dbHost

<span class="Code">dbHost=localhost</span>

js-path

js-path = C:\\jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src\\jasperserverjs-path = /home/<user>/jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src/jasperserver

js-pro-path

js-pro-path = C:\\jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src\\jasperserver-projs-pro-path = /home/<user>/jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src/jasperserver-pro

repo-path

repo-path = C:\\jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src\\jasperserver-reporepo-path = /home/<user>/jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src/jasperserver-repo
deploy-tibco-drivers deploy-tibco-drivers = true
tibco-driver-path

tibco-driver-path = C:\\jasperreports-server-6.3.0-src\\tibco-driver-repo

tibco-driver-path = /home/<user>/jasperreports-server-6.3.0-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 native
jdbcDriverMaker=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=sqlserver
maven.jdbc.artifactId=sqljdbc
maven.jdbc.version=1.6
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_conf\db2_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

appServerType=tomcat8 (or tomcat5/6/7, jboss, or glassfish2/3)

appServerDir

appServerDir = C:\\Program Files\\Apache Software Foundation\\Tomcat 7.0appServerDir = /home/<user>/apache-tomcat-7.0.26

dbUsername

<span class="Code">dbUsername=db2admin</span>

dbPassword

<span class="Code">dbPassword=password</span>

dbHost

<span class="Code">dbHost=localhost</span>

js-path

js-path = C:\\jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src\\jasperserverjs-path = /home/<user>/jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src/jasperserver

js-pro-path

js-pro-path = C:\\jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src\\jasperserver-projs-pro-path = /home/<user>/jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src/jasperserver-pro

repo-path

repo-path = C:\\jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src\\jasperserver-reporepo-path = /home/<user>/jasperreports-server-<span class="JasperBookVariablesBookSourceVersion">6.3.0</span>-src/jasperserver-repo
deploy-tibco-drivers deploy-tibco-drivers = true
tibco-driver-path

tibco-driver-path = C:\\jasperreports-server-6.3.0-src\\tibco-driver-repo

tibco-driver-path = /home/<user>/jasperreports-server-6.3.0-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 native
jdbcDriverMaker=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=ibm
maven.jdbc.artifactId=db2jcc
maven.jdbc.version=9.7
5. Add the following additional properties, setting the correct values for your installation. For example:
db2.driverType=4
db2.fullyMaterializeLobData=true
db2.fullyMaterializeInputStreams=true
db2.progressiveStreaming=2
db2.progressiveLocators=2
dbPort=50000
js.dbName=JSPRSRVR
sugarcrm.dbName=SUGARCRM
foodmart.dbName=FOODMART
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.

Version: 
Feedback