HenPlus SQL Client - Java based SQL client that works for any database that offers JDBC support
366
Hen*Plus is a SQL shell written in Java that works for any database that offers JDBC support. So basically any database. Hen*Plus can handle multiple open sessions in parallel. The command line interface provides the usual history functions features and TAB-completion for commands, tables and columns.
More details at https://github.com/neurolabs/henplus
docker run -it --rm \
--volume $PWD/henplus:/root/.henplus \
dev050221/ibr_henplus
docker run -it --rm \
--volume $PWD/henplus:/root/.henplus \
dev050221/ibr_henplus henplus [jdbc URL]
The container creates a henplus folder in the current directory on the Docker host. It stores the Hen*Plus configuration files, and folders for SQL scripts, local databases, and JDBC drivers.
The henplus folder is initially owned by user root. To change ownership execute below command:
sudo chown -R [user]:[group] henplus
You can load and execute SQL scripts in Hen*Plus using command start scripts/[script name].
SQL script files need to be stored in henplus/scripts/ folder on Docker host.
This Docker image comes with a sample SQL file northwind.sql.
Hen*Plus can connect to file based databases. Database files need to be stored in henplus/data/ folder.
This Docker images comes with a sample H2 database northwind. The user id is sa and password is sa.
Place the database JDBC driver JARs in the folder henplus/jdbc/ and Hen*Plus will load the drivers automatically.
This Docker images comes with H2 Database driver. You can download almost any JDBC driver from the maven repository.
(Want to try H2 Database? Download my H2 Docker Image).
Hen*Plus Copyright © Henner Zeller [email protected]
JavaReadline Copyright © Bernhard Bablok https://github.com/aclemons/java-readline
GNU readline Copyright © Brian Fox, Chet Ramey
This Docker image is provided AS IS and comes with ABSOLUTELY NO WARRANTY.
This is free software, and you are welcome to redistribute it under the
conditions of the GNU Public License http://www.gnu.org/licenses/gpl2.txt
Content type
Image
Digest
Size
64.5 MB
Last updated
over 4 years ago
docker pull dev050221/ibr_henplus