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

HTML5 Canvas nightmares with JSF

The last couple of days have been one of those 'why is this so difficult' moments. I essentially lost more than a day trying to figure out how to get HTML5 canvases to show up in one of our JSF applications. Here is the background on the stack: JBoss AS 7.2.0 JDK 1.7.x Seam (JSF Framework) v2.2.0 Richfaces v3.3.3 Essentially we wanted to introduce a canvas to our page in order to graphical represent a numeric value and where it falls upon its normal range and possible range of values.   The page was leveraging a <ui:include> in order to display the results section.  It was a common component used among multiple pages and therefore the reason being pulled in via an include.  A richfaces commandLink was being used to initiate an AJAX request that would pull back none, one or many results and re-render the display within a JSF panelGroup.   Canvas Background:  If you look at any of the examples of using HTML5 canvases, you generally will see the definitio
Post a Comment
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,001 [-] [Pass
2 comments
Read more

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 (Mars) plugin inst
17 comments
Read more