sqlline.SqlLine.properties Maven / Gradle / Ivy
The newest version!
jline-version: The version of the required {0} library is too old. Version \
"{1}" was found, but "{2}" is required.
enter-for-more: [ Hit "enter" for more ("q" to exit) ]
no-manual: Could not find manual resource.
executing-command: Executing command: {0}
unknown-command: Unknown command: {0}
autocommit-needs-off: Operation requires that autocommit be turned off.
no-current-connection: No current connection
connection-is-closed: Connection is closed
reconnecting: Reconnecting to "{0}"...
connecting: Connecting to "{0}"...
no-driver: No known driver to handle "{0}"
setting-prop: Setting property: {0}
saving-options: Saving preferences to: {0}
loaded-options: Loaded preferences from: {0}
no-specified-driver: Could not find driver {0}
no-specified-driver-use-existing: Could not find driver {0}; using registered driver {1} instead
jdbc-level: JDBC level
compliant: Compliant
jdbc-version: Version
driver-class: Driver Class
help-quit: Exits the program
help-dropall: Drop all tables in the current database
help-connect: Open a new connection to the database
help-commandhandler: Add a command handler
help-manual: Display the SQLLine manual
help-typeinfo: Display the type map for the current connection
help-describe: Describe a table
help-reconnect: Reconnect to the database
help-metadata: Obtain metadata information
help-dbinfo: Give metadata information about the database
help-rehash: Fetch table and column names for command completion
help-verbose: Set verbose mode on
help-run: Run a script from the specified file
help-list: List the current connections
help-all: Execute the specified SQL against all the current connections
help-go: Select the current connection
help-script: Start saving a script to a file
help-brief: Set verbose mode off
help-close: Close the current connection to the database
help-closeall: Close all current open connections
help-isolation: Set the transaction isolation for this connection
help-nativesql: Show the native SQL for the specified statement
help-call: Execute a callable statement
help-autocommit: Set autocommit mode on or off
help-commit: Commit the current transaction (if autocommit is off)
help-rollback: Roll back the current transaction (if autocommit is off)
help-batch: Start or execute a batch of statements
help-help: Print a summary of command usage
help-appconfig: Set custom application configuration class name
help-set: Set a sqlline variable
variables:\
\n\
\nVariables:\
\n\
\nVariable Value Description\
\n=============== ========== ==================================================\
\nautoCommit true/false Enable/disable automatic transaction commit\
\nautoSave true/false Automatically save preferences\
\ncolor true/false Control whether color is used for display\
\ncsvDelimiter String Delimiter in csv outputFormat\
\ncsvQuoteCharacter char Quote character in csv outputFormat\
\ndateFormat pattern Format dates using SimpleDateFormat pattern\
\nfastConnect true/false Skip building table/column list for tab-completion\
\nforce true/false Continue running script even after errors\
\nheaderInterval integer The interval between which headers are displayed\
\nhistoryFile path File in which to save command history. Default is\
\n $HOME/.sqlline/history (UNIX, Linux, Mac OS),\
\n $HOME/sqlline/history (Windows)\
\nincremental true/false Do not receive all rows from server before\
\n printing the first row; uses fewer resources,\
\n especially for long-running queries, but column\
\n widths may be incorrect\
\nisolation LEVEL Set transaction isolation level\
\nmaxColumnWidth integer The maximum width to use when displaying columns\
\nmaxHeight integer The maximum height of the terminal\
\nmaxWidth integer The maximum width of the terminal\
\nnullValue String Use String in place of NULL values\
\nnumberFormat pattern Format numbers using DecimalFormat pattern\
\noutputFormat table/vertical/csv/tsv/xmlattrs/xmlelements/json\
\n Format mode for result display\
\npropertiesFile path File from which SQLLine reads properties on\
\n startup; default is\
\n $HOME/.sqlline/sqlline.properties (UNIX, Linux,\
\n macOS), $HOME/sqlline/sqlline.properties (Windows)\
\nrowLimit integer Maximum number of rows returned from a query; zero\
\n means no limit\
\nshowElapsedTime true/false Display execution time when verbose\
\nshowHeader true/false Show column names in query results\
\nshowNestedErrs true/false Display nested errors\
\nshowWarnings true/false Display connection warnings\
\nsilent true/false Be more silent\
\ntimeFormat pattern Format times using SimpleDateFormat pattern\
\ntimeout integer Query timeout in seconds; less than zero means no\
\n timeout\
\ntimestampFormat pattern Format timestamps using SimpleDateFormat pattern\
\ntrimScripts true/false Remove trailing spaces from lines read from script\
\n files\
\nverbose true/false Show verbose error messages and debug info
help-save: Save the current variables and aliases
help-native: Show the database''s native SQL for a command
help-alias: Create a new command alias
help-unalias: Unset a command alias
help-scan: Scan for installed JDBC drivers
help-sql: Execute a SQL command
help-history: Display the command history
help-record: Record all output to the specified file
help-indexes: List all the indexes for the specified table
help-primarykeys: List all the primary keys for the specified table
help-exportedkeys: List all the exported keys for the specified table
help-importedkeys: List all the imported keys for the specified table
help-procedures: List all the procedures
help-tables: List all the tables in the database
help-columns: List all the columns for the specified table
help-properties: Connect to the database specified in the properties file(s)
help-outputformat: Set the output format for displaying results (table, vertical, csv, tsv, xmlattrs, xmlelements, json)
help-nickname: Create a friendly name for the connection (updates command prompt)
jline-missing: SQLLine static class check reports the {0} class was not found. Please ensure JLine is on classpath.
batch-start: Batching SQL statements. Run "batch" again to execute the batch.
running-batch: Running batched SQL statements...
arg-usage: Usage: {0} <{1}>
scanning: Scanning {0}...
no-such-method: No such method "{0}"
possible-methods: Possible methods:
closing: Closing: {0}
already-closed: Connection is already closed.
error-setting: Error setting configuration: {0}: {1}
no-method: No method matching "{0}" was found in {1}.
connected: Connected to: {0} (version {1})
driver: Driver: {0} (version {1})
autocommit-status: Autocommit status: {0}
isolation-status: Transaction isolation: {0}
isolation-level-not-supported: Transaction isolation level {0} is not supported. Default ({1}) will be used instead.
unknown-format: Unknown output format "{0}". Possible values: {1}
closed: closed
open: open
executing-con: Executing SQL against: {0}
comments: Comments, bug reports, and patches go to {0}
building-tables: Building list of tables and columns for tab-completion \
(set fastconnect to true to skip)...
done: Done
state: state
code: code
invalid-connections: Invalid connection: {0}
script-closed: Script closed. Enter "run {0}" to replay it.
script-already-running: Script ({0}) is already running. Enter "script" with no arguments to stop it.
script-started: Saving command script to "{0}". Enter "script" with no arguments to stop it.
command-canceled: Command canceled.
record-closed: Recording stopped.
record-already-running: Output already being saved to ({0}). Enter "record" with no arguments to stop it.
record-started: Saving all output to "{0}". Enter "record" with no arguments to stop it.
autoloading-known-drivers: No known driver to handle "{0}". Searching for known drivers...
Warning: Warning: {0} (state={1},code={2,number,#})
Error: Error: {0} (state={1},code={2,number,#})
commit-complete: Commit complete
rollback-complete: Rollback complete
halt-query: Canceling query
abort-on-error: Aborting command set because "force" is false and \
command failed: "{0}"
multiple-matches: Ambiguous command: {0}
really-drop-all: Really drop every table in the database? (y/n)\
abort-drop-all: Aborting drop all tables.
drivers-found-count: 0#No driver classes found|1#{0} driver class found|1<{0} driver classes found
rows-selected: 0#No rows selected|1#{0} row selected|1<{0} rows selected
rows-affected: 0#No rows affected|1#{0} row affected|1<{0} rows affected|0>Unknown rows affected
active-connections: 0#No active connections|1#{0} active connection:|1<{0} active connections:
time-ms: ({0,number,#.###} seconds)
cmd-usage: Usage: java sqlline.SqlLine \n \
\ -u the JDBC URL to connect to\n \
\ -n the username to connect as\n \
\ -p the password to connect as\n \
\ -d the driver class to use\n \
\ -nn nickname for the connection\n \
\ -ch [,]* a custom command handler to use\n \
\ -f script file to execute (same as --run)\n \
\ -log file to write output\n \
\ -ac application configuration class name\n \
\ --color=[true/false] control whether color is used for display\n \
\ --csvDelimeter=[delimiter] Delimiter in csv outputFormat\n \
\ --csvQuoteCharacter=[char] Quote character in csv outputFormat\n \
\ --showHeader=[true/false] show column names in query results\n \
\ --headerInterval=ROWS the interval between which headers are displayed\n \
\ --fastConnect=[true/false] skip building table/column list for tab-completion\n \
\ --autoCommit=[true/false] enable/disable automatic transaction commit\n \
\ --verbose=[true/false] show verbose error messages and debug info\n \
\ --showTime=[true/false] display execution time when verbose\n \
\ --showWarnings=[true/false] display connection warnings\n \
\ --showNestedErrs=[true/false] display nested errors\n \
\ --nullValue=[string] use string in place of NULL values\n \
\ --numberFormat=[pattern] format numbers using DecimalFormat pattern\n \
\ --dateFormat=[pattern] format dates using SimpleDateFormat pattern\n \
\ --timeFormat=[pattern] format times using SimpleDateFormat pattern\n \
\ --timestampFormat=[pattern] format timestamps using SimpleDateFormat pattern\n \
\ --force=[true/false] continue running script even after errors\n \
\ --maxWidth=MAXWIDTH the maximum width of the terminal\n \
\ --maxColumnWidth=MAXCOLWIDTH the maximum width to use when displaying columns\n \
\ --silent=[true/false] be more silent\n \
\ --autosave=[true/false] automatically save preferences\n \
\ --outputformat=[table/vertical/csv/tsv/xmlattrs/xmlelements/json]\n \
\ format mode for result display\n \
\ --isolation=LEVEL set the transaction isolation level\n \
\ --run=/path/to/file run one script and then exit\n \
\ --help display this message
© 2015 - 2025 Weber Informatics LLC | Privacy Policy