Cascading input control with java.sql.Timestamp won't work with locale other than "en"

[ulrich.leinauer]

Hello everyone,

i got some problems with an input control of type java.sql.timestamp. If i cascade this input control and my locale is not set to "en" then the datepicker shows the message "Specify a valid value for type Timestamp".

I'm on JasperReports Server 7.8 and Jaspersoft Studio 6.16.0.

 

jasperserver.log

2021-02-22T15:18:32,387 DEBUG JRJdbcQueryExecuter,http-nio-8080-exec-8:154 - DB is PostgreSQL version 13.1 (13/1)2021-02-22T15:18:32,388 DEBUG JRJdbcQueryExecuter,http-nio-8080-exec-8:158 - driver is PostgreSQL JDBC Driver version 42.2.5 (42/2)2021-02-22T15:18:32,388 DEBUG JRJdbcQueryExecuter,http-nio-8080-exec-8:162 - jdbc 4/22021-02-22T15:18:32,389 DEBUG JRJdbcQueryExecuter,http-nio-8080-exec-8:164 - connection URL is jdbc:postgresql://localhost:5434/XXXXXXXXXXXXX2021-02-22T15:18:32,389 DEBUG JRJdbcQueryExecuter,http-nio-8080-exec-8:206 - system timezone is sun.util.calendar.ZoneInfo[id="Europe/Berlin",offset=3600000,dstSavings=3600000,useDaylight=true,transitions=143,lastRule=java.util.SimpleTimeZone[id=Europe/Berlin,offset=3600000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=3600000,startTimeMode=2,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=3600000,endTimeMode=2]]2021-02-22T15:18:32,389 DEBUG JRJdbcQueryExecuter,http-nio-8080-exec-8:207 - report timezone is null2021-02-22T15:18:32,389 DEBUG JRJdbcQueryExecuter,http-nio-8080-exec-8:208 - JDBC timezone parameter is null2021-02-22T15:18:32,389 DEBUG JRJdbcQueryExecuter,http-nio-8080-exec-8:209 - JDBC timezone property is null2021-02-22T15:18:32,390 DEBUG JRJdbcQueryExecuter,http-nio-8080-exec-8:215 - JDBC parameters timezone parameter is null2021-02-22T15:18:32,390 DEBUG JRJdbcQueryExecuter,http-nio-8080-exec-8:227 - JDBC parameters timezone property is null2021-02-22T15:18:32,390 DEBUG JRJdbcQueryExecuter,http-nio-8080-exec-8:234 - parameters timezone null2021-02-22T15:18:32,391 DEBUG JRJdbcQueryExecuter,http-nio-8080-exec-8:240 - JDBC fields timezone parameter is null2021-02-22T15:18:32,391 DEBUG JRJdbcQueryExecuter,http-nio-8080-exec-8:252 - JDBC fields timezone property is null2021-02-22T15:18:32,391 DEBUG JRJdbcQueryExecuter,http-nio-8080-exec-8:259 - fields timezone null2021-02-22T15:18:32,391 DEBUG JRJdbcQueryExecuter,http-nio-8080-exec-8:372 - SQL query string: SELECT ? As Von2021-02-22T15:18:32,392 DEBUG JRJdbcQueryExecuter,http-nio-8080-exec-8:586 - Parameter #1 (Von of type java.sql.Timestamp): null2021-02-22T15:18:32,392 DEBUG valueQueryLog,http-nio-8080-exec-8:2374 - query took 5 ms: SELECT $P{Von} As Von2021-02-22T15:18:32,393 DEBUG valueQueryLog,http-nio-8080-exec-8:2375 - params: {LoggedInUsername=jasperadmin, DATABASE_TIMEZONE=sun.util.calendar.ZoneInfo[id="Europe/Berlin",offset=3600000,dstSavings=3600000,useDaylight=true,transitions=143,lastRule=java.util.SimpleTimeZone[id=Europe/Berlin,offset=3600000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=3600000,startTimeMode=2,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=3600000,endTimeMode=2]], datasourceURI=/datasources/Postgres, REPORT_CONNECTION=jdbc:postgresql://localhost:5434/Interquell_Wehringen, UserName=Interquell_Wehringen, PostgreSQL JDBC Driver, LoggedInUser=MetadataUserDetails: jasperadmin, Von=null}[/code]