JPetStore 5.0(iBATIS for java)中Item.xml的bug

解决ORA-00918错误

最新推荐文章于 2025-12-02 21:20:38 发布

原创最新推荐文章于 2025-12-02 21:20:38 发布 · 580 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#ibatis #java #string #query

iBATIS 专栏收录该内容

2 篇文章

订阅专栏

本文解决了一个在使用iBatis框架时遇到的ORA-00918:column ambiguously defined错误。通过调整Item.xml文件中的SQL查询语句，明确指定了字段来源，从而消除了歧义。

Caused by: java.sql.SQLException: ORA-00918: column ambiguously defined

Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/ibatis/jpetstore/persistence/sqlmapdao/sql/Item.xml.
--- The error occurred while applying a parameter map.
--- Check the getItem-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-00918: column ambiguously defined

change com/ibatis/jpetstore/persistence/sqlmapdao/sql/Item.xml to

红色为修改后的：

<select id="getItem" resultClass="item" parameterClass="string" cacheModel="quantityCache">
      select
      I.ITEMID,
      I.LISTPRICE,
      I.UNITCOST,
      I.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>