Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Problem with Oracle and IBM WBI Adapter for JDBC
Hello,
We have a Orcale 10g database which are using the data type TIMESTAMP WITH LOCAL TIME ZONE and to integrate with the database we want to use the "IBM WebSphere Business Integration Adapter for JDBC". But the Oracle JDBC driver causes us some problems because the need of setting the session time zone on the OracleConnection before any SELECT from the timestamp column, e.g.
((OracleConnection)conn).setSessionTimeZone(TimeZone.getDefault().getID());
It would have been very helpful it would be possible to set the default session time zone on the connection parameters or as system parameters but what I have seen (decompiling the JDBC driver) it's not possible.
Do you have any idea?
-- // 4 IntegrationReceived on Mon Jan 29 2007 - 03:47:13 CST
![]() |
![]() |