How to Integrate Apache Dremio with JasperReports Server

Error creating bean with name 'logFilterManager': Invocation of init method failed; nested exception is java.lang.ClassCastException: org.apache.logging.log4j.simple.SimpleLoggerContext cannot be cast to org.apache.logging.log4j.core.LoggerContext[/code]

Resolution

It looks like Dremio JDBC driver has log4j dependencies which conflicts with built-in log4j library.

A possible solution is to upload the driver manually via UI.

Additionally, applicationContext.xml config file should be modified to mark Dremio JDBC driver

as the one which does not support autocommit, otherwise you will gen an error in connection test

Can’t turn off auto-committing; transactions are not supported. (Dremio is not transactional.)[/code]

Steps to create a Dremio JDBC datasource:

• Stop TIBCO JasperReports^® Server
• Edit WEB-INF/applicationContext.xml by adding

  <value>com.dremio.jdbc.Driver</value>[/code]into property

  <property name="autoCommitUnsupportedDrivers">[/code]

• Start the server
• Go to Create > Data Source menu
• Select "Other..." from JDBC Driver drop-down list
• Paste 

  com.dremio.jdbc.Driver[/code]as JDBC Driver field value

• Click on "Add Driver..." button
• Select Dremio JDBC v.4.7.3 or later driver, click Upload
• Once the driver uploaded to the server, specify connection URL in form

  jdbc:dremio:direct=<host>:31010[/code]

   

• Provide user name and password
• Click Test Connection

Please note, in case of using some older versions of Dremio JDBC driver, for example, v.3.3.2 connection test fails with error

Cannot get a connection, pool error Could not create a validated object, cause: Can't turn off auto-committing; transactions are not supported. (Dremio is not transactional.)[/code]

Download the latest version of Dremio JDBC driver and use it instead.

Solution tested with TIBCO JasperReports^® Server v.7.5.0

AS-20200923, case 01890236