21

I have a resultset in Eclipse created from an SQL query.

Coming from the world of Visual Studio, I expected to find a watch view of my variable that shows me the resultset as a table instead of just showing all the fields and properties.

Does such a solution exist for Eclipse, maybe as a plugin?

Jonathan Leffler
  • 730,956
  • 141
  • 904
  • 1,278
thedrs
  • 1,412
  • 12
  • 29

2 Answers2

3

Great question!

Sadly, any plugin would have to be created based on the existing debugger. The following article talks about how to create a debugger for a new language in eclipse: http://www.eclipse.org/articles/Article-Debugger/how-to.html

The article gives great details on how the debugging process works in eclipse. I believe this would be a great feature to have in Eclipse and suggest you submit a new feature request: http://www.eclipse.org/stem/feature_request.php

As a work around, I would suggest using a string variable that would contain your query, add that string to your watch list, so you can access it while debugging. Copy the contents of the string and paste it into a tool like SQL Query Analyzer.

James Oravec
  • 19,579
  • 27
  • 94
  • 160
1

I don't know if there is a plugin that will format a ResultSet in the debugger, I've never seen such a thing. However, the Data Tools Platform (DTP) provides tools for interacting with databases, including table views of query results, etc. If you have the Eclipse IDE for Java EE Developers package, DTP is included in that already; otherwise, you can install it.

Here is a good tutorial on using the tools.

Arjan Tijms
  • 37,782
  • 12
  • 108
  • 140
E-Riz
  • 31,431
  • 9
  • 97
  • 134
  • DTP is just a DB browser, it is not related to what I wrote. – thedrs May 17 '12 at 08:37
  • 1
    I pointed out that there probably isn't a plugin to do what you want (which, by the way, isn't really obvious from the wording of the question), but provided an alternative. If you know the query, you can enter it into the DTP tool to get a view of the results that you're looking for. Don't shoot the messenger when you don't like the message. – E-Riz May 17 '12 at 17:19