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.
|Type of property||How you set it|
|Database-wide||Using system procedures and functions in an SQL statement|