Download Driver Jar from Vendor Website To download a commercial JDBC driver for a particular vendor, you will need to go to the download website of that vendor. It is typical that these vendors will require you to register and login to their website before you can download driver packages.
Additionally, it is standard for the vendor's website to present a terms of service agreement that will need to be agreed to. Here are some common URL addresses where you can find download packages for supported databases:. (Oracle). (SQL Server).
(DB2) Collect Driver Jar from Existing Application It is very often the case that a JDBC driver is already present in an application that is running within your network. If this is the case, then it can be very convenient to collect a copy of that driver jar and copy it to the JasperReports Server install location. Copy Driver Jar to Final Location Once the JDBC driver has been downloaded or collected, it can be copied to the location where the JasperReports Server installation expects the Jar file to be. Here are the 'copy to' locations for certified commercial databases:.
/buildomatic/confsource/db/oracle/jdbc (Oracle). /buildomatic/confsource/db/sqlserver/jdbc (SQL Server). /buildomatic/confsource/db/db2/jdbc (DB2) When the JDBC jar is copied to the location shown above, the JasperReports Server installation procedure is ready to be started. Changing the JDBC Driver Deployed by Buildomatic JDBC drivers for databases are handled differently depending on whether the database is commercial or open source. For the commercial databases (Oracle, SQL Server, and DB2), JDBC drivers are not included in buildomatic. For open source databases (PostgreSQL and MySQL), JDBC drivers are pre-integrated into buildomatic.
MySQL Cluster CGE (commercial) MySQL Cluster is a real-time open source transactional database designed for fast, always-on access to data under high throughput conditions. MySQL JDBC for macOS. This tutorial shows how to set up a data source and connect to a MySQL ® database using the Database Explorer app or the command line. This tutorial uses the MySQL Connector/J 5.1.46 driver to connect to a MySQL Version 5.5.16 database.
Commercial JDBC Drivers For commercial databases, buildomatic is setup so that the JDBC driver jar filename can be any filename as long as it ends with '.jar'. The driver jar file is placed in the buildomatic location for your commercial database /buildomatic/confsource/db//jdbc. However, it is important that you only put one driver jar file in this folder.
As part of the installation procedure buildomatic will copy the contents of the jdbc folder to your application server. So, it is important that only one JDBC driver file is put in this folder. If two driver jars are used in your application server there can be unknown problems.
Also, it will be possible to get a Java Class exception if the two driver jars cannot co-exist with each other. Open Source JDBC Drivers For open source JDBC drivers, buildomatic is setup so that there will be a single default driver used. If you would like to use a driver other than the default driver, you can modify the buildomatic property files that control which JDBC driver is used as the default. The buildomatic JDBC driver property files are setup to point to a specific driver jar. This allows for there to be multiple driver jar files in the same buildomatic/confsource/db//jdbc folder.
When the installation procedure is executed only the default driver jar is copied to your application server. If you would like to use a newer JDBC driver version or a different JDBC driver, you can modify the buildomatic properties seen in your defaultmaster.properties file.