Jasper server - Postgres Stored functions throws errors with JDBC Datasource

[dmaheshwarareddy]

Environment : Jasper Server 6.3

Data Base: PostgresSQL 9.6

Question:  I am able to preview the report in Jasper studio with Postgres stored functions however , the same report is throwing exception in Jasper server. I have used JDBC data source in Jasper server.

It seems JDBC data source in Jasper server is not supporting stored functions.

Please suggest better way to use stored functions in Jasper server.

 

Thanks for your support.

 

Thanks,

Mahesh