Recently I encountered an issue with BIRT that crash and generates Oracle error messages ORA-00604 & ORA-01882 which related to timezone.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
After googling a little I found that some users suggested to set the java with -Duser.timezone value to solve the issue.
Actually it solves my issue , but my question is why do I need to set it?
I didn't initiate BIRT with any localization value, and also haven't seen how...
Should BIRT gets the timezone value directly from the my linux variables?
I have another server with different timezone (without the java parameter) and my code works there.