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?

Answers


I've had success with jisql for Oracle and Postgres databases, and it appears to support most databases with JDBC drivers:

http://sourceforge.net/projects/jisql/


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/ ?


Need Your Help

PHP - Strategy for renewing cookie and session in one page application

php session authentication cookies login

I've seen this post: What's a good strategy for renewing the expiration of a forms auth ticket between .net and php?

Commit in PLSQL loop for update

java jdbc plsql

I am using the below function in my java program to copy a column from temporary table to main table.