Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT timezone value
BIRT timezone value [message #888063] Sun, 17 June 2012 16:18 Go to next message
Daniel Ammar is currently offline Daniel Ammar
Messages: 1
Registered: June 2012
Junior Member
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 Very Happy , 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. Cool
Re: BIRT timezone value [message #888767 is a reply to message #888063] Mon, 18 June 2012 15:41 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

It should be retrieving the timezone from the system, or if you are
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)
Previous Topic:Some text in charts are not anti-aliased
Next Topic:Best practice for managing design, test and production environments
Goto Forum:
  


Current Time: Thu Oct 23 14:44:12 GMT 2014

Powered by FUDForum. Page generated in 0.09906 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software