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:

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

    Procedure
  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-7, wildfly, skipAppServerCheck]

    appServerDir

    appServerDir = C:\\Program Files\\Apache Software Foundation\\Tomcat 9.0

    appServerDir = /home/<user>/apache-tomcat-9.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-9.0.0-src\\jasperserver

    js-path = /home/<user>/JasperReports-Server-9.0.0-src/jasperserver

    js-pro-path

    js-pro-path = C:\\JasperReports-Server-9.0.0-src\\jasperserver-pro

    js-pro-path = /home/<user>/JasperReports-Server-9.0.0-src/jasperserver-pro

    repo-path

    repo-path = C:\\JasperReports-Server-9.0.0-src\\jasperserver-repo

    repo-path = /home/<user>/JasperReports-Server-9.0.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

    Procedure
  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-7, wildfly, skipAppServerCheck]

    appServerDir

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

    dbUsername

    		dbUsername=sa

    dbPassword

    		dbPassword=sa

    dbHost

    		dbHost=localhost

    js-path

    js-path = C:\\JasperReports-Server-9.0.0-src\\jasperserver

    js-path = /home/<user>/JasperReports-Server-9.0.0-src/jasperserver

    js-pro-path

    js-pro-path = C:\\JasperReports-Server-9.0.0-src\\jasperserver-pro

    js-pro-path = /home/<user>/JasperReports-Server-9.0.0-src/jasperserver-pro

    repo-path

    repo-path = C:\\JasperReports-Server-9.0.0-src\jasperserver-repo

    repo-path = /home/<user>/JasperReports-Server-9.0.0-src/jasperserver-repo

    chrome.path

    chrome.path = C:/Program Files (x86)/Google/Chrome/Application/chrome.exe

    chrome.path = /usr/bin/google-chrome

  1. Save the default_master.properties file.

DB2

    Procedure
  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-7, wildfly, skipAppServerCheck]

    appServerDir

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

    dbUsername

    		dbUsername=db2admin

    dbPassword

    		dbPassword=password

    dbHost

    dbHost=localhost

    js-path

    js-path = C:\\JasperReports-Server-9.0.0-src\\jasperserver

    js-path = /home/<user>/JasperReports-Server-9.0.0-src/jasperserver

    js-pro-path

    js-pro-path = C:\\JasperReports-Server-9.0.0-src\\jasperserver-pro

    js-pro-path = /home/<user>/JasperReports-Server-9.0.0-src/jasperserver-pro

    repo-path

    repo-path = C:\\JasperReports-Server-9.0.0-src\\jasperserver-repo

    repo-path = /home/<user>/JasperReports-Server-9.0.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.

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.