The start-database command starts the Java DB server that is available with the Sun Java System Application Server software. Use this command only for working with applications deployed to the Application Server. Java DB is based upon Apache Derby.
When the Java DB database server is started using this command, the database server is started in Network Server mode. Clients connecting to it must use the Java DB ClientDriver. For details on connecting to the database, such as the Driver Class Name and Connection URL, please see the Apache Derby documentation.
When the database server starts, or a client connects to it successfully, two types of files are created:
The derby.log file that contains the database server process log along with its standard output and standard error information.
The database files that contain your schema (for example, database tables).
Both types of files are created at the location specified by the dbhome option. When --dbhome is not specified, the default is the value of install-dir/databases. It is important to use the dbhome option when you want to create the database files at a particular location. The start-database command starts the database process, even if it cannot write to the log file.
This command is supported in local mode only.
The host name or IP address of the Java DB server process. The default is the IP address 0.0.0.0, which denotes all network interfaces on the host where you run the start-database command.
The port number where the Java DB server listens for client connections. This port must be available for the listen socket, otherwise the database server will not start. The default is 1527.
The absolute path to the directory where Java DB and the derby.log files are created. If not specified, the default location is install-dir/databases. For compatibility with previous releases, if a database is found in the current directory, dbhome defaults to ".". Otherwise, dbhome defaults to install-dir/databases.
Setting to true will echo the command line statement on the standard output. Default is false.
Setting to true displays detailed database information. Default is false.
The following command starts Java DB on the host host1 and port 5001:
asadmin> start-database --dbhost host1 --dbport 5001 --terse=true Starting database in the background. Log redirected to /opt/SUNWAppserver/derby/db.log.
The exit status applies to errors in executing the asadmin command. For information on database errors, see the derby.log file.
command executed successfully
error in executing the command