Domain Dealing With jsonb Data Type

TIBCO JasperReports^® Server provides a JDBC-to-Java type mapping for all standard JDBC column types for use in Domains. For some DB proprietary and not commonly used data types, users will need to map to a Java type with a special configuration in applicationContext-semanticLayer.xml file. Users in such case should reveiw TIBCO JasperReports^® Server Guide Release 7.1 document, section 8.8.6 "Enabling Proprietary Types" for more information.

If wanting to display a jsonb DB field content in JasperReports Server Domain views, users need to add the jsonb data mapping in applicationContext-semanticLayer.xml file and applicationContext-el-operators.xml file to make it available with appropriate java class types.

An alternate solution is to define a derived table in the Domain and use jsonb_pretty() DB function to get its content into a text string for viewing. In this approach, the user will not need to make configuration changes as described above.

Additional readings with regarding to custom domain functions:

• JasperReports^® Server 6.2 - https://community.jaspersoft.com/wiki/setting-behavior-custom-domain-functions
• JasperReports^® Server 6.3 and later - https://community.jaspersoft.com/wiki/domain-adhoc-view-no-longer-working-after-jasperreports-server-upgrade

TTC-20200223