How to configure non default JDBC driver for TIBCO JasperReports® Server buildomatic export/import scripts

Requirement

If you for some reason experience issues with the default TIBCO driver when performing export/import using buildomatic command line scripts, it is useful to be able to switch to a different driver (usually it will be the native driver for whichever database you are using)

Solution

The steps below are written for TIBCO JasperReports^® Server 6.1.1 running on Oracle database:

1. Copy the latest ojdbc6.jar to TWO locations and make sure it is named ojdbc6-11.2.0.4.jar: 

   buildomatic/conf_source/db/oracle/jdbc
   buildomatic/conf_source/iePro/lib
   

2. In the /buildomatic/conf-source/db/oracle/db.template.properties file, uncomment the following lines 

   admin.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}
   

   and at the same time comment out: 

   # 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}
   

3. In the buildomatic/default-master.properties file make sure the following properties are present: 

   jdbcDriverMarker=native
   jdbcDriverClass=oracle.jdbc.OracleDriver
   
   maven.jdbc.groupId=oracle
   maven.jdbc.artifactId=ojdbc6
   maven.jdbc.version=11.2.0.4
   

4. Run the following scripts from the buildomatic folder: 

   ./js-ant clean-config
   ./js-ant gen-config
   

5. Run the export and/or import command 

Ref. case #00070727