InfoCenter Home >
6: Administer applications >
6.6: Tools and resources quick reference >
6.6.14: Administering database connections (overview) >
6.6.14.8: Recreating database tables from the exported table DDL

6.6.14.8: Recreating database tables from the exported table DDL

To recreate database tables from the exported table DDL, you execute the exported table DDL file to create a table for CMP beans by hand. For instructions for exporting the table DDL, see the following:

Create the tables in the database of the data source configuration in the following order:

  1. If you specified data source for the CMP bean, then use the data source for the bean.
  2. If you specified data source for the EJB module of that CMP bean, then use the data source for the EJB module.
  3. If neither of the above two conditions applies, use the default data source for the EJBContainer of the application server onto which the EJM module was installed.

The content of the table DDL file is the SQL strings needed to create a table. The content differs for different databases. The DDL file is essentially an SQL file, and each database has a different command to execute an SQL file.

Copy or paste the content of the table DDL file to a database command line, or use the command line option to take a SQL file as a parameter. The syntax of the command for supported databases is:

For DB2:
db2 -tf table_DDL_file_name
For Oracle:
sqlplus user_name/password

After a new window displays:

@table_DDL_file_name
For Sybase:
isql -Uuser_name -Ppassword -Sserver_name -i table_DDL_file_name
Go to previous article: Notes about various databases Go to next article: Administering data source providers and data sources with the Application Client Resource Configuration Tool

 

 
Go to previous article: Notes about various databases Go to next article: Administering data source providers and data sources with the Application Client Resource Configuration Tool