ij.showNoConnectionsAtStart property
Derby Tools and Utilities Guide
26
Syntax
ij.showErrorCode={ false | true }
Example
java -Dij.showErrorCode=true -Dij.protocol=jdbc:derby:
org.apache.derby.tools.ij
ij version 10.8
ij> Connect 'sample';
ij> VLUES 1;
ERROR 42X01: Syntax error: Encountered "VLUES"
at line 1, column 1. (errorCode = 30000)
ij>
ij.showNoConnectionsAtStart property
Function
The
ij.showNoConnectionsAtStart
property specifies whether the connections
message should be displayed when
ij
is started. Default is false, that is, a message
indicating the current connections, if any, is displayed.
Syntax
ij.showNoConnectionsAtStart={ false | true }
Example
In the following example,
ij
connects to a previously created database named
sample
using an
EmbeddedDataSource
. The property
ij.showNoConnectionsAtStart
is
set to true in the first session of the example, and set to false in the second session.
java -Dij.dataSource=org.apache.derby.jdbc.EmbeddedDataSource
-Dij.dataSource.databaseName=sample -Dij.showNoConnectionsAtStart=true
org.apache.derby.tools.ij
ij version 10.8
ij> disconnect;
ij> exit;
java -Dij.dataSource=org.apache.derby.jdbc.EmbeddedDataSource
-Dij.dataSource.databaseName=sample -Dij.showNoConnectionsAtStart=false
org.apache.derby.tools.ij
ij version 10.8
CONNECTION0*
* = current connection
ij> disconnect;
ij> exit;
ij.showNoCountForSelect property
Function
The
ij.showNoCountForSelect
property specifies whether to display messages
indicating the number of rows selected. Default is false, that is, if the property is not set,
select count messages are displayed.
Syntax
ij.showNoCountForSelect={ false | true }
Example
