Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsBIRT timezone value
https://www.eclipse.org/forums/index.php/mv/msg/363623/888063/#msg_888063
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?
P.S
I have another server with different timezone (without the java parameter) and my code works there.
Thanks for you help. ]]>Daniel Ammar2012-06-17T16:18:11-00:00Re: BIRT timezone value
https://www.eclipse.org/forums/index.php/mv/msg/363623/888767/#msg_888767
using the viewer it can get it from the web.xml timzone setting, or the
url parameter __timezone to the viewer. You can test what the report is
getting by creating a blank report and add a data item with the
following expression:
reportContext.getTimeZone().getDisplayName();
Jason
On 6/17/2012 12:18 PM, Daniel Ammar wrote:
> Hi,
>
> 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 :d , 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?
>
> P.S
> I have another server with different timezone (without the java
> parameter) and my code works there.
>
> Thanks for you help. 8)]]>Jason Weathersby2012-06-18T15:41:45-00:00