apache > db
Apache DB Project
Font size:      

In a Client/Server Environment

In a Client/Server Environment

In a client/server environment, you must set the system properties for the server's system. That means 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 since they are set via SQL statements. Client applications can set dynamic system-wide properties in an SQL statement, as shown in the example in Using a Properties Object Within an Application or Statement.

Table 1. Summary of Ways to Set Properties

Type of PropertyHow You Set It
  • In derby.properties
  • Programmatically (as a command-line option to the JVM when starting the application or within application code)

Database-wideUsing system procedures and functions in an SQL statement

Previous Page
Next Page
Table of Contents