Bonita 7.5 and compatible Jasper report

Submitted by whramirez on Thu, 08/24/2017 - 15:10
1
0
-1

Hello everyone,
I'm working on a report using Jasper reports and Bonita 7.5. It gives me an error when I'm trying passing date parameters. At first it seems an error of compatibility with Jasper, I'm trying with Jasper Studio, v 6.5 and v.5.0.4 but in doesn't work. By hassard, is there someone who has worked and save this problem?

Thanks in advance for suggestions.

#jasperreport
#parameterdate

Comments

Submitted by romualdo.s.rs on Thu, 08/24/2017 - 21:24

I recently used BonitaSoft 7.3.3 with JasperStudio 5.6.0 and got it rolling as expected, what does your logs display as an error?

Permalink
Submitted by romualdo.s.rs on Fri, 01/26/2018 - 12:16

Were you able to solve your problem?

Permalink
Submitted by whramirez on Fri, 01/26/2018 - 13:19

Not really, perhaps with a newer version ex. Bonita 7.6 it could work but i'm using 7.5 and i've using other type of field to around my problem. If you have your experience or other ideas, thanks.
Wr

Permalink
Submitted by romualdo.s.rs on Fri, 01/26/2018 - 14:32

Yeah, I've migrated my version from 7.3.3 to 7.5.4 and then my report that has a sub report went to give an error very similar to your

Permalink
Submitted by romualdo.s.rs on Fri, 01/26/2018 - 14:55

I tried to migrate to version 7.6.1 and also did not solve, the strange thing is that in an older version (7.3.3) it usually works however in a newer (7.5.4 or 7.6.1) of that Bug

Permalink
Submitted by romualdo.s.rs on Tue, 01/30/2018 - 13:48

I was able to solve my problem by installing an updated JAR version of jasperreports
https://sourceforge.net/projects/jasperreports/files/jasperreports/Jaspe...

I hope it helps you

Permalink
Submitted by subscriptions_3 on Tue, 01/30/2018 - 14:23

Also I figured it out that I can work around using only string and integer variables.

Permalink
1 answer

Submitted by whramirez on Fri, 08/25/2017 - 22:06
1
0
-1

Hi Romualdo,
In my log I see there's something wrong with the data type:
"Caused by: org.bonitasoft.engine.connector.ConnectorException: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:
1. java.sql.Date cannot be resolved to a type
value = ((java.sql.Date)field_dtdeme.getValue()); //$JR_EXPR_ID=14$
<----------->
2. java.sql.Date cannot be resolved to a type
value = ((java.sql.Date)field_dtdeme.getOldValue()); //$JR_EXPR_ID=14$
<----------->
3. java.sql.Date cannot be resolved to a type
value = ((java.sql.Date)field_dtdeme.getValue()); //$JR_EXPR_ID=14$
<----------->
3 errors

at org.bonitasoft.connectors.jasper.CreateReportFromDataBase.executeBusinessLogic(CreateReportFromDataBase.java:214)
at org.bonitasoft.engine.connector.AbstractConnector.execute(AbstractConnector.java:77)
at org.bonitasoft.engine.core.connector.impl.SConnectorAdapter.execute(SConnectorAdapter.java:73)
... 6 more

Caused by: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:
1. java.sql.Date cannot be resolved to a type
value = ((java.sql.Date)field_dtdeme.getValue()); //$JR_EXPR_ID=14$
<----------->
2. java.sql.Date cannot be resolved to a type
value = ((java.sql.Date)field_dtdeme.getOldValue()); //$JR_EXPR_ID=14$
<----------->
3. java.sql.Date cannot be resolved to a type
value = ((java.sql.Date)field_dtdeme.getValue()); //$JR_EXPR_ID=14$
<----------->
3 errors

at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:204)
at net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:240)
at net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:226)
at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:481)
at org.bonitasoft.connectors.jasper.CreateReportFromDataBase.createJasperReportFromDataBase(CreateReportFromDataBase.java:307)
at org.bonitasoft.connectors.jasper.CreateReportFromDataBase.executeBusinessLogic(CreateReportFromDataBase.java:212)"

In this case I've tested with MS-SQL R 2008 but with postgresql is the same type of error. If there an idea probably I'll do samething next week, thanks.

Comments

Submitted by nicolas.dupont_1 on Tue, 09/05/2017 - 09:42

I have same issue with java.lang.Long... I'm using iReport Designer 5.1.0

Permalink
Submitted by antoine.mottier on Wed, 01/31/2018 - 13:31

It is a currently known issue of the Jasper Connector that should be fixed in the maintenance release 7.6.3 (see my answer on this other post: https://community.bonitasoft.com/node/28628#node-28635)

Permalink
Notifications