db ux term

UXTerm

Version: 17.07

Database Client Command

Opens a SQL command line shell inside UXTerm, which can be used to connect to and issue queries against any SQL-compliant database for which JDBC support is available. The command utilizes the SQLLine library, and currently supports all features offered by SQLLine 1.1.9.

db-connect, dbc

This command opens a SQL command line shell inside UXTerm, which can be used to connect to and issue queries against any SQL-compliant database.

Syntax: dbc [-d <driver>]

-d, --driver

fully qualified class name of the JDBC driver to be used for connecting to the database (e.g. com.mysql.jdbc.Driver)

Basic dbc (SQLLine) shell command guide

  • All commands starts with !. Others are treated as SQL statements. Use tab for autocompletion.

  • Use !properties command to connect to the database defined in the specified properties file. A set of sample property values is included in the UXTerm configuration file.

  • Use !record <file> to save command output to files. This is recommended for outputs with more than 5 columns as terminal display isn’t scrollable.

  • Run !rehash to fetch data for autocompletion. (Warning: this may take long.)

  • Run !set incremental true to stop formatting output through buffering.

  • Use !quit, !exit or the end-of-input key combination (Ctrl + D) to exit the shell.

  • If the program cannot find the JDBC Driver, add the respective JAR file (e.g. mysql-connector-java.jar for MySQL) to $X_HOME/lib/custom folder and restart UXTerm.

Refer the SQLLine manual for more details.

In this topic
In this topic
Contact Us