set session time zone / query timestamp

[lvgmuellst]

Hi,

 

in a query I want to use a column of the type TIMESTAMP WITH LOCAL TIME ZONE (Oracle).

 

I have set the field type and the expression type in the property dialog of the textfield to java.sql.Timestamp

 

When executing I get the SQLException "Session Time Zone not set!".

 

To do this I have to execute the following sql-statement after opening the connection: ALTER SESSION SET TIME_ZONE = '+1:00';

 

How can I do this?

Or does anybody know another way to read this type of column

 

Thank you very much!

[Giulio Toffoli]

You can not. Probably the only solution would be use a custom JDBC connection datasource. You should create it from the one provided from ireport and install it (there is a section in the ireport guide that explains how to create new connection implementations and use them in iReport).

 

Regards

 

Giulio

[noliver]

Is this still true 6 years later?

[roosit]

i guess, unbelievable, Maybe Jasper should get married to an international bride to order, maybe then this will get attention