# ij properties reference

When starting up `ij`, you can specify properties on the command line or in a properties file.

See Starting ij using properties for details.

- ij.connection.connectionName property
  The ij.connection.connectionName property creates a named connection to the given database connection URL when ij starts up.
- ij.database property
  The ij.database property creates a connection to the database specified by the property when ij starts up.
- ij.dataSource property
  The ij.dataSource property specifies the datasource to be used to access the database.
- ij.exceptionTrace property
  The ij.exceptionTrace property specifies whether ij should display a full exception stack trace when exceptions occur.
- ij.maximumDisplayWidth property
  The ij.maximumDisplayWidth property specifies the maximum number of characters used to display any column.
- ij.outfile property
  The ij.outfile property specifies a file to which the system should direct output for a session.
- ij.password property
  The ij.password property specifies the password used to make connections.
- ij.protocol property
  The ij.protocol property specifies the default protocol and subprotocol portions of the database connection URL for connections.
- ij.protocol.protocolName property
  The ij.protocol.protocolName property is similar to the ij.protocol property. The only difference is that it associates a name with the value, thus allowing you to define and use more than one protocol.
- ij.showErrorCode property
  The ij.showErrorCode property specifies whether ij should display the SQLException ErrorCode value with error messages.
- ij.showNoConnectionsAtStart property
  The ij.showNoConnectionsAtStart property specifies whether the connections message should be displayed when ij is started.
- ij.showNoCountForSelect property
  The ij.showNoCountForSelect property specifies whether to display messages indicating the number of rows selected.
- ij.URLCheck property
  The ij.URLCheck property specifies whether ij should check for invalid or non-Derby URL attributes when you are using the embedded driver.
- ij.user property
  The ij.user property specifies the login name used to establish the connection.
- derby.ui.codeset property
  The derby.ui.codeset property specifies an alternative supported character encoding value when you use one of the Derby tools with a language not supported by your default system.
- derby.ui.locale property
  The derby.ui.locale property specifies an alternative supported locale name when you use one of the Derby tools with a language not supported by your default system.