Toad Extension for Eclipse Forum - Toad Extension for Eclipse - Toad World

Toad Extension for Eclipse Forum

Danny Torres

We are now on Twitter!!! Contact a Technical Support expert today...

Expand content
Do you have a quick support question and short of time? Contact us Via Twitter @ QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

Do you have a quick support question and short of time? Contact us Via Twitter  @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

540 0 / Create an account to join the discussion.
Roboy
Follow / 16 May 2017 at 10:54am / Toad Extension for Eclipse

Laggy writing SQL on Oracle 12 connection/ojdbc7.jar used

Expand content
Hey Team, Since the days when I was supporting TEE I can remember that there were several features/configurations influencing the behavior. I'm experiencing very laggy behavior on Ora 12 connections...

Hey Team,

Since the days when I was supporting TEE I can remember that there were several features/configurations influencing the behavior. I'm experiencing very laggy behavior on Ora 12 connections in Worksheet when writing queries. On Oracle 11 I haven't observed this, maybe just a matter ob database size/object counts loaded etc.

I am on Neon 4.6.3, TEE 2.4.4 (like if there was ever any newer :()

Could you just hint me which configuration options I should try or if any previous experience with this?

Anyway, TEE  and VM memory allocation behavior would deserve some review either, see the screenshot from jconsole...

Cheers,

Lukas

73 0 / Create an account to join the discussion.
jeff.tromp
Follow / 28 May 2015 at 7:02pm / Toad Extension for Eclipse
Latest post by on 15 May 2017 at 11:41am

Timestamp columns are being displayed incorrectly (wrong values)

Expand content
Using Toad for Eclipse and Toad for Mac, when I run the following, I get inaccurate results: SELECT SYSTIMESTAMP FROM DUAL; (All 3 results are run within a couple seconds of each other. I can reproduce...

Using Toad for Eclipse and Toad for Mac, when I run the following, I get inaccurate results:

SELECT SYSTIMESTAMP FROM DUAL;

(All 3 results are run within a couple seconds of each other. I can reproduce this behavior anytime)

Result 1: 05/28/2015 12:39:55  GMT-06:00

Result 2: 05/28/2015 12:43:40  GMT-06:00

Result 3: 05/28/2015 12:48:59  GMT-06:00

Notice the minute changes every run.  

I am using oracle driver: ojdbc7-12.1.02.jar.  I've also tried ojdbc7-12.1.0.1.jar, and ojdbc6-11.2.0.4.jar.  Same behavior.

Data for timestamp columns displayed in the grid is incorrect as well.  Under Grid Options, my time is set to: HH:mm:ss. I've tried multiple date settings.  Same behavior.

7631 3 / Create an account to join the discussion.
Gnl42
Follow / 27 Apr 2017 at 11:12pm / Toad Extension for Eclipse

Plugin "looses" classes

Expand content
I just got this exception when I tried to open a connection: !ENTRY org.eclipse.core.jobs 4 2 2017-04-27 14:15:00.800 !MESSAGE An internal error occurred during: "Connecting: teacheval_access@pairverf"...

I just got this exception when I tried to open a connection:

!ENTRY org.eclipse.core.jobs 4 2 2017-04-27 14:15:00.800
!MESSAGE An internal error occurred during: "Connecting: teacheval_access@pairverf".
!STACK 0
java.lang.NoClassDefFoundError: com/dell/reactive/impl/Values
at com.dell.toadext.reactive.handler.FeatureEventHandler.getOptionalValues(FeatureEventHandler.java:41)
at com.dell.toadext.reactive.handler.ConnectionEventHandler.run(ConnectionEventHandler.java:26)
at com.dell.toadext.event.broker.EventBroker.send(EventBroker.java:40)
at com.dell.toadext.core.AbstractConnector.connect(AbstractConnector.java:373)
at com.dell.toadext.core.AbstractConnector.logon(AbstractConnector.java:778)
at com.dell.toadext.ui.jobs.LogonJob$InternalLogonJob.run(LogonJob.java:93)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: java.lang.ClassNotFoundException: com.dell.reactive.impl.Values cannot be found by com.dell.toadext.reactive_2.4.4.201607260946
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:461)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:372)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:364)
at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:161)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)

And I've something similar every so often when I try to exit eclipse which prevents eclipse from
exiting. I end up having to kill the process

98 0 / Create an account to join the discussion.
Gnl42
Follow / 27 Apr 2017 at 11:08pm / Toad Extension for Eclipse

Plugin makes eclipse unusable

Expand content
As soon as I open an oracle connection, my eclipse instance starts seizing up, sometimes over a minute. And this continues even after I close the connection. The only way to make eclipse usable again...

As soon as I open an oracle connection, my eclipse instance starts seizing up,
sometimes over a minute. 
And this continues even after I close the connection.

The only way to make eclipse usable again is to restart the instance, which is a pain.

The UI monitor sometimes complains with entries like this:

!SUBENTRY 1 org.eclipse.ui.monitoring 1 0 2017-04-27 14:47:55.246
!MESSAGE Sample at 14:47:55.215 (+1.199s)
Thread 'main' tid=1 (RUNNABLE)
!STACK 0
Stack Trace
at java.util.ArrayList.indexOf(ArrayList.java:316)
at java.util.ArrayList.contains(ArrayList.java:300)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:153)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:287)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:227)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElementsRecursive(ModelServiceImpl.java:241)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElements(ModelServiceImpl.java:394)
at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.findElements(ModelServiceImpl.java:387)
at org.eclipse.ui.internal.WorkbenchPage.getViewReferences(WorkbenchPage.java:2530)
at org.eclipse.ui.internal.WorkbenchPage.getViewReferences(WorkbenchPage.java:2520)
at org.eclipse.ui.internal.WorkbenchPage.findViewReference(WorkbenchPage.java:1971)
at org.eclipse.ui.internal.WorkbenchPage.findView(WorkbenchPage.java:1962)
at com.dell.toadext.ui.views.ViewHelper.find(ViewHelper.java:50)
at com.dell.toadext.ui.views.ViewHelper.findConnectionsView(ViewHelper.java:60)
at com.dell.toadext.ui.handlers.AbstractConnectionHandler.getSite(AbstractConnectionHandler.java:60)
at com.dell.toadext.ui.handlers.AbstractConnectionHandler.licenceHasExpired(AbstractConnectionHandler.java:80)
at com.dell.toadext.ui.connections.NewConnectionHandler.isEnabled(NewConnectionHandler.java:125)

eclipse.buildId=4.6.3.M20170301-0400
java.version=1.8.0_121
java.vendor=Oracle Corporation
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_CA
Command-line arguments: -os win32 -ws win32 -arch x86_64 -data file:/W:/workspace/

99 0 / Create an account to join the discussion.
adam.m.mcelhinney
Follow / 3 Nov 2014 at 11:47pm / Toad Extension for Eclipse
Latest post by on 18 Apr 2017 at 2:49pm

SQL Problems Window Background is all black

Expand content
I am an Eclipse noob, so apologize if these are dumb questions. Running Eclipse Luna 4.4.1 with Java 1.7.0_72. The SQL Problems window in the Toad for Eclipse plug-in has black text with a black background...

I am an Eclipse noob, so apologize if these are dumb questions.

Running Eclipse Luna 4.4.1 with Java 1.7.0_72.

The SQL Problems window in the Toad for Eclipse plug-in has black text with a black background. I have gone through all of the different preferences I can find in Eclipse and I cannot find one that changes this background to be another color. 

Does anyone know how to do this?

Secondarily, when I execute many-line queries, the error statement is displayed in the SQL Problems window at the top, with the whole text of the query at the bottom. This means that I have to scroll to the top everytime I want to view the error message (I also have to highlight the section, because its black text on a black background, per my first question). Does anyone know a fix for these issues? 

Thanks so much for the help.

Unanswered 12078 5 / Create an account to join the discussion.
Daniel K.
Follow / 28 Mar 2017 at 3:00pm / Toad Extension for Eclipse

TEE opens up multiple connections to Oracle Db. Why?

Expand content
Hi, TEE is a great tool, but there is something me and my DBA do not understand. When I open up seemingly one connection in eclipse, TEE actually opens up three connections (I can monitor this via nettop...

Hi,

TEE is a great tool, but there is something me and my DBA do not understand. When I open up seemingly one connection in eclipse, TEE actually opens up three connections (I can monitor this via nettop on my device and my DBA also sees them on the server). The amount of connections can get even bigger and TEE seems to open and close some of them without obvious reasons for me as the user. As this of course means an overhead for our database, we would like to understand what causes TEE to do this. Is it some feature I could turn off? Do I trigger this with something I am not aware of? Even if I could not switch it off it would be nice to understand why this is happening.

Any hint is appreciated! Thanks.

PS. This was tested on a mac book pro 10.12.3 and an Ubuntu 16.04 - with the same results.

Best regards,

Daniel

141 0 / Create an account to join the discussion.
Russell_Nash
Follow / 22 Mar 2017 at 8:43am / Toad Extension for Eclipse

Syntax error using PostgreSQL/Postgis

Expand content
Hi, I am using the Toad Extension with PostgreSQL/Postgis. When creation the geometry column using something like "geom geometry (Polygon, 31467)" I always get a Syntax error Execution...

Hi,

I am using the Toad Extension with PostgreSQL/Postgis.

When creation the geometry column using something like "geom geometry (Polygon, 31467)" I always get a Syntax error

Execution works fine. It is just a little bit annoying.

Any tips to solve this?

Unanswered 135 0 / Create an account to join the discussion.
mattcsl
Follow / 21 Feb 2017 at 6:44pm / Toad Extension for Eclipse

HIghlight Occurrences?

Expand content
Does SQL Worksheet editor have anyway to highlight all occurrences of a selected word/keyword? How do I configure this?

Does SQL Worksheet editor have anyway to highlight all occurrences of a selected word/keyword? How do I configure this?

218 0 / Create an account to join the discussion.
gggaaa
Follow / 12 Feb 2017 at 7:09am / Toad Extension for Eclipse

Queries are executed but no output is printed (PostgreSQL)

Expand content
I'm able to connect and execute queries on a PostreSQL DB. But I cannot see any output. For example: DO $$ Begin raise notice 'Hi world'; END$$ Runs successfully (appears on SQL Recall...

I'm able to connect and execute queries on a PostreSQL DB. But I cannot see any output.

For example:

DO $$
Begin
raise notice 'Hi world';
END$$

Runs successfully (appears on SQL Recall window with a green icon), but I can't find the output anywhere (DBMS Output, SQL monitor, DB Problems, DB Console, Result).

On PGAdmin, such messages appear under "Messages" window.

Moreover, on PGAdmin I get all the messages regarding creation\deletion of tables (every queries output) which is missing in Toad.

Any ideas?

My Setup:

JDBC driver: 9.4.1212 (9.4)

PostgreSQL 9.4

Latest version of Toad.

Eclipse Version: Neon.2 Release (4.6.2).

280 0 / Create an account to join the discussion.
JanD
Follow / 21 Feb 2016 at 11:17am / Toad Extension for Eclipse
Latest post by on 7 Feb 2017 at 12:15am

TEE 2.3.6: Paste is not working

Expand content
After Update to 2.3.6 I'm not able to paste any text from clipboard into the toad-editor(s) (SQL-Worksheet, Stored Procedure Editor. Copy works as I can copy text from toad-editor and paste it somewhere...

After Update to 2.3.6 I'm not able to paste any text from clipboard into the toad-editor(s) (SQL-Worksheet, Stored Procedure Editor.

Copy works as I can copy text from toad-editor and paste it somewhere else (eclipse standard texteditor)

As I go back to 2.3.4 paste works as expected.

Happens only if I open a sql-file from project without toad-nature AND do not open any sql-file from a project with toad nature-before.

  • Ubuntu 14.04.1
  • Eclipse Luna.1
  • Oracle Java7

BTW: The new version 2.3.6 makes a very stable impression. GOOD JOB!

Jan

Unanswered 2653 5 / Create an account to join the discussion.
jc1224
Follow / 23 Jan 2017 at 1:20pm / Toad Extension for Eclipse

Data Grid DOES NOT work - NEED HELP

Expand content
Hello, i have Eclipse Version: Neon.2 Release (4.6.2). Installed Toad™ Extension for Eclipse - Community Edition 2.4.4.201607260946 com.dell.toadext.feature.feature.group Dell. I use Toad...

Hello,

i have Eclipse Version: Neon.2 Release (4.6.2).

Installed Toad™ Extension for Eclipse - Community Edition 2.4.4.201607260946 com.dell.toadext.feature.feature.group Dell.

I use Toad more than 1 year now in Version: Mars.1 Release (4.5.1).

But with the new Eclipse or the new Toad the data grid (where clause) does not work.

Normally when I did write here    my condition in the data grid only the results regarding the where clause were shown.

NOW: The data grid shows ALL rows. But does not use the where clause. Is does simple nothing - as if it would not exist. Or deactivated.

Can someone help me?

Unanswered 339 0 / Create an account to join the discussion.
ssnyder
Follow / 16 Dec 2016 at 3:33pm / Toad Extension for Eclipse
Latest post by on 17 Jan 2017 at 9:44pm

Mongo - Message when using aggregate(): Cannot use 'commands'...

Expand content
How can I set it up to use an older version of the client? I've tried setting a compatible java driver but it doesn't matter. I get the message when I try to do a query using aggregate()....not...

How can I set it up to use an older version of the client?  I've tried setting a compatible java driver but it doesn't matter.

I get the message when I try to do a query using aggregate()....not when I use find().

Running version() - I get 3.2.4

db.version() - I get 3.0.10

I've got v 3.0.4 java driver selected in the connection properties, but it doesn't seem to change it.

Thanks.

907 1 / Create an account to join the discussion.
Robert Munteanu

Preventing the 'Database Settings' welcome dialog from ap...

Expand content
Hi, When starting up with a new workspace and Toad for Eclipse installed I always get the dialog to select the database engine I'm working for. The thing is: Toad is not a central part of my...

Hi,


When starting up with a new workspace and Toad for Eclipse installed I always get the dialog to select the database engine I'm working for.

The thing is:

  1. Toad is not a central part of my workflow, so I'd rather configure it when needed - the popup is quite intrusive
  2. I have already configured the preferences in the workspace using Eclipse Oomph - the 'toadext.defaultNewConnection' property is set to MYSQL

What can I do to prevent the welcome dialog from Toad from appearing?

Thanks,


Robert

Unanswered 277 0 / Create an account to join the discussion.
Anonymous
Follow / 24 Nov 2016 at 2:57am / Toad Extension for Eclipse
Latest post by Anonymous on 16 Dec 2016 at 5:23am

Toad extension for Eclipse stuck loading Oracle table columns

Expand content
The Toad extension (current version, just downloaded 2.4.4.201607260946) seems unable to display any columns of my tables (Oracle 11.2.0.3 using ojdbc6.jar). Eclipse version is neon (4.6, build I20160606...

The Toad extension (current version, just downloaded 2.4.4.201607260946) seems unable to display any columns of my tables (Oracle 11.2.0.3 using ojdbc6.jar). Eclipse version is neon (4.6, build I20160606-1100).

This happens in the Object Explorer...

... as well as in the table viewer/editor...

... and also in the Quick Doc view:

All of them just seem to get stuck on "Loading..." but never return the table's columns.

This happens both in local DBs and in remote ones - connections work fine, I can run queries (though I get an awful lot of NPEs when formatting SQL or triggering auto-completion), but I can't see what columns a table has...

Any way to work around this, or is a fix on the horizon?

Any help would be appreciated, thanks in advance. :-)

Unanswered 566 1 / Create an account to join the discussion.
mmoore
Follow / 13 Dec 2016 at 8:22pm / Toad Extension for Eclipse

Bugs, PostgreSQL Function Script generation

Expand content
CREATE OR REPLACE FUNCTION pxportal_blurb__fgetblurbs_new(IN p_web_site_key_i bigint, IN p_question_set_key_i bigint, IN p_vendor_key_i bigint, IN p_dealer_key_i bigint, IN p_service_key_i bigint, IN p_language_name_i...

CREATE OR REPLACE FUNCTION pxportal_blurb__fgetblurbs_new(IN p_web_site_key_i bigint, IN p_question_set_key_i bigint, IN p_vendor_key_i bigint, IN p_dealer_key_i bigint, IN p_service_key_i bigint, IN p_language_name_i text DEFAULT 'ENGLISH-USA'::text, IN p_blurb_type_codes_i text DEFAULT NULL::text, IN p_blurb_position_i text DEFAULT NULL::text, IN p_article_post_start_date_i timestamp without time zone DEFAULT NULL::timestamp without time zone, IN p_article_post_end_date_i timestamp without time zone DEFAULT NULL::timestamp without time zone, IN p_article_meta_keyword_i text DEFAULT NULL::text, IN p_article_file_name_i text DEFAULT NULL::text, IN p_retrieve_file_blurb_flag_i text DEFAULT 'N'::text, IN p_matching_type_i text DEFAULT 'BROAD'::text, IN p_level_i bigint DEFAULT 2, IN p_subjecthier_i text DEFAULT NULL::text, IN p_qualhier_i text DEFAULT NULL::text, IN p_partition_by2tcode_i text DEFAULT '184420)

The above line was create by 'generate script' The part in yellow should be '184420,98765')

When using pgAdmin III it show correctly.

 

Also,

declare

ss text; --Sql Select clause
sw text; --Sql Where clause
v_language_name tx_language.language_name%type := p_language_name_i;

:= is flagged as a Syntax error. It's not. 

Regards,

Mike

 

297 0 / Create an account to join the discussion.
klopp
Follow / 9 Dec 2016 at 10:23am / Toad Extension for Eclipse

Colors for "where" field

Expand content
How do I change the colors in the "where" field for table view?

How do I change the colors in the "where" field for table view?

Unanswered 288 0 / Create an account to join the discussion.
srattans
Follow / 12 Mar 2012 at 8:50pm / Toad Extension for Eclipse
Latest post by on 11 Nov 2016 at 11:31am

Git Plugin

Expand content
Is there a GIT plugin for TEE?
Is there a GIT plugin for TEE?
12709 2 / Create an account to join the discussion.
paul.harrison_765
Follow / 7 Oct 2016 at 2:00pm / Toad Extension for Eclipse
Latest post by on 26 Oct 2016 at 12:56pm

PLSQL Editor hanging when typing coments

Expand content
Hi I keep coming back to the TOAD plugin for Eclipse and want to use it, but as soon as I start working on my PL/SQL packages, things are either extremely slow or just hang! I have a small package and...

Hi


I keep coming back to the TOAD plugin for Eclipse and want to use it, but as soon as I start working on my PL/SQL packages, things are either extremely slow or just hang! I have a small package and am just trying to type a comment and it just hangs. Two times Iwanted for 20 - 30 seconds for the editor to become active again and now (the thrid time of hanging in 2 min) it just hangs and I need to kill the eclipse service.


Does anybody really use this plugin for extensive PL/SQL development? The rest of the plugin is great! I love the table editors and Worksheets. This I can use for sure, but in the end my main work is PL/SQL development and the editor just doesn't work.

The picture below shows what pops up when I am writing the comment. Then it hangs. For some reason, the colouring changes on each letter I type, this cannot be efficient. Especially when writing comments, anything after a "--" should be a comment.

1500 8 / Create an account to join the discussion.
paul.harrison_765

Text Colors on Stored Procedure Editor not taking effect

Expand content
I am tryng to set colors on the Stored Procedure editor but they are not all taking effect. For example, when I set a color for datatypes, my NUMBER, VARCHAR etc, declerations are still black.

I am tryng to set colors on the Stored Procedure editor but they are not all taking effect. For example, when I set a color for datatypes, my NUMBER, VARCHAR etc, declerations are still black.

717 0 / Create an account to join the discussion.