4.16. The SQLLine Utility

The Kodo distribution includes SQLLine, a console-based
utility that interacts directly with a database using
raw SQL. It is similar to other command-line database
access utilities like sqlplus for Oracle,
mysql for MySQL, and isql for
Sybase/SQL Server. SQLLine can be useful as debugging tool by enabling
low-level SQL interaction with the database.

SQLine is open-source software developed by Oracle. For
complete documentation, see the project home page at
http://sqlline.sourceforge.net. The remainder of
this section discusses scenarios using SQLLine to assist
with understanding and developing Kodo applications.

Note

As a separate utility, Oracle does not provide
technical support for SQLLine.

0: jdbc:hsqldb:tutorial_database> !help
!all Execute the specified SQL against all current connections
!autocommit Set autocommit mode on or off
!batch Start or execute a batch of statements
!brief Set verbose mode off
!call Execute a callable statement
!close Close the current connection to the database
!closeall Close all current open connections
!columns List all the columns for the specified table
!commit Commit the current transaction (if autocommit is off)
...