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...
18 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

Database Leak: getConnection() within Spring Transaction

I recently encountered an issue where one of my teammates was experiencing an issue where an application datasource would periodically become exhausted.  After discussing it a few times, we hypothesized that it was a situation where there was a database connection leak.  It was suspected the leak was within boundaries of some application code with a low call rate.  This would line up with, why the application would run for an extended period and then all of a sudden max out its database connections. By inspecting the logs around the times of the database connection pool becoming exhausted it became pretty clear the potential location of the problematic code. The cause of the issue was not a result of necessarily bad code writing, but more of a case of not knowing how legacy semantics would work within the context of a spring transactional boundary. The semantics of how a call to DataSource.getConnection() behaves within the Spring transaction boundary is probably not ...
Post a Comment
Read more