There are two tables using the 'ITEMID', I can't find where the problem is...
There are two Item.xml one is under %JPESTORE_HOME%\build\webapp\WEB-INF\classes\com\ibatis\jpetstore\persistence\sqlmapdao\sql the content is: | <?xml version="1.0" encoding="UTF-8" ?> | | <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" | "http://ibatis.apache.org/dtd/sql-map-2.dtd";> | | <sqlMap namespace="Item"> | | <typeAlias alias="item" type="com.ibatis.jpetstore.domain.Item"/> | | <cacheModel id="itemCache" type="LRU"> | <flushInterval hours="24"/> | <property name="size" value="100"/> | </cacheModel> | | <cacheModel id="quantityCache" type="LRU"> | <flushInterval hours="24"/> | <flushOnExecute statement="updateInventoryQuantity"/> | <property name="size" value="100"/> | </cacheModel> | | <select id="getItemListByProduct" resultClass="item" parameterClass="string" cacheModel="itemCache"> | SELECT | ITEMID, | LISTPRICE, | UNITCOST, | SUPPLIER AS supplierId, | I.PRODUCTID AS "product.productId", | NAME AS "product.name", | DESCN AS "product.description", | CATEGORY AS "product.categoryId", | STATUS, | ATTR1 AS attribute1, | ATTR2 AS attribute2, | ATTR3 AS attribute3, | ATTR4 AS attribute4, | ATTR5 AS attribute5 | FROM ITEM I, PRODUCT P | WHERE P.PRODUCTID = I.PRODUCTID | AND I.PRODUCTID = #value# | </select> | | <select id="getItem" resultClass="item" parameterClass="string" cacheModel="quantityCache"> | select | ITEMID, | LISTPRICE, | UNITCOST, | SUPPLIER AS supplierId, | I.PRODUCTID AS "product.productId", | NAME AS "product.name", | DESCN AS "product.description", | CATEGORY AS "product.categoryId", | STATUS, | ATTR1 AS attribute1, | ATTR2 AS attribute2, | ATTR3 AS attribute3, | ATTR4 AS attribute4, | ATTR5 AS attribute5, | QTY AS quantity | from ITEM I, INVENTORY V, PRODUCT P | where P.PRODUCTID = I.PRODUCTID | and I.ITEMID = V.ITEMID | and I.ITEMID = #value# | </select> | | <select id="getInventoryQuantity" resultClass="int" parameterClass="string"> | SELECT QTY AS value | FROM INVENTORY | WHERE ITEMID = #itemId# | </select> | | <update id="updateInventoryQuantity" parameterClass="map"> | UPDATE INVENTORY SET | QTY = QTY - #increment# | WHERE ITEMID = #itemId# | </update> | | </sqlMap> | | The other one is under %JPETSTORE_HOME%\src\com\ibatis\jpetstore\persistence\sqlmapdao\sql the content is : | <?xml version="1.0" encoding="UTF-8" ?> | | <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" | "http://ibatis.apache.org/dtd/sql-map-2.dtd";> | | <sqlMap namespace="Item"> | | <typeAlias alias="item" type="com.ibatis.jpetstore.domain.Item"/> | | <cacheModel id="itemCache" type="LRU"> | <flushInterval hours="24"/> | <property name="size" value="100"/> | </cacheModel> | | <cacheModel id="quantityCache" type="LRU"> | <flushInterval hours="24"/> | <flushOnExecute statement="updateInventoryQuantity"/> | <property name="size" value="100"/> | </cacheModel> | | <select id="getItemListByProduct" resultClass="item" parameterClass="string" cacheModel="itemCache"> | SELECT | ITEMID, | LISTPRICE, | UNITCOST, | SUPPLIER AS supplierId, | I.PRODUCTID AS "product.productId", | NAME AS "product.name", | DESCN AS "product.description", | CATEGORY AS "product.categoryId", | STATUS, | ATTR1 AS attribute1, | ATTR2 AS attribute2, | ATTR3 AS attribute3, | ATTR4 AS attribute4, | ATTR5 AS attribute5 | FROM ITEM I, PRODUCT P | WHERE P.PRODUCTID = I.PRODUCTID | AND I.PRODUCTID = #value# | </select> | | <select id="getItem" resultClass="item" parameterClass="string" cacheModel="quantityCache"> | select | ITEMID, | LISTPRICE, | UNITCOST, | SUPPLIER AS supplierId, | I.PRODUCTID AS "product.productId", | NAME AS "product.name", | DESCN AS "product.description", | CATEGORY AS "product.categoryId", | STATUS, | ATTR1 AS attribute1, | ATTR2 AS attribute2, | ATTR3 AS attribute3, | ATTR4 AS attribute4, | ATTR5 AS attribute5, | QTY AS quantity | from ITEM I, INVENTORY V, PRODUCT P | where P.PRODUCTID = I.PRODUCTID | and I.ITEMID = V.ITEMID | and I.ITEMID = #value# | </select> | | <select id="getInventoryQuantity" resultClass="int" parameterClass="string"> | SELECT QTY AS value | FROM INVENTORY | WHERE ITEMID = #itemId# | </select> | | <update id="updateInventoryQuantity" parameterClass="map"> | UPDATE INVENTORY SET | QTY = QTY - #increment# | WHERE ITEMID = #itemId# | </update> | | </sqlMap> | | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3983647#3983647 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3983647 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
