JCON: Generic JDBC console

Install

The project used Conscript package manager. To install conscript, see installation manual.

And execute

cs todesking/jcon

USAGE

Common Options

• --driver-dir <dir>
  • default: ~/.jcon/drivers/
• --driver-classes <classes>
  • ex: --driver-classes com.example.specialdb,com.example.superdb.Driver

Connect to database

jcon [-p|--password <password>] [-u|--user <user>] <jdbc_url>

List all available drivers

jcon --drivers

Default bundled drivers

• Mysql
  • jdbc:mysql://host[:port][/database]
  • Reference
• SQLite
  • jdbc:sqlite:/path/to/file(file), jdbc:sqlite::memory(on-memory database)
  • Reference
• H2 Database Engine
  • jdbc:h2:/path/to/file etc.
  • Reference
• Postgres SQL Database
  • jdbc:postgressql:[//host[:port]/]database
  • Reference

Not bundled drivers

To use external drivers, put driver jars into jcon's drivers directory(default: ~/.jcon/drivers/)

• Oracle
  • Download
• SQL Server
  • Download