Jump to content
JasperReports Library 7.0 is now available ×
  • This documentation is an older version of JasperReports Server Source Build Guide. View the latest documentation.

    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_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

    appServerType=tomcat [jboss-eap-6, wildfly, glassfish, skipAppServerCheck][/code]                    

    appServerDir

    appServerDir = C:\Program Files\Apache Software Foundation\Tomcat 8.5.30[/code]
    appServerDir = /home/<user>/apache-tomcat-8.5.30[/code]                    

    sysUsername

    sysPassword

    dbUsername

    dbPassword

    dbHost

    maven
    maven = C:\apache-maven-3.3.9\bin\mvn.cmd[/code]
    maven = /home/<user>/apache-maven-3.3.9/bin/mvn[/code]                    

    js-path

    js-path = C:\JasperReports-Server-7.1.0-src\jasperserver[/code]                    

    js-pro-path

    repo-path

    repo-path = C:\JasperReports-Server-7.1.0-src\jasperserver-repo[/code]
    repo-path = /home/<user>/JasperReports-Server-7.1.0-src/jasperserver-repo[/code]                    
    deploy-tibco-drivers deploy-tibco-drivers = true
    tibco-driver-path

    tibco-driver-path = C:\JasperReports-Server-7.1.0-srctibco-driver-repo

    tibco-driver-path = /home/<user>JasperReports-Server-7.1.0-src/tibco-driver-repo

    headless.browser
    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 nativejdbcDriverMaker=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=oraclemaven.jdbc.artifactId=ojdbc6maven.jdbc.version=11.2.0.					[/code]                    
    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_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

    appServerType=tomcat [jboss-eap-6, wildfly, glassfish, skipAppServerCheck][/code]                    

    appServerDir

    appServerDir = C:\Program Files\Apache Software Foundation\Tomcat 8.5.30[/code]
    appServerDir = /home/<user>/apache-tomcat-8.5.30[/code]                    

    dbUsername

    dbPassword

    dbHost

    js-path

    js-path = C:\JasperReports-Server-7.1.0-src\jasperserver[/code]                    

    js-pro-path

    js-pro-path = C:\JasperReports-Server-7.1.0-src\jasperserver-pro[/code]                    

    repo-path

    repo-path = C:\JasperReports-Server-7.1.0-srcjasperserver-repo[/code]
    repo-path = /home/<user>/JasperReports-Server-7.1.0-src/jasperserver-repo[/code]                    
    deploy-tibco-drivers deploy-tibco-drivers = true
    tibco-driver-path

    tibco-driver-path = C:\JasperReports-Server-7.1.0-src\tibco-driver-repo

    tibco-driver-path = /home/<user>/JasperReports-Server-7.1.0-src/tibco-driver-repo

    headless.browser
    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 nativejdbcDriverMaker=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=sqlservermaven.jdbc.artifactId=sqljdbcmaven.jdbc.version=1.6[/code]                    
    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_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

    appServerType=tomcat [jboss-eap-6, wildfly, glassfish, skipAppServerCheck][/code]                    

    appServerDir

    appServerDir = C:\Program Files\Apache Software Foundation\Tomcat 8.5.30[/code]
    appServerDir = /home/<user>/apache-tomcat-8.5.30[/code]                    

    dbUsername

    dbPassword

    dbHost

    js-path

    js-pro-path

    repo-path

    repo-path = C:\JasperReports-Server-7.1.0-src\jasperserver-repo[/code]
    repo-path = /home/<user>/JasperReports-Server-7.1.0-src/jasperserver-repo[/code]                    
    deploy-tibco-drivers deploy-tibco-drivers = true
    tibco-driver-path

    tibco-driver-path = C:\JasperReports-Server-7.1.0-src\tibco-driver-repo

    tibco-driver-path = /home/<user>/JasperReports-Server-7.1.0-src/tibco-driver-repo

    headless.browser
    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 nativejdbcDriverMaker=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=ibmmaven.jdbc.artifactId=db2jccmaven.jdbc.version=9.7[/code]                    
    5. Add the following additional properties, setting the correct values for your installation. For example:
    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.

    Open topic with navigation


    User Feedback

    Recommended Comments

    There are no comments to display.



    Guest
    This is now closed for further comments

×
×
  • Create New...