Database Configurations

.config command is used to configure databases using JSON. It should be noted that such configuration should only be applied before connecting to the database.

Default Configuration

The default configuration can be seen at initrc .

Field Description

protocol indicates which protocol is being configured.

catalogSQL is used by .pwd and .list commands to determine the current catalog.

features list the functionalities that a given database does not support.

  • "catalog" : false if the database does not support catalog.
  • "schema" : false if the database does not support schema.
  • "stream" : false if the database does not support binary / character streams or LOBs.

schemaSQL is used by .pwd and .list commands to determine the current schema.

tableColumnSQL is used by .desc command to list the columns in a table. Jaqy uses MessageFormat to construct the SQL query.

tableSchemaSQL is used by .desc command to show the table schema in SQL. Jaqy uses MessageFormat to construct the SQL query.

typeMap sets up certain type information for properly inferring the type information. JDBC’s DatabaseMetadata.getTypeInfo(). has a number of limitations that makes it difficult to use. Usually only types such as VARCHAR(1000) with variable length information needs to be specified. Jaqy uses MessageFormat to construct the type name, with precision and scale passed to it.

Occasionally, for databases with multiple types for the same type identifier, the most common one to use may be specified here as well.