|
From: Wang, T. <Ton...@ar...> - 2009-03-20 17:41:00
|
Another interesting finding: If I have changed the Oracle Global Preferences -> Initialize Session Timezone to America/New_York the reported session time zone is still Los Angeles where my Windows runs. select sessiontimezone from dual returns: -07:00 -----Original Message----- From: Wang, Tony Sent: Friday, March 20, 2009 10:31 AM To: Robert Manning Cc: squ...@li... Subject: Re: [Squirrel-sql-users] Squirrel show <Error> to Oracle timestamp with local time zone" data type Thanks for your response. I still have no luck. Here are what I have done: 1. Download squirrel-sql-3.0-optional.zip from SourceForge. -- It has Oracle plugins. 2. Unzip it to my local drive such as c:\Squirrel3.0 on Windows XP. -- I could not find "squirrel-sql-<version>-install.jar" from the site. 3. Double click C:\Squirrel3.0\SQuirreL SQL Client\squirrel-sql.jar. BTW. The squirrel-sql.bat complained "Could not find the main class. Program will exit.". 4. The Squirrel SQL Client 3.0 starts up. -- Other query without "timestamp with local time zone" works. 5. I have checked the Oracle Global Preferences and it had Initialize Session Timezone set to America/Los_Angeles. 6. I have already had the ojdbc14.jar recognized by Squirrel. Otherwise it would not return something with <Error>. Anyway I have copied ojdbc14.jar to C:\Squirrel3.0\SQuirreL SQL Client\lib. 7. When I run "select * from test" it still returns 1 <Error> -- should be something meaningful timestamp. I must have done something not correct. What did I miss? Thanks for your help. Tony -----Original Message----- From: Robert Manning [mailto:rob...@gm...] Sent: Thursday, March 19, 2009 6:34 PM To: Wang, Tony Cc: squ...@li... Subject: Re: [Squirrel-sql-users] Squirrel show <Error> to Oracle timestamp with local time zone" data type I was able to reproduce this. Yes you configure the local timezone in the Oracle global preferences tab. But, you also need to ensure that ojdbc14.jar is in the classpath for SQuirreL. The easiest way to do this (if you launch with squirrel-sql.bat or squirrel-sql.sh) is to copy ojdbc14.jar into SQUIRREL_HOME/lib directory. Then it should work. Rob On Thu, Mar 19, 2009 at 5:38 PM, Wang, Tony <Ton...@ar...> wrote: > I have also found that under Global Preferneces->Oracle->Initialize Session Time is set to "America/Los Angeles". > > But it still returns <Error> for "Timestamp with local time zone" data type. > > -----Original Message----- > From: Wang, Tony > Sent: Thursday, March 19, 2009 2:26 PM > To: Robert Manning > Cc: squ...@li... > Subject: Re: [Squirrel-sql-users] Squirrel show <Error> to Oracle timestamp with local time zone" data type > > Hi Rob, > > I have downloaded the newest Squirrel SQL Client 3.0 standard and optional files. Where and how do I configure it? > > I tried to write a "alter session set time_zone='America/Los_Angeles'" under Plugins/Session Scripts... > > Then I issued the select * from test and got the same result. > > According to Oracle Plugins Change Log > ================= > > 0.20 > ==== > - Bug #1844898 (TIMESTAMP(6) WITH LOCAL TIME ZONE shows <Error>) > > It should work. > > Please help. > > Thanks, > Tony > > -----Original Message----- > From: Robert Manning [mailto:rob...@gm...] > Sent: Thursday, March 19, 2009 11:43 AM > To: Wang, Tony > Cc: squ...@li... > Subject: Re: [Squirrel-sql-users] Squirrel show <Error> to Oracle timestamp with local time zone" data type > > I believe there is a configuration for this with the Oracle plugin in > 3.0. I don't think it is available for 2.6.x. > > Rob > > On 3/19/09, Wang, Tony <Ton...@ar...> wrote: >> >> >> >> Hi All, >> >> >> >> Does anyone know if Squirrel SQL Client supports Oracle "timestamp with >> local time zone" data type? >> >> >> >> I am using Squirrel SQL Client 2.6.7 and the Database I am accessing is >> Oracle 10g 10.2.0.3.0. >> >> >> >> There is a table defined as: >> >> >> >> CREATE TABLE test ( >> >> id Number NOT NULL, >> >> creation_time TIMESTAMP(3) WITH LOCAL TIME ZONE NOT NULL >> >> ) >> >> >> >> Insert into test(id, creation_time) values (1, timestamp '2009-03-19 >> 00:00:00') >> >> >> >> If you query the table by "select * from test" >> >> >> >> Squirrel will return : >> >> >> >> 1 <Error> >> >> >> >> I believe that session time zone is not set in Squirrel. Does anyone know >> how to show the creation_time correctly? >> >> >> >> Thanks, >> >> Tony >> ------------------------------------------------------------------------------ >> Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are >> powering Web 2.0 with engaging, cross-platform capabilities. Quickly and >> easily build your RIAs with Flex Builder, the Eclipse(TM)based development >> software that enables intelligent coding and step-through debugging. >> Download the free 60 day trial. >> http://p.sf.net/sfu/www-adobe-com >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> >> > > ------------------------------------------------------------------------------ > Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are > powering Web 2.0 with engaging, cross-platform capabilities. Quickly and > easily build your RIAs with Flex Builder, the Eclipse(TM)based development > software that enables intelligent coding and step-through debugging. > Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > ------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
