Update of /cvsroot/squirrel-sql/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle
In directory sfp-cvsdas-3.v30.ch3.sourceforge.com:/tmp/cvs-serv2108/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle
Modified Files:
OraclePlugin.java
Log Message:
Fixed class not found exception in Oracle Plugin when setting Session Time Zone.
Thanks to Neville Rowe
Index: OraclePlugin.java
===================================================================
RCS file: /cvsroot/squirrel-sql/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/OraclePlugin.java,v
retrieving revision 1.60
retrieving revision 1.61
diff -C2 -d -r1.60 -r1.61
*** OraclePlugin.java 1 Jul 2009 21:37:24 -0000 1.60
--- OraclePlugin.java 7 Feb 2010 17:55:51 -0000 1.61
***************
*** 481,505 ****
Connection con = session.getSQLConnection().getConnection();
String timezoneStr = prefs.getSessionTimezone();
! try
! {
! if (s_log.isInfoEnabled())
! {
! s_log.info("setTimezoneForSession: attempting to set the session timezone to : " + timezoneStr);
! }
! Class oraConClass = Class.forName("oracle.jdbc.OracleConnection");
! Method setSessionTimeZoneMethod = oraConClass.getMethod("setSessionTimeZone", String.class);
! if (setSessionTimeZoneMethod != null)
! {
! setSessionTimeZoneMethod.invoke(con, timezoneStr);
! } else
! {
! s_log.error("setTimezoneForSession: setSessionTimeZoneMethod returned by reflection was null. "
! + "Skipped setting session timezone");
! }
! } catch (Exception e)
! {
! s_log.error("Unexpected exception while trying to set session timezone: " + e.getMessage(), e);
! }
! }
/**
--- 481,508 ----
Connection con = session.getSQLConnection().getConnection();
String timezoneStr = prefs.getSessionTimezone();
! try
! {
! if (s_log.isInfoEnabled())
! {
! s_log.info("setTimezoneForSession: attempting to set the session timezone to : " + timezoneStr);
! }
!
! Method setSessionTimeZoneMethod = con.getClass().getMethod("setSessionTimeZone", String.class);
! if (setSessionTimeZoneMethod != null)
! {
! setSessionTimeZoneMethod.setAccessible(true);
! setSessionTimeZoneMethod.invoke(con, timezoneStr);
! }
! else
! {
! s_log.error("setTimezoneForSession: setSessionTimeZoneMethod returned by reflection was null. "
! + "Skipped setting session timezone");
! }
! }
! catch (Exception e)
! {
! s_log.error("Unexpected exception while trying to set session timezone: " + e.getMessage(), e);
! }
! }
/**
|
