Skip to main content

Toad as a plugin for Eclipse


I have been a user of TOAD for multiple years and in the past have used and tried have other database tools. Given the level of familiarity I have with TOAD, I always end up falling back to the use of the product.  Through my career, I have also found that it is the general consensus among developers who are developing for an Oracle backend.

It wasn't until recently though that I discovered the TOAD plugin for Eclipse.  I was intrigued and decided to check it out.  One of the main reasons I decided to give it a whirl is, it's always tough to switch between multiple tools during head down development.  And since I have been managing development teams for multiple years, I have heard developer after developer make comments like 'it would be nice if that was built right into Eclipse' (or whatever the editor of choice).

I was pretty impressed with how well the plugin worked and it really does have some slick features from a java developer perspective.  As indicated above, the biggest pro is not having to leave your Editor to work on some SQL, or investigate some objects in the database.

For anyone interested the Plugin can be accessed and installed from http://www.toadworld.com/products/toad-extension-for-eclipse/default.aspx .

It currently supports Oracle, MySQL and PostgreSQL  and runs on Windows, Linux or Macs.

Some of the features it avails:

  • Full object exploring of database objects (Tables, Views, Sequences, Constraints, etc.)


  • Built in worksheets: SQL worksheets and PL/SQL worksheets
  • Ability to display Explain Plans after executing queries from a worksheet.

  • Provides auto-complete capabilities as you are writing your SQL statements.
  • SQL recall feature that allows you to select previous queries, copy and re-execute.
  • A really slick feature is you can configure your Java projects to allow the plugin to auto detect SQL structures within your code and indicate whether the SQL is valid or invalid across your project.



There is an active community for the Plugin http://www.toadworld.com/products/toad-extension-for-eclipse/default.aspx and it certainly has made life as a developer a little easier. I certainly recommend the plugin and have found the performance of the plugin to be actually very good.

Comments

Post a Comment

Popular posts from this blog

Where to start on AngularJS for Java Developer

Background: If you are a Java developer who is comfortable using Eclipse (JEE Developer version) you may be asking yourself where to start with AngularJS. There is all kinds of documentation out there in regards to AngularJS and https://angularjs.org/ provides, to the point, tutorials on how to get started. You can certainly go that route and use node.js embedded server and possibly a Javascript focused IDE like WebStorm. However I wanted to try and stay in a comfort zone, my comfort zone, of Eclipse and be in a position to deploy an Angular application to a container like Tomcat. This blog entry will present the trail I took to try and accomplish it. Note: This is an adventure into Angular 1.x, not 2.x.  I would imagine this could all work with 2.x as well as it is focused on the dev environment setup. Start: Well the one consistent thing you will find to get started is to install the AngularJS Plugin, provided by Angelo ZERR.  You can use the Eclipse 4.5 (Mar...
19 comments
Read more

WSO2: Simple Pass through proxy (REST to REST with HTML Reply)

Today I set out on trying to set up a simple passthrough proxy that would allow for a GET request to be made to REST style backend services that replies with HTML content. The proxy services was being set up on WS02 ESB v4.8.0.  I thought this was really going to be as simple as walking though their wizard and setting up a new proxy endpoint that just handed off to the behinds the scene service. It was straight forward to set up the proxy, but then unfortunately when called it just didn't respond. It took quite awhile to figure out what the issues was.  At first I was using the ESB admin console and review the System and Application Logs.  The Application Logs were certainly more useful, but they still truncated stack traces which made it hard to clue in on the real issue. It wasn't until I went and review the logs on the server that I was able to detect the cause.   <wso2_esb_root>/repository/logs/wso2-esb-errors.log 2015-03-19 16:09:43,00...
2 comments
Read more

MAC SVN to GIT

Atlasssian provides a wonderful tutorial on how to use their migration scripts to move your subversion code repos to their BitBucket Git Repository  https://www.atlassian.com/git/tutorials/migrating-overview  . However their are a few things that all developers inevitable run into that are not explicitly documented.  I figured I would document the few things I ran into during my migration process and maybe save a few other developers a few moments. Tip 1: Re-mounting sparseimage I was undertaking my migration from MAC OS X (Yosemite).  Since the MAC OS is a case insensitive OS, I had to follow the instructions provided in the Atlasssian Migration guide to "Mount a case-sensitive disk image".  It worked great except of course I had to abandon my efforts and come back the next day.  Well the mount point was gone after I exited my terminal session.  The sparse image still existed. In order to remount the sparseimage I had to use the hdiutil. cd ~...
2 comments
Read more