murugesanvinoth3

we have deployed JAsper server 6.2V in tomcat 8.5.49. facing some intermittent issue, server stops working , logs as below catalina.out 2020-02-13 13:00:18,304 ERROR JDBCTransaction,http-nio-49443-exec-4:202 - JDBC rollback failed java.sql.SQLRecoverableException: Closed Connection at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:264) 2020-02-13 16:23:09,431 ERROR LocalDataSourceJobStore,quartzScheduler_QuartzSchedulerThread:3641 - Couldn't rollback jdbc connection. Closed Connection java.sql.SQLRecoverableException: Closed Connection jasperserver.log - below line prints for 2000+ times at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3894) 2020-02-14 05:36:08,852 ERROR LocalDataSourceJobStore,quartzScheduler_QuartzSchedulerThread:3641 - Couldn't rollback jdbc connection. Closed Connection java.sql.SQLRecoverableException: Closed Connection please suggest on this

The value "/reportsNewTest/GPRSS/IMR_003_ww.jrxml" for parameter "resourceReference.uri" is invalid. My REquest :- {"label":"IMR_003_ww","description":"IMR_003_ww","dataSource" : {"dataSourceReference" : {"uri" : "/datasources/APPLDB"} }, "inputControls": [ {"inputControlReference": { "id": "FROM_DATE,"uri": "/reportsNewTest/APPLN_NEW/IMR_003_ww.jrxml","value" : "FROM_DATE","options": { "label":"FROM_DATE","selected": false,"value" : ""},"mandatory": true,"readOnly": true,"visible": true,"dataType": { "label":"FROM_DATE","description":"FROM_DATE","type": "0","strictMax": false,"strictMin": false }}}, {"inputControlReference": { "id": "TODATE","uri": "/reportsNewTest/APPLN_NEW/IMR_003_ww.jrxml","value" : "TODATE","options": { "label":"TODATE","selected": false,"value" : ""},"mandatory": true,"readOnly": true,"visible": true,"dataType": { "label":"TODATE","description":"TODATE","type": "0","strictMax": false,"strictMin": false }}} ],"alwaysPromptControls": false,"controlsLayout": "popupScreen","jrxml" : { "jrxmlFile" : {"label": "mainReport","type":"jrxml", "content" : "PD94bWwgdm0Pgo=" } }} please help on this

Even tried the option with DataType, its failing.

can you shaere the Java code .

Hi , WE are migrating Jasper Report from 4.5 to 7.1, Can you please post the sample java client code to call GET/PUT/POST/DELTE .