derby.database.classpath The derby.database.classpath property specifies the classpath that should use when searching for jar files in a database. derby.database.classpath property database-wide propertiessetting classpath for jar files

This property must be set to enable to load classes from jar files installed with the .

Make sure to do the following:

  • Separate jar files with a colon (:).
  • Use fully qualified identifiers for the jar files (schema name and jar name).
  • Set the property as a database-level property for the database.

searches the user's classpath before it searches the jar files specified by the derby.database.classpath property setting. To force to search the database only, remove the classes from the user classpath.

searches for classes and resources in the order specified by the property setting.

For more information, see the section "Loading classes from a database" in the . For reference information on system procedures for storing jar files in a database, see "."

Syntax -- database-level property CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( 'derby.database.classpath', 'colonSeparatedJarFiles') Example -- database-level property CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( 'derby.database.classpath', 'APP.ToursLogic:APP.ACCOUNTINGLOGIC')
Dynamic or static

Dynamic; the change takes effect immediately. For information about dynamic changes to properties, see .