SQuirreL 2.1 and Oracle Explain

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

SQuirreL 2.1 and Oracle Explain

Tom J Williams Jr




Hello,

I am new to SQuirreL and slowly growing more accustom to it as I have grown
up on Quest's Toad application.  Having said that, you are likely to get
many questions from me regarding Squirrel in the next few months as I learn
the do's and don'ts of Squirrel.

Has anyone out there used the Oracle Explain option in Squirrel?  I am very
curious to see how it functions within Squirrel and would appreciate any
information regarding the use of Explain in Squirrel.

Off topic question...

Where is the best place to download plugins for Squirrel and Oracle?

Regards,
Tom Williams Jr.   ‹N�HS^�隊X���'���u��<�ڂ�.���y�"� �*m�x%jx.j���^�קvƩ�X�jب�ȧ��m�ݚ���v&��קv�^�+����j�Z���{az���^��h��஋�n���)��{h�����ا�׫�+h�(m�����Z��jY�w��ǥrg�y$��Oxḝۍ{�GZ�׮6J�������n��왨��x%��R�諭�l�[�z�%��l���q���z�m��?�X���(��~��zw��X�����b��?��������n���
Reply | Threaded
Open this post in threaded view
|

Re: SQuirreL 2.1 and Oracle Explain

Robert Manning

On 3/6/06, Tom J Williams Jr <[hidden email]> wrote:

Off topic question...

Where is the best place to download plugins for Squirrel and Oracle?

Tom,

The installer that we make available for snapshots and releases now has
the Oracle plugin bundled with it (among other optional plugins).  I can't
speak to your question about explain plan capability as I haven't used it
from squirrel.

Rob

Reply | Threaded
Open this post in threaded view
|

Re: SQuirreL 2.1 and Oracle Explain

joseth_desc-squirrel
In reply to this post by Tom J Williams Jr
Tom,

    I've used it without problems. Just click on the Explain Plan Tab, when you're at the SQL Entry Area and Run your SQL. If you havent got a PLAN_TABLE created, SQuirreL will ask permission to create one. The meaning of the output is Oracle specific, so you must on the online Oracle docs for further information.

    []s
    Francis

Tom J Williams Jr <[hidden email]> escreveu:




Hello,

I am new to SQuirreL and slowly growing more accustom to it as I have grown
up on Quest's Toad application. Having said that, you are likely to get
many questions from me regarding Squirrel in the next few months as I learn
the do's and don'ts of Squirrel.

Has anyone out there used the Oracle Explain option in Squirrel? I am very
curious to see how it functions within Squirrel and would appreciate any
information regarding the use of Explain in Squirrel.

Off topic question...

Where is the best place to download plugins for Squirrel and Oracle?

Regards,
Tom Williams Jr. ‹N¬HS^µéšŠX¬²š'²ŠÞu¼±<Âڂº.Öëy©"ž ®*mŠx%jx.j­…«^ÆקvÆ©¦XœjبžÈ§¶Œm©Ýš†â•éžv&€¶×§vØ^–+ÞÁæÜjËZØèŠ{azšâ™ç^½éh¥ê஋©n·š’)àŠ{h¶¬ì¡Ø§‚׫®+h¯(m¶Ÿÿ±éZ²ëjY‚w­þÇ¥rg–y$‰õ×Oxḝn5ïmjõÛ^¸Ù*®ŠºÞ–Ê¥ºÇ«²f¢–)à–+-J«¢®·¥²©n±êì–+-²Ê.­ÇŸ¢¸ëa¶Úlÿùb²Û,¢êÜyú+éÞ·ùb²Û?–+-ŠwèþÊ®ŠºÞ–Ê¥ºÇ«


Yahoo! Acesso Grátis
Internet rápida e grátis. Instale o discador agora!
Reply | Threaded
Open this post in threaded view
|

Difference between 1.1 and 2.1 with Teradata

Matthew Dahlman
Hi all,
 
I'm hoping someone can help me figure out the reason for the following
behavior (and then how I can get around it).
 
Until recently I was using SQuirreL 1.1. It worked well with a connection to
Teradata (v2r5) with, for example, a simple query like this:
select * from "DEMO_TRG"."TRG_CITY"
 
Now I've switched to SQuirreL 2.1. It's better in almost all respects! But
now when I connect to the same Teradata database using the same JDBC driver,
I get the following error message:
java.sql.SQLException: [NCR][Teradata JDBC Driver]:TeraResultSetMetaData:
function not supported in this version  
 

I have not been able to find a way to get around this. It seems like I must
be missing something obvious--like there's a checkbox somewhere to tell
SQuirreL to just display the results of the query and not to get the result
set metadata. But I can't figure out how to do it.

Anyone have any suggestions?

Regards,
Matt



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|

Re: Difference between 1.1 and 2.1 with Teradata

Gerd Wagner
Matthew Dahlman wrote:

> Hi all,
>  
> I'm hoping someone can help me figure out the reason for the following
> behavior (and then how I can get around it).
>  
> Until recently I was using SQuirreL 1.1. It worked well with a connection to
> Teradata (v2r5) with, for example, a simple query like this:
> select * from "DEMO_TRG"."TRG_CITY"
>  
> Now I've switched to SQuirreL 2.1. It's better in almost all respects! But
> now when I connect to the same Teradata database using the same JDBC driver,
> I get the following error message:
> java.sql.SQLException: [NCR][Teradata JDBC Driver]:TeraResultSetMetaData:
> function not supported in this version  
Could you please send more of the stacktrace. I need to see which
function was called and where.

Thanks

Gerd



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users