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. By default, deploy-tibco-drivers is set to false.
Use the 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) |
• | 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>/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=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-8.2.0-src\\jasperserver js-path = /home/<user>/JasperReports-Server-8.2.0-src/jasperserver
|
js-pro-path |
js-pro-path = C:\\JasperReports-Server-8.2.0-src\\jasperserver-pro js-pro-path = /home/<user>/JasperReports-Server-8.2.0-src/jasperserver-pro
|
repo-path |
repo-path = C:\\JasperReports-Server-8.2.0-src\\jasperserver-repo repo-path = /home/<user>/JasperReports-Server-8.2.0-src/jasperserver-repo
|
deploy-tibco-drivers | deploy-tibco-drivers = true |
tibco-driver-path |
tibco-driver-path = C:\\JasperReports-Server-8.2.0-src\tibco-driver-repo tibco-driver-path = /home/<user>JasperReports-Server-8.2.0-src/tibco-driver-repo |
chrome.path | chrome.path = C:/Program Files (x86)/Google/Chrome/Application/chrome.exe chrome.path = /usr/bin/google-chrome |
5. | If you use native drivers instead of Jaspersoft 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=tomcat [jboss-eap-7, wildfly, skipAppServerCheck] |
appServerDir |
appServerDir = C:\\Program Files\\Apache Software Foundation\\Tomcat 9.0 appServerDir = /home/<user>/apache-tomcat-9.0
|
dbUsername |
dbUsername=sa
|
dbPassword |
dbPassword=sa
|
dbHost |
dbHost=localhost
|
js-path |
js-path = C:\\JasperReports-Server-8.2.0-src\\jasperserver js-path = /home/<user>/JasperReports-Server-8.2.0-src/jasperserver
|
js-pro-path |
js-pro-path = C:\\JasperReports-Server-8.2.0-src\\jasperserver-pro js-pro-path = /home/<user>/JasperReports-Server-8.2.0-src/jasperserver-pro
|
repo-path |
repo-path = C:\\JasperReports-Server-8.2.0-src\jasperserver-repo repo-path = /home/<user>/JasperReports-Server-8.2.0-src/jasperserver-repo
|
deploy-tibco-drivers | deploy-tibco-drivers = true |
tibco-driver-path |
tibco-driver-path = C:\\JasperReports-Server-8.2.0-src\\tibco-driver-repo tibco-driver-path = /home/<user>/JasperReports-Server-8.2.0-src/tibco-driver-repo |
chrome.path | chrome.path = C:/Program Files (x86)/Google/Chrome/Application/chrome.exe chrome.path = /usr/bin/google-chrome |
4. | If you use native drivers instead of Jaspersoft 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 mssql-jdbc-6.4.0.jre8.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=mssql-jdbc maven.jdbc.version=6.4.0.jre8 |
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=tomcat [jboss-eap-7, wildfly, skipAppServerCheck] |
appServerDir |
appServerDir = C:\\Program Files\\Apache Software Foundation\\Tomcat 9.0 appServerDir = /home/<user>/apache-tomcat-9.0
|
dbUsername |
dbUsername=db2admin
|
dbPassword |
dbPassword=password
|
dbHost |
dbHost=localhost
|
js-path |
js-path = C:\\JasperReports-Server-8.2.0-src\\jasperserver js-path = /home/<user>/JasperReports-Server-8.2.0-src/jasperserver
|
js-pro-path |
js-pro-path = C:\\JasperReports-Server-8.2.0-src\\jasperserver-pro js-pro-path = /home/<user>/JasperReports-Server-8.2.0-src/jasperserver-pro
|
repo-path |
repo-path = C:\\JasperReports-Server-8.2.0-src\\jasperserver-repo repo-path = /home/<user>/JasperReports-Server-8.2.0-src/jasperserver-repo
|
deploy-tibco-drivers | deploy-tibco-drivers = true |
tibco-driver-path |
tibco-driver-path = C:\\JasperReports-Server-8.2.0-src\\tibco-driver-repo tibco-driver-path = /home/<user>/JasperReports-Server-8.2.0-src/tibco-driver-repo |
chrome.path | chrome.path = C:/Program Files (x86)/Google/Chrome/Application/chrome.exe chrome.path = /usr/bin/google-chrome |
4. | If you use native drivers instead of Jaspersoft 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=10.5 |
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.
Recommended Comments
There are no comments to display.