rowOrientation fails to display results from Vertica database in horizontally mode

Question

Hello,

We are trying to use the rowOrientation in order to display charts in a better way. However, we have noticed that a when using a Bob Swift's SQL Query macro that is pulling data from a linked DB, it working only when pulling data from a MySQL DB.

A similar query on Vertica DB fails and showing the error:

Error rendering macro 'sql-query' : java.sql.SQLFeatureNotSupportedException: [Vertica][JDBC](10220) Driver not capable

Thanks

Bob Swift · Answer

First, make sure you are using the latest available JDBC driver for your database. Horizontal row orientation means we need to use additional JDBC support to achieve the results. Some JDBC drivers may not have support for one or more of these. If that is the case, then you can only do vertical row orientation.

* ResultSet.TYPE_SCROLL_INSENSITIVE

* ResultSet.CONCUR_READ_ONLY

Peter Bengov · Answer

@Bob Swift [Bob Swift Atlassian Add-ons] could you take a look at this? Thanks