Eclipse Community Forums: BIRT » oracle jdbc driver TIMESTAMP WITH LOCAL TIME ZONE

Home » Archived » BIRT » oracle jdbc driver TIMESTAMP WITH LOCAL TIME ZONE(jdbc driver and database session time zone)

Show: Today's Messages :: Show Polls :: Message Navigator

oracle jdbc driver TIMESTAMP WITH LOCAL TIME ZONE [message #638219]

Wed, 10 November 2010 14:54

dxturner

Messages: 1
Registered: November 2010

Junior Member

I have an oracle SQL query that works from sqlplus, but when I try to use it in a BIRT report an error is displayed on the results page that says:

ReportDesign (id = 1):
+ Cannot get the string value from column: 8
Cannot get the string value in the result set.
SQL error #1: The database session time zone is not set

With some google searching it appears that when you query data with type 'TIMESTAMP WITH LOCAL TIME ZONE' you need to have the session timezone set. When you log in with sqlplus, the query works because the timezone is automagically set. When BIRT makes the connection to the database through the jdbc driver, the session time zone is not set.

According to an Oracle FAQ ....

>> "Before accessing TIMESTAMP WITH LOCAL TIME ZONE data, call the
>> OracleConnection.setSessionTimeZone(String regionName) method to set
>> the session time zone. When this method is called, the JDBC driver
>> sets the session time zone of the connection and saves the session
>> time zone so that any TIMESTAMP WITH LOCAL TIME ZONE data accessed
>> through JDBC can be adjusted using the session time zone."

So, my question is ... how can I call this method to set the session time zone, or am I missing something more basic?

Any help appreciated. Thanks.

Report message to a moderator