SQL Results display question

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: SQL Results display question

On Thu, Jan 04, 2007 at 11:55:10AM -0600, Savoy, Melinda wrote:
> Is there a way, I just can't find it I guess, where when I run 2 sql
> statements at the same time which I have done and see both resultsets in
> two separate results windows?

If you select both queries with the mouse and execute them
(<ctrl><enter>) you will get the results in 2 separate tabs. You can
tear off a tab into a separate window by clicking the middle icon
(the one with an arrow pointing to the top right) at the top right of
the tab.

For more info see "Executing SQL" in the SQuirreL help file.

--

-- 
Colin Bell

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

Updated 2.4 install jar

There is an updated install jar that now contains a library file
(jxl.jar) that was missing from the previous version of the installer.
 The symptom was that the CSV/Excel export feature didn't appear to do
anything.  The previous version of the install jar also removed the
JDK panel so the problem regarding use of a JRE instead of a JDK
should be resolved now as well. I'll make updated plain zip
distribution files available within a day.  The version is still at
2.4 as there was no substantive change to the software itself - merely
changes to fix the packaging. Please try out the latest 2.4 installer
if you can and let me know if there are any more issues not previously
identified (manningr [at] users [dot] sourceforge [dot] net)

Rob Manning

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

Re: Updated 2.4 install jar

The plain zip distribution files are now available as well (the
previous version of these files was missing the jxl.jar file)

Rob

On 1/4/07, Robert Manning <robert.m.manning <at> gmail.com> wrote:
> There is an updated install jar that now contains a library file
> (jxl.jar) that was missing from the previous version of the installer.
>  The symptom was that the CSV/Excel export feature didn't appear to do
> anything.  The previous version of the install jar also removed the
> JDK panel so the problem regarding use of a JRE instead of a JDK
> should be resolved now as well. I'll make updated plain zip
> distribution files available within a day.  The version is still at
> 2.4 as there was no substantive change to the software itself - merely
> changes to fix the packaging. Please try out the latest 2.4 installer
> if you can and let me know if there are any more issues not previously
> identified (manningr [at] users [dot] sourceforge [dot] net)
>
> Rob Manning
>

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

Re: SQL Results display question

Thanks Colin.  I'll try that again.  When I ran both queries initially I
did not see another tab just one result tab.  I did not click the key
combination though of <ctrl><enter> so that I guess is the difference.

Thanks again.  Regards. 

-----Original Message-----
From: Colin Bell [mailto:col <at> baibell.org] 
Sent: Thursday, January 04, 2007 4:43 PM
To: Savoy, Melinda
Cc: squirrel-sql-users <at> lists.sourceforge.net
Subject: Re: [Squirrel-sql-users] SQL Results display question

On Thu, Jan 04, 2007 at 11:55:10AM -0600, Savoy, Melinda wrote:
> Is there a way, I just can't find it I guess, where when I run 2 sql 
> statements at the same time which I have done and see both resultsets 
> in two separate results windows?

If you select both queries with the mouse and execute them
(<ctrl><enter>) you will get the results in 2 separate tabs. You can
tear off a tab into a separate window by clicking the middle icon (the
one with an arrow pointing to the top right) at the top right of the
tab.

For more info see "Executing SQL" in the SQuirreL help file.

--
Colin Bell

The information contained in this message and any attachments is intended only for the use of the
individual or entity to which it is addressed, and may contain information that is PRIVILEGED,
CONFIDENTIAL, and exempt from disclosure under applicable law.  If you are not the intended recipient,
you are prohibited from copying, distributing, or using the information.  Please contact the sender
immediately by return e-mail and delete the original message from your system.

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

Linux Installation

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Displaying Oracle TIMESTAMPTZ columns

I'm using v2.4, running on Linux w/JDK 1.5 to access an Oracle 9i database
that has TIMESTAMPTZ columns (declared as "TIMESTAMP WITH TIME ZONE"). The
results page, however, shows any of these column values as
"<Unknown(-101)>".

When I look at the metadata for the query, the getColumnType is returning
-101 for these, and getColumnTypeName is returning "TIMESTAMPTZ".

I installed the Oracle plugin with SQuirrel SQL, and am using the Oracle
Thin driver for 10g (oracle-jdbc-thin-10.1.0.2-g.jar), the same driver we
are using in our application code to go against this database. I've tried
changing the Global Preferences settings for "Data Type Controls" for the
Timestamp fields, but none seem to have any effect.

Any tips or clues appreciated.
John

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

loading schemas on squirrel startup

Hi All,

When I started using Squirrel in 2004, a session would start up and 
load/list all schemas for a DB instance into the leftmost panel of the 
object tree screen.  Somewhere along the way, later versions began loading 
(or displaying, anyway) only the schema corresponding to the username.  This 
was better for me, as there are hundreds of schemas on our Oracle 
development instance.  I installed Squirrel 2.4 today, and it is back to the 
original behavior.

Is there any way to configure this, or a known reason why this has changed 
??  I have played with the load schemas and filter options in the new 
session properties panel, but they don't do what I would have expected and I 
haven't been able to get the previous behavior.

Thanks,

Mark

_________________________________________________________________
>From photos to predictions, The MSN Entertainment Guide to Golden Globes has 
it all. http://tv.msn.com/tv/globes2007/?icid=nctagline1

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

Re: loading schemas on squirrel startup

On 1/11/07, Mark Neher <markneher <at> hotmail.com> wrote:
> Hi All,
>
> When I started using Squirrel in 2004, a session would start up and
> load/list all schemas for a DB instance into the leftmost panel of the
> object tree screen.  Somewhere along the way, later versions began loading
> (or displaying, anyway) only the schema corresponding to the username.  This
> was better for me, as there are hundreds of schemas on our Oracle
> development instance.  I installed Squirrel 2.4 today, and it is back to the
> original behavior.
>
> Is there any way to configure this, or a known reason why this has changed
> ??  I have played with the load schemas and filter options in the new
> session properties panel, but they don't do what I would have expected and I
> haven't been able to get the previous behavior.

I think you will be pleasantly surprised.  Although the original
behavior is there by default, you now have the ability to choose which
schemas get loaded on startup. See Alias Properties when you right
click on the alias.  Let me know if anything is unclear.

Rob

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

Re: Linux Installation

On Mon, Jan 08, 2007 at 11:34:39AM -0800, Andrew Melton wrote:
> Whenever I launch squirrel-sql.sh, I get a blank squirrel 2.4 window.  There
> is a title bar to the window with the acorn icon and "SQuirrel SQL Client
> Version 2.4" written in the title bar.  But, there is nothing else.
> The first time I run the program, a help window appears as well, but it is
> gone on subsequent instances.
> 
> I am running Squirrel 2.4 with FC6 and java version "1.5.0_10"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_10-b03)
> Java HotSpot(TM) Client VM (build 1.5.0_10-b03, mixed mode, sharing)
> 
> Even before trying to register/configure a driver, should I not see program
> options in the main window?  I read the archives, and saw a problem with
> Java 6 which sounded similar.  I had been using 6 as well, so I downgraded
> to 5.  That didn't seem to help, but I'm wondering whether that could still
> be contributing.

Could be your video drivers.

Could be this Java bug
<http://bugs.sun.com/bugdatabase/view_bug.do;jsessionid=dcb5b73ca8dc9ffffffffcd4efff679200cb:WuuT?bug_id=6429775>

What happens when you take menu options?

--

-- 
Colin Bell

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV