WebSphere Commerce´Â µ¥ÀÌÅͺ£À̽º Æ®¸®°Å¸¦ »ç¿ëÇÏ¿© ÄÁÅÙÃ÷°¡ º¯°æµÈ ½Ã°£À» ³ªÅ¸³À´Ï´Ù. ÀÌ·¯ÇÑ Æ®¸®°Å´Â Á¤º¸¸¦ CACHLOG Å×ÀÌºí¿¡ ±â·ÏÇÏ¿© ij½Ã¿¡¼ Á¦°ÅÇØ¾ß ÇÏ´Â ÆäÀÌÁö¸¦ ³ªÅ¸³À´Ï´Ù.
WebSphere Commerce¸¦ »ç¿ëÀÚ Á¤ÀÇÇÑ °æ¿ì, »ç¿ëÀÚÀÇ Æ®¸®°Å¸¦ ÀÛ¼ºÇϰíÀÚ ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀϹÝÀûÀ¸·Î, »ç¿ëÀÚ ÀÚ½ÅÀÇ Æ®¸®°Å ½ºÅ©¸³Æ®¸¦ ÀÛ¼ºÇØ¾ß ÇÏÁö¸¸ WebSphere Commerce¿¡¼ Á¦°øÇÏ´Â ½ºÅ©¸³Æ®´Â ¼öÁ¤ÇÒ ¼ö ¾ø½À´Ï´Ù.
´ÙÀ½ ½Ã³ª¸®¿À¸¦ »ý°¢ÇØ º¸½Ê½Ã¿À.
°í°´ÀÌ »óÁ¡¿¡¼ ÆÇ¸Å °èȹÀ» ¼±ÅÃÇϱâ À§ÇØ °¡´Â À§Ä¡¸¦ Ç¥½ÃÇÏ´Â
WebSphere Commerce ¸í·ÉÀ» Ãß°¡Çß½À´Ï´Ù. URLÀº ´ÙÀ½°ú °°½À´Ï´Ù.
http://mySite/webapp/wcs/stores/servlet/ShowPickupAddress?storeId=1&location=3
¼±Åà À§Ä¡ Á¤º¸¸¦ ÀúÀåÇÏ´Â PICKUP_SITES Å×À̺íÀ» ÀÛ¼ºÇß½À´Ï´Ù. ÀÌ Å×À̺íÀº ´ÙÀ½°ú °°½À´Ï´Ù.
´ÙÀ½ ¿¹¿¡´Â ij½Ã¿¡¼ ÀÌ ÆäÀÌÁö¸¦ Á¦°ÅÇÏ´Â Æ®¸®°Å°¡ Ç¥½ÃµË´Ï´Ù.
CREATE TRIGGER pickup_1
AFTER UPDATE ON PICKUP_SITES
REFERENCING OLD AS N FOR EACH ROW MODE DB2SQL
INSERT INTO cachlog (cacurlname, cachashkey, cacmemberkey, cachashvalue, cacmembervalue,
cacstmp, cactrigid)
VALUES ('ShowPickupAddress', 'location', 'storeId', N.location, 1, CURRENT TIMESTAMP,
INT('1001'));
CREATE TRIGGER pickup_1
AFTER DELETE ON PICKUP_SITES
REFERENCING OLD AS N FOR EACH ROW MODE DB2SQL
INSERT INTO cachlog (cacurlname, cachashkey, cacmemberkey, cachashvalue, cacmembervalue,
cacstmp, cactrigid)
VALUES ('ShowPickupAddress', 'location', 'storeId', N.location, 1, CURRENT TIMESTAMP,
INT('1002'));
Æ®¸®°Å´Â ´ÙÀ½À» ³ªÅ¸³À´Ï´Ù.
Æ®¸®°Å´Â CACHLOG Å×À̺í Ç׸ñ¿¡ ´ëÇØ °¡´ÉÇÑ ¸¹Àº µ¥ÀÌÅ͸¦ ä¿ö¾ß ÇÕ´Ï´Ù. Çϳª ÀÌ»óÀÇ ¿À» °ø¹éÀ¸·Î µÎ¸é, ÇØ´ç ¸Å°³º¯¼ö¸¦ °¡Áø ÆäÀÌÁö¸¦ Á¦°ÅÇϰíÀÚ ÇÔÀ» ³ªÅ¸³À´Ï´Ù.
ÀÏ´Ü ÇàÀÌ CACHLOG Å×À̺í·Î È®¾àµÇ¸é, ÀÚµ¿ ÆäÀÌÁö ¹«È¿È°¡ ÀÛµ¿ °¡´ÉÇÒ °æ¿ì ij½Ã Á¤¸® ÀÛ¾÷ÀÚ´Â ´ÙÀ½ ¹Ýº¹½Ã Ç¥½ÃµÈ ÆäÀÌÁö¸¦ Á¦°ÅÇÕ´Ï´Ù.
![]() |