[Ed ross]

If you folks are looking for items to include in a future release, try this –

be able to create an sql statement from a java editor window.

Can not tell you the number of times I’m looking at a program with sql string that I need to execute.
currently have to copy the string to some editor, strip off all extra stuff and fill in the parmaters.
example:

String aString=”select customer” +
” from customers “+
” where balance>?”;

would love a popup on the string that says “copy 2 sql window” then would copy the statement and prompt for the parameter and stick it into and sql window. Now that would be cool and useful.

thx

ed

[Riyad Kalla]

Ed interesting suggestion. I would encourage you, just for your own sanity, to externalize those strings into a property file and load them at runtime.

I worked on a project with about 110 SQL statements all in Java, one of them was 9 lines long, wrapped with a 80 char magin… that’s just mean.

[Ed ross]

would love to – but there are about 4,500 files with string constants spread throughout. I may not be the brightest guy in the world, but know better than touching that many files. Even with all our great tools, that would take our qa about 600 years before they would finish with nothing to show for the effort but the same app they started with.

[Riyad Kalla]

Wow, I can better understand your request now.

[Author]

Posts