You can use the utility program startSQLRepository
in order to read a repository definition from an XML file or DOM. startSQLRepository
can perform these tasks:
Verify the XML is correctly formed and complies with the DTD.
Parse and process optional operation tags like
<add-item>
,<remove-item>
, and<query-items>
. These tags provide a means for adding, removing, updating items in your SQL repository.Generate SQL statements that are required to create the appropriate database table structure when you use the
–outputSQL
flag.Return results of
<query-items>
and<print-item>
requests in the form of<add-item>
tags. This lets you easily copy and paste the results into another XML template, so you can add the items to another repository.Import and export items and item descriptors.
Note: When running startSQLRepository
on a third-party application server, you must configure the server to use an Oracle ATG Web Commerce data source and transaction manager, not your native application server’s data source and transaction manager.