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>/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_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.0-src\jasperserver-repo[/code]repo-path = /home/<user>/jasperreports-server-6.2.0-src/jasperserver-repo[/code] |
deploy-tibco-drivers | deploy-tibco-drivers = true |
tibco-driver-path |
|
If you use native drivers instead of TIBCO drivers, additional steps are required:
| a. | If you want to execute the database-related steps, locate the Setup Standard Oracle JDBC Driver section in the file and uncomment the following properties, setting them to specify the name and version of your JDBC driver jar: |
maven.jdbc.groupId=oraclemaven.jdbc.artifactId=ojdbc6maven.jdbc.version=11.2.0.2# sid=orcljdbcDriverClass=oracle.jdbc.OracleDriverjdbcDataSourceClass=oracle.jdbc.pool.OracleConnectionPoolDataSource[/code] |
| b. | Save the default_master.properties file. If you do not want to execute the database-related steps, you are finished. |
| c. | If you want to execute the database-related steps, go to the buildomatic/conf_source/db/oracle directory |
cd conf_source/db/oracle
| d. | Open the db.template.properties file and comment out the following properties: |
# jdbc url templates...assume same host, port, db type# admin.jdbcUrl=jdbc:tibcosoftware:oracle://${dbHost}:${dbPort};${dbSidOrServiceNameProp} # ${AdditionalAdminProperties}# js.jdbcUrl=jdbc:tibcosoftware:oracle://${dbHost}:${dbPort};${dbSidOrServiceNameProp}# sugarcrm.jdbcUrl=jdbc:tibcosoftware:oracle://${dbHost}:${dbPort};${dbSidOrServiceNameProp}# foodmart.jdbcUrl=jdbc:tibcosoftware:oracle://${dbHost}:${dbPort};${dbSidOrServiceNameProp}[/code] |
| e. | In the same db.template.properties file, uncomment the properties for the standard oracle driver: |
# uncomment for standard oracle driveradmin.jdbcUrl=jdbc:oracle:thin:@${dbHost}:${dbPort}${dbSidOrServiceName} js.jdbcUrl=jdbc:oracle:thin:@${dbHost}:${dbPort}${dbSidOrServiceName}sugarcrm.jdbcUrl=jdbc:oracle:thin:@${dbHost}:${dbPort}${dbSidOrServiceName}foodmart.jdbcUrl=jdbc:oracle:thin:@${dbHost}:${dbPort}${dbSidOrServiceName}[/code] |
| f. | Save the db.template.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.0-src\jasperserver-repo[/code]repo-path = /home/<user>/jasperreports-server-6.2.0-src/jasperserver-repo[/code] |
deploy-tibco-drivers | deploy-tibco-drivers = true |
tibco-driver-path |
|
If you use native drivers instead of TIBCO drivers, additional steps are required:
| • | (Applies only if not using Tibco driver) If you want to execute the database-related steps, locate the Setup Standard SQL Server JDBC Driver section in the file and uncomment the following properties, setting them to specify the name and version of your JDBC driver jar: |
maven.jdbc.groupId=sqlservermaven.jdbc.artifactId=sqljdbcmaven.jdbc.version=1.6sqlserver.jdbcUrlProtocol=jdbc:sqlserverjdbcDriverClass=com.microsoft.sqlserver.jdbc.SQLServerDriverjdbcDataSourceClass=com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource[/code] |
| 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_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.0-src\jasperserver-repo[/code]repo-path = /home/<user>/jasperreports-server-6.2.0-src/jasperserver-repo[/code] |
deploy-tibco-drivers | deploy-tibco-drivers = true |
tibco-driver-path |
|
If you use native drivers instead of TIBCO drivers, additional steps are required:
| a. | If you want to execute the database-related steps, locate the Setup Standard DB2 JDBC Driver section in the file and uncomment the following properties, setting them to specify the name and version of your JDBC driver jar: |
maven.jdbc.groupId=ibmmaven.jdbc.artifactId=db2jccmaven.jdbc.version=9.5jdbcDriverClass=com.ibm.db2.jcc.DB2DriverjdbcDataSourceClass=com.ibm.db2.jcc.DB2ConnectionPoolDataSource[/code] |
| b. | Comment out the URL properties lower in the file. The properties begin like so; they are not shown in full for reasons of space: |
#admin.jdbcUrl=jdbc:db2://${dbHost}:${dbPort}...#js.jdbcUrl=jdbc:db2://${dbHost}:${dbPort}...#sugarcrm.jdbcUrl=jdbc:db2://${dbHost}:${dbPort}...#foodmart.jdbcUrl=jdbc:db2://${dbHost}:${dbPort}...[/code] |
| c. | Add the following additional properties, setting the correct values for your installation. For example: |
db2.driverType=4db2.fullyMaterializeLobData=truedb2.fullyMaterializeInputStreams=truedb2.progressiveStreaming=2db2.progresssiveLocators=2dbPort=50000js.dbName=JSPRSRVRsugarcrm.dbName=SUGARCRMfoodmart.dbName=FOODMART[/code] |
| 4. | 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.