UXTerm
Version: latest
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>]
|
fully qualified class name of the JDBC driver to be used for connecting to the database (e.g. |
Basic dbc (SQLLine) shell command guide
-
All commands starts with
!. Others are treated as SQL statements. Use tab for autocompletion. -
Use
!propertiescommand 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
!rehashto fetch data for autocompletion. (Warning: this may take long.) -
Run
!set incremental trueto stop formatting output through buffering. -
Use
!quit,!exitor 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.jarfor MySQL) to$X_HOME/lib/customfolder and restart UXTerm.
Refer the SQLLine manual for more details.
In this topic
In this topic