In a client/server environment, you must set the system properties for
the server's system. That means that when you are using
the derby.properties file, the file exists in the server's
derby.system.home directory.
Client applications can set database-wide properties because they are set via
SQL statements.
Summary of ways to set properties
Type of property
How you set it
System-wide
- In derby.properties
- As a command-line option when starting the JVM that holds the server or, if
the server is started from within a program, programmatically by the program
that hosts the server
Database-wide
Using system procedures and functions in an SQL statement