Agents › DevTest Java Agent › Java Agent Architecture › Java Agent Database Schema

Java Agent Database Schema

The broker automatically creates the database schema for the DevTest Java Agent.

To create the schema manually, obtain the DDL statements by running the following command:

java -jar LisaAgent.jar -ddl <oracle|sqlserver|mysql|derby|db2>

You can also obtain the DDL statements from the following files in the LISA_HOME\database directory:

• db2_pathfinder.ddl
• derby_pathfinder.ddl
• mysql_pathfinder.ddl
• oracle_pathfinder.ddl
• sqlserver_pathfinder.ddl

Typically, you create the schema manually for security or process reasons, or possibly migration or documentation concerns.