|
From: Robert M. <rob...@gm...> - 2009-03-20 17:51:58
|
You should get the install jar. The plain zips don't have the installer. Rob On 3/20/09, Wang, Tony <Ton...@ar...> wrote: > 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 > > > |
