FunctionThe ij.dataSource property
specifies the datasource to be used to access the database. When specifying
a datasource, does
not use the DriverManager mechanism to establish connections.
SyntaxTo establish a connection using ij.dataSource,
you need to set the ij.dataSource.databaseName property. If you want to create
the database, specify the ij.dataSource.createDatabase property
as well.
ij.dataSource=dataSourcename
ij.dataSource.databaseName=databasename
[ij.dataSource.createDatabase=create]
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.
#
java -Dij.dataSource=org.apache.derby.jdbc.EmbeddedDataSource
-Dij.dataSource.databaseName=sample -Dij.dataSource.createDatabase=create
org.apache.derby.tools.ij
ij version
CONNECTION0*
* = current connection
ij>
Example 2
In the following example, ij starts using an EmbeddedSimpleDataSource, then creates a database named smalldb using the
connect command, specifying ;create=true to create the
database if it does not already exist.
#
# If your application runs with a jvm supporting JSR169, you cannot use
# org.apache.derby.jdbc.EmbeddedDataSource, but you can use
# org.apache.derby.jdbc.EmbeddedSimpleDataSource instead.
# Because specifying a protocol would automatically attempt to load a driver,
# when using ij.dataSource you should omit the protocol on connect.
# This is especially relevant with JSR169 because java.sql.Driver is not supported.
#
java -Dij.dataSource=org.apache.derby.jdbc.EmbeddedSimpleDataSource
org.apache.derby.tools.ij
ij version
ij> connect 'smalldb;create=true';
ij>
For more information about DataSources, refer to the JDBC documentation
and "Using as a
J2EE Resource Manager" in the .