java.text.ParseException: Unparseable date: "05/11/2023"

[Murilocb123]

Hello,
I am facing a problem regarding date formatting in my location, where, every first Sunday in November, the dates are not formatted correctly, for example, date "05/11/2023" generating the error:

java.text.ParseException: Unparseable date: "05/11/2023"
        at com.ibm.icu.text.DateFormat.parse(DateFormat.java:667)
        at org.eclipse.datatools.enablement.oda.xml.util.date.DateUtil.toDate(DateUtil.java:295)
        at org.eclipse.datatools.enablement.oda.xml.util.date.DateUtil.toDate(DateUtil.java:329)
        at org.eclipse.datatools.enablement.oda.xml.util.date.DateUtil.toSqlDate(DateUtil.java:216)
        at org.eclipse.datatools.enablement.oda.xml.impl.ResultSet.stringToDate(ResultSet.java:385)
        at org.eclipse.datatools.enablement.oda.xml.impl.ResultSet.getDate(ResultSet.java:358)
        at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaResultSet.getDate(OdaResultSet.java:514)
        at org.eclipse.birt.data.engine.odaconsumer.ResultSet.getDate(ResultSet.java:251)
        at org.eclipse.birt.data.engine.odaconsumer.ResultSet.fetch(ResultSet.java:162)
        at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:194)
        at org.eclipse.birt.data.engine.executor.cache.RowResultSet.fetch(RowResultSet.java:136)
        at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:119)
        at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:98)
        at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet$RowResultSetWithResultSetScope.fetch(SimpleResultSet.java:908)
        at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:119)
        at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:98)
        at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.prepareFirstRow(SimpleResultSet.java:257)
        at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.getResultSetIterator(SimpleResultSet.java:275)
        at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:929)
        at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:550)
        at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1074)
        at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:218)
        at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:170)
        at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:96)
        at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:150)
        at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:254)
        at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1632)

Note: I got this log debugging birt.

As it generates an error in my locale, I verified that if it cannot convert, it tries to convert with the default locale, which is "ULocale.US", so my date, which is day/month/year, becomes month/day/year.

Result error: 11/05/2023

[speckyspooky]

Have you perhaps a small test report with the exception then we could try to get the same and then to debug the original issue which cause the wrong date format. For me is not completely clear in wich way you get the date and what are the next steps of the date will be executed to get the parsing exception.