Sign inSign up

dev050221/ibr_henplus

By dev050221

•Updated over 4 years ago

HenPlus SQL Client - Java based SQL client that works for any database that offers JDBC support

Image
0

366

dev050221/ibr_henplus repository overview

⁠HenPlus SQL Client

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⁠

⁠How to Use This Image

⁠Execute
docker run -it --rm \
--volume $PWD/henplus:/root/.henplus \
dev050221/ibr_henplus
⁠Or Execute
docker run -it --rm \
--volume $PWD/henplus:/root/.henplus \
dev050221/ibr_henplus henplus [jdbc URL]

⁠Local Volumes

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

⁠Executing Scripts

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.

⁠File-Based Databases

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.

⁠Database Drivers

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⁠

Tag summary

Content type

Image

Digest

Size

64.5 MB

Last updated

over 4 years ago

docker pull dev050221/ibr_henplus