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 JDBC driver or download a native JDBC Driver.

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)
• https://www.microsoft.com/en-us/download/details.aspx?id=56615 (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>/jdbc

For example, for SQL Server the driver would go here:

• <js-src>/buildomatic/conf_source/db/sqlserver/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=tomcat [jboss-eap-8, wildfly, skipAppServerCheck]
   appServerDir	appServerDir = C:\Program Files\Apache Software Foundation\Tomcat 11.0 appServerDir = /home/<user>/apache-tomcat-11.0
   sysUsername	sysUsername=system
   sysPassword	sysPassword=password
   dbUsername	dbUsername=jasperserver
   dbPassword	dbPassword=password
   dbHost	dbHost=localhost
   maven	maven = C:\apache-maven-3.9\bin\mvn.cmd maven = /home/<user>/apache-maven-3.9/bin/mvn
   js-path	js-path = C:\ JasperReports-Server-10.1.0 -src\jasperserver js-path = /home/<user>/ JasperReports-Server-10.1.0 -src/jasperserver
   js-pro-path	js-pro-path = C:\ JasperReports-Server-10.1.0 -src\jasperserver-pro js-pro-path = /home/<user>/ JasperReports-Server-10.1.0 -src/jasperserver-pro
   repo-path	repo-path = C:\ JasperReports-Server-10.1.0 -src\jasperserver-repo repo-path = /home/<user>/ JasperReports-Server-10.1.0 -src/jasperserver-repo
   chrome.path	chrome.path = C:/Program Files (x86)/Google/Chrome/Application/chrome.exe chrome.path = /usr/bin/google-chrome

5. 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=tomcat [jboss-eap-8, wildfly, skipAppServerCheck]
   appServerDir	appServerDir = C:\Program Files\Apache Software Foundation\Tomcat 11.0appServerDir = /home/<user>/apache-tomcat-11.0
   dbUsername	dbUsername=sa
   dbPassword	dbPassword=sa
   dbHost	dbHost=localhost
   js-path	js-path = C:\ JasperReports-Server-10.1.0 -src\jasperserver js-path = /home/<user>/ JasperReports-Server-10.1.0 -src/jasperserver
   js-pro-path	js-pro-path = C:\ JasperReports-Server-10.1.0 -src\jasperserver-pro js-pro-path = /home/<user>/ JasperReports-Server-10.1.0 -src/jasperserver-pro
   repo-path	repo-path = C:\ JasperReports-Server-10.1.0 -src\jasperserver-repo repo-path = /home/<user>/ JasperReports-Server-10.1.0 -src/jasperserver-repo
   chrome.path	chrome.path = C:/Program Files (x86)/Google/Chrome/Application/chrome.exe chrome.path = /usr/bin/google-chrome

4. 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=tomcat [jboss-eap-8, wildfly, skipAppServerCheck]
   appServerDir	appServerDir = C:\Program Files\Apache Software Foundation\Tomcat 11.0appServerDir = /home/<user>/apache-tomcat-11.0
   dbUsername	dbUsername=db2admin
   dbPassword	dbPassword=password
   dbHost	dbHost=localhost
   js-path	js-path = C:\ JasperReports-Server-10.1.0 -src\jasperserver js-path = /home/<user>/ JasperReports-Server-10.1.0 -src/jasperserver
   js-pro-path	js-pro-path = C:\ JasperReports-Server-10.1.0 -src\jasperserver-pro js-pro-path = /home/<user>/ JasperReports-Server-10.1.0 -src/jasperserver-pro
   repo-path	repo-path = C:\ JasperReports-Server-10.1.0 -src\jasperserver-repo repo-path = /home/<user>/ JasperReports-Server-10.1.0 -src/jasperserver-repo
   chrome.path	chrome.path = C:/Program Files (x86)/Google/Chrome/Application/chrome.exe chrome.path = /usr/bin/google-chrome

4. 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
   

5. Save the default_master.properties file.