Creating and preparing the database for read-only use
To create databases for use on read-only media, perform these steps.
Read-only databasescreating
Create and populate the database on read-write media.
Commit all transactions and shut down in
the prescribed manner. If you do not shut down in
the prescribed manner, will
need to perform recovery the next time the system boots. cannot
perform recovery on read-only media.
Delete the tmp directory if one was created within your
database directory. If you include this directory, will
attempt to delete it and will return errors when attempting to boot a database
on read-only media.
For the read-only database, set the property derby.storage.tempDirectory to
a writable location. needs
to write to temporary files for large sorts required by such SQL statements
as ORDER BY, UNION, DISTINCT, and GROUP BY. For more information about this
property, see the .derby.storage.tempDirectory=c:/temp/mytemp
Configure the database to send error messages to a writable file
or to an output stream.For information on the
derby.stream.error.file property, see the .derby.stream.error.file=c:/temp/mylog.LOG
Be sure to set these properties so that they are deployed with the
database.