Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problem with Oracle and IBM WBI Adapter for JDBC

Problem with Oracle and IBM WBI Adapter for JDBC

From: 4 Integration <4integration_at_gmail.com>
Date: Mon, 29 Jan 2007 10:47:13 +0100
Message-ID: <epkfqc$ck6$1@independence.tornevall.net>


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 Integration
Received on Mon Jan 29 2007 - 03:47:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US