WAS v8.5 > Develop applications > Develop data access resources > Develop data access applications > Develop data access applications
Recreating database tables from the exported table data definition language
When the WebSphere Application Server deployment tooling deploys an EJB jar file containing container-managed persistence enterprise beans, it selects the target database and creates a corresponding Table.ddl file. This file contains the SQL statement necessary to generate the database table for the CMP beans.
The following steps demonstrate the process for creating tables in DB2 .
- Extract the Table.ddl file from your CMP enterprise bean JAR file and save it on the database server.
- Save the file to a working directory, such as C:\temp, on your DB2 machine.
- Run the Table.ddl file.
- Run the command C:\temp>db2cmd, replacing C:\temp with your chosen directory. A DB2 command window is displayed, in which you enter the following commands (replacing C:\temp with your chosen directory):
- C:\temp>db2 connect to your_db_name
- C:\temp>db2 -tf Table.ddl //This command runs and creates tables for the CMP enterprise bean.
- C:\temp>db2 disconnect all
Note: If you run DB2 on supported UNIX systems, use these same commands.
Run them from a user with permissions for DB2, rather than from a DB2 command window.
- Run the command C:\temp>db2cmd, replacing C:\temp with your chosen directory. A DB2 command window is displayed, in which you enter the following commands (replacing C:\temp with your chosen directory):
Results
The database tables are created.