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

    Setup for Additional Databases

    If you are building the source code using a database other than PostgreSQL or MySQL, you can use the example settings below for Oracle, SQL Server, and DB2.

    Download a JDBC Driver

    You do not need a JDBC driver jar in order to build the source code. However, if you plan to build the source code and also populate the core data into the jasperserver repository database then you will need a JDBC driver.

    You can download a JDBC driver appropriate for you database from one of the vendor sites listed below:

    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)

    The downloaded JDBC jar should be copied into the following location:

    <js-src>/buildomatic/conf_source/db/<dbType>/jdbc

    For instance, for Oracle the driver would go here:

    <js-src>/buildomatic/conf_source/db/oracle/jdbc

    Additionally, in order to execute the database related steps (if desired), you will need to update your default_master.properties file to specify the name and version of the JDBC driver jar. To make this update, do the following (using Oracle as an example):

    cd <js-src>/jasperserver/buildomatic

    Edit default_master.properties

    Uncomment these two properties:

    # maven.jdbc.artifactId=ojdbc5

    # maven.jdbc.version=11.2.0

    If your Oracle JDBC driver is the following file name (for example):

    ojdbc6-11.2.0.2.jar

    Then set the two properties to the following values:

    maven.jdbc.artifactId=ojdbc6

    maven.jdbc.version=11.2.0.2

     

    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. Edit the new default_master.properties file and set the following properties for your local environment:

    Property

    Examples

    appServerType

    appServerDir

    sysUsername

    sysPassword

    dbUsername

    dbPassword

    dbHost

    maven

    maven = C:\apache-maven-3.0.4\bin\mvn.bat

    maven = /home/devuser/apache-maven-3.0.4/bin/mvn

    js-path

    js-pro-path

    repo-path

    repo-path = C:\jasperreports-server-5.6.0-src\jasperserver-repo[/code]
    repo-path = /home/<user>/jasperreports-server-5.6.0-src/jasperserver-repo[/code]                    

    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

    dbUsername

    dbPassword

    dbHost

    js-path

    js-pro-path

    repo-path

    repo-path = C:\jasperreports-server-5.6.0-src\jasperserver-repo[/code]
    repo-path = /home/<user>/jasperreports-server-5.6.0-src/jasperserver-repo[/code]                    

    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

    dbUsername

    dbPassword

    dbHost

    js-path

    js-pro-path

    repo-path

    repo-path = C:\jasperreports-server-5.6.0-src\jasperserver-repo[/code]
    repo-path = /home/<user>/jasperreports-server-5.6.0-src/jasperserver-repo[/code]                    

    Note: For DB2, the database must be created manually. This is because it is not possible to use a JDBC call to automatically create a database under DB2.


    User Feedback

    Recommended Comments

    There are no comments to display.



    Guest
    This is now closed for further comments

×
×
  • Create New...