SQLJC

Along the theme of database tools, I thought I’d also mention SQLJC. It is a command line oriented tool to run scripts against a database or let you interactively work with databases from a CLI. I found it very helpful the other day when I wanted to do some automated testing because I could use it to run scripts which cleaned out a database and prepared it for a run, then our application was run. A batch file looped that sequence over and over again and we could see the failures much more easily than my repeatedly trying to do the same thing over and over again without making a mistake and forgetting a step.

Advertisements