squirrel-sql-users

[Squirrel-sql-users] SQuirreL 2.1 and Oracle Explain

[Tom J W. Jr <twi...@cs...>]

DQoNCg0KDQpIZWxsbywNCg0KSSBhbSBuZXcgdG8gU1F1aXJyZUwgYW5kIHNsb3dseSBncm93aW5n
IG1vcmUgYWNjdXN0b20gdG8gaXQgYXMgSSBoYXZlIGdyb3duDQp1cCBvbiBRdWVzdCdzIFRvYWQg
YXBwbGljYXRpb24uICBIYXZpbmcgc2FpZCB0aGF0LCB5b3UgYXJlIGxpa2VseSB0byBnZXQNCm1h
bnkgcXVlc3Rpb25zIGZyb20gbWUgcmVnYXJkaW5nIFNxdWlycmVsIGluIHRoZSBuZXh0IGZldyBt
b250aHMgYXMgSSBsZWFybg0KdGhlIGRvJ3MgYW5kIGRvbid0cyBvZiBTcXVpcnJlbC4NCg0KSGFz
IGFueW9uZSBvdXQgdGhlcmUgdXNlZCB0aGUgT3JhY2xlIEV4cGxhaW4gb3B0aW9uIGluIFNxdWly
cmVsPyAgSSBhbSB2ZXJ5DQpjdXJpb3VzIHRvIHNlZSBob3cgaXQgZnVuY3Rpb25zIHdpdGhpbiBT
cXVpcnJlbCBhbmQgd291bGQgYXBwcmVjaWF0ZSBhbnkNCmluZm9ybWF0aW9uIHJlZ2FyZGluZyB0
aGUgdXNlIG9mIEV4cGxhaW4gaW4gU3F1aXJyZWwuDQoNCk9mZiB0b3BpYyBxdWVzdGlvbi4uLg0K
DQpXaGVyZSBpcyB0aGUgYmVzdCBwbGFjZSB0byBkb3dubG9hZCBwbHVnaW5zIGZvciBTcXVpcnJl
bCBhbmQgT3JhY2xlPw0KDQpSZWdhcmRzLA0KVG9tIFdpbGxpYW1zIEpyLiAgIOKAuQ==

Re: [Squirrel-sql-users] SQuirreL 2.1 and Oracle Explain

[Robert M. <rob...@gm...>]

On 3/6/06, Tom J Williams Jr <twi...@cs...> 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

Re: [Squirrel-sql-users] SQuirreL 2.1 and Oracle Explain

[<jos...@ya...>]

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 <twi...@cs...> 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!

[Squirrel-sql-users] Difference between 1.1 and 2.1 with Teradata

[Matthew D. <mda...@su...>]

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

Re: [Squirrel-sql-users] Difference between 1.1 and 2.1 with Teradata

[Gerd W. <bir...@t-...>]

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