Tutorials > Content management > Create a content-managed resource > Integrate the new resource
Insert SQL for commands into CMDREG table
To register our newly created controller commands, we will have to insert some records into the CMDREG table.
Procedure
- To insert the SQL for commands into the CMDREG table type the following:
INSERT INTO cmdreg (STOREENT_ID, INTERFACENAME, DESCRIPTION, CLASSNAME, PROPERTIES, LASTUPDATE, TARGET, OPTCOUNTER) VALUES (0, 'com.ibm.commerce.tools.catalog.commands.NavCatCatalogCreateControllerCmd', null, 'com.ibm.commerce.tools.catalog.commands.NavCatExtendedCatalogCreateControllerCmdImpl', null, null, 'Local', null); INSERT INTO cmdreg ( STOREENT_ID, INTERFACENAME, DESCRIPTION, CLASSNAME, PROPERTIES, LASTUPDATE, TARGET, OPTCOUNTER) VALUES ( 0, 'com.ibm.commerce.tools.catalog.commands.NavCatCatalogUpdateControllerCmd', null, 'com.ibm.commerce.tools.catalog.commands.NavCatExtendedCatalogUpdateControllerCmdImpl', null, null, 'Local', null);
- For these changes to be recognized, the Commerce server must be restarted. In the Servers view, right click the server and select Restart.