I'm trying to retrieve an Oracle column that is defined as TIMESTAMP WITH LOCAL TIME ZONE. Currently I'm receiving an error stating
--- Cause: java.sql.SQLException: Session Time Zone not set! Looking into it I need to specify the Session Time Zone as part of the Oracle JDBC Connection properties. I found this in an Oracle document when searching for a solution: 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 would I go about calling the setSessionTimeZone method of the OracleConnection when using iBATIS (and Spring). Thanks, Jesse Reimann
