Minor jisql suggestion

I've been using jisql for a bit now, and I have a minor suggestion: Change your check for "exit" and "quit" to ignore case. It makes life slightly easier when typing all caps SQL commands.

This message was edited 1 time. Last update was at 09/07/2006 16:47:34

Actually, I took the liberty of making that exact change, plus I added a two more minor tweaks:

1) I added the ability to specify the spacer for columns - which used to be the single char ' '. I did this because of brain-dead Windows' command line copy/paste. It seems that when a line of text ends in space, copy does not copy that space. Which makes it difficult to copy/paste into another program. This can probably be ignored most of the time.

2) I added a loop which outputs Java's column types when the -debug flag is specified.

Thanks! I've integrated that into current code. If you want to make more changes let me know and I'll set you up for the SVN repository.

If you could do me a favor - take a look at the code now and make sure I didn't mess anything up. I ran it through the Eclipse code formatter but it seems to still work fine.

Again, thanks for the help!

This message was edited 2 times. Last update was at 09/08/2006 09:30:44

Sure - I'll take a look, although I doubt if you introduced any problems.

One thought I had was that it would be handy to be able to inject output formatters as a command argument. For example one of the tables I query has a date column. jisql always truncates the date from that table - and I've confirmed this to be a bug in Oracle's JDBC driver. It reports the length incorrectly - giving the size it would be if the numbers are totally unformatted, as opposed to having dashes ( 20060908 versus 2006-09-08 ). It would be nice to be able to specify a properties file that points to a series of objects that can be used for formatting. E.g.

java.sql.Types.DATE=my.formatters.DateFormatter

Fun stuff!!