For more information, see the CData KB for guides to deploying the JDBC Driver on Java application servers. To publish the report to your application server, add the driver JAR to the BIRT Viewer's classpath. Your BIRT reports can now pick up any updates to MySQL data.
When you configure the JDBC URL, you may also want to set the Max Rows connection property. MySQL JDBC URL format: This is the first JDBC URL format that can be used in MySQL to establish the connection with the required database name.
Either double-click the JAR file or execute the jar file from the command-line.įill in the connection properties and copy the connection string to the clipboard. JDBC provides the different JDBC drivers for the different database systems and we can utilize them as per the user requirement. If not set, tables from all databases will be returned.įor assistance in constructing the JDBC URL, use the connection string designer built into the MySQL JDBC Driver. Optionally, Database can be set to connect to a specific database.
Call me lazy, but I've never tried to memorise it so I have to refer to documentation for it. It's not the entire URL as required by the JDBC driver, but it can get you there if you memorised the rest of the connect string. If IntegratedSecurity is set to false, then User and Password must be set to valid userĬredentials. There is actually a partial JDBC URL visible in the Connection Manager already just to the right of the connection name. The Server and Port properties must be set to a MySQL server.