IssueUsing a Redshift datasource in a Virtual Datasource (VDS) in JasperReports Server v5.6.0 produces the following error when opening a Domain Designer using the VDS: | [toc] |
ERROR BaseJdbcMetaDataFactoryImpl,http-bio-7560-exec-7:359 - Cannot get database meta info : /public/Samples/Data_Sources/Virtual_DB_Tester org.teiid.jdbc.TeiidSQLException: Error trying to obtain metadata information for the tables that match %: TEIID30489 Unable to load metadata for VDB name.
Resolution
Virtual data sources are based on the Teiid engine to handle multiple data sources and combine the results from them. In JasperReports Server v5.6 the Teiid library was upgraded to the latest version, but an unforseen consequence of this is that Teiid is unable to get the foreign keys from the database metadata using the Postgres driver, thus producing the above error. Since JasperReports Server does not use this metadata the workaround for this issue is to configure the VDS to not retreive the metadata. Search for importPropertyMap in applicationContext-virtual-data-source.xml, uncomment it and add the following map.
<property name="importPropertyMap">
<map>
<entry key="REDSHIFT_DS_NAME">
<map>
<entry key="importer.importKeys" value="false"/>
<entry key="importer.importForeignKeys" value="false"/>
<entry key="importer.importIndexes" value="false"/>
<entry key="importer.importStatistics" value="false"/>
</map>
</entry>
</map>
</property>Replace REDSHIFT_DS_NAME with the name of your Redshift datasource. Note: If you created an alias for the Redshift datasource in the VDS you must use the alias instead of the datasource name in the entry key.
Recommended Comments
There are no comments to display.