Are there any mature command line JDBC clients?
I am trying to create a set of test scripts that will perform black-box testing of something that works with database. For that I need to issue SQL commands from standard input or file, which was quite possible with "mysql" client, but now we use other database, which has only jdbc driver. I need the same basic functionality in command line as mysql client has, but for any jdbc powered database. Is that possible without programming my custom java tool?
I've had success with jisql for Oracle and Postgres databases, and it appears to support most databases with JDBC drivers:
This one is pretty commonly used, works with any SQL database, and is pretty well supported: https://github.com/julianhyde/sqlline
Do you mean something like http://web.quuxo.com/products/jdbctool/ ?
Edit 6/22: How about HenPlus then: http://henplus.sourceforge.net/ ?