ij.dataSource property
Derby Tools and Utilities Guide
22
java -Dij.protocol=jdbc:derby:
-Dij.database=wombat;create=true org.apache.derby.tools.ij
ij version 10.8
CONNECTION0* - jdbc:derby:wombat
* = current connection
ij>
ij.dataSource property
Function
The
ij.dataSource
property specifies the datasource to be used to access the
database. When specifying a datasource,
ij
does not use the DriverManager
mechanism to establish connections.
Syntax
When you set the
ij.dataSource
property
ij
will automatically try to
connect to a database. To establish a connection to a specific database using
ij.dataSource
, set the
ij.dataSource.databaseName
property. If you
do not set this property,
ij
will start with an error. If you want to create the
database, specify the
ij.dataSource.createDatabase
property as well as
ij.dataSource.databaseName
. Do not specify
ij.protocol
when setting
ij.dataSource
as that would activate the DriverManager mechanism.
ij.dataSource=datasource class name
ij.dataSource.databaseName=databasename
[ij.dataSource.createDatabase=create]
If you do not specify
ij.dataSource.databaseName
and get an error indicating
no database was found, you can still connect to a database by using
ij
. You should not specify the protocol (for example jdbc:derby:) in the
connect
command when using
ij.dataSource
.
Example 1
In the following example,
ij
connects to a database named
sample
using an
EmbeddedDataSource
. The
sample
database is created if it does not already exist.
#
# If your application runs on JDK 1.6 or higher, then you should
# specify the JDBC4 variant of this DataSource:
# org.apache.derby.jdbc.EmbeddedDataSource40.
# If your application runs with a jvm supporting JSR169, you cannot use
# org.apache.derby.jdbc.EmbeddedDataSource, instead, use:
# org.apache.derby.jdbc.EmbeddedSimpleDataSource.
#
java -Dij.dataSource=org.apache.derby.jdbc.EmbeddedDataSource
-Dij.dataSource.databaseName=sample -Dij.dataSource.createDatabase=create
org.apache.derby.tools.ij
ij version 10.8
CONNECTION0*
* = current connection
ij>
Example 2
In the following example,
ij
starts using an
EmbeddedSimpleDataSource
, without
specifying
ij.dataSource.databaseName
. This results in an error indicating no
database was found. After the error, the
connect
command is used to create and
connect to a database named
smalldb
.
#
