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 driver does not support binary / character streams or LOBs.
  • "streamLength" : false if the driver does not support the length information in setCharacterStream and setBinaryStream calls.
  • *setObjectType* : false if driver does provide accurate type information for parameter input. As the result, when importing data, this parameter type should not be passed to setObject call.

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 SQL type information from JDBC type. 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.

importMap is similar to typeMap, except that it is the preferred type for database imports.

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