Hi Larry, Actually no, the sql I have does not specify the I.ITEMID, it just has ITEMID. This is most likely the problem, which I will test now.
Thanks, Bruce -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Larry Meadors Sent: Thursday, March 23, 2006 1:32 PM To: Bruce Wexler; [email protected] Subject: Re: JPetstore question In SVN, it looks right..is this the SQL there? --- select I.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# --- Larry PS: please reply to the list, so others can benefit from the discussion. On 3/23/06, Bruce Wexler <[EMAIL PROTECTED]> wrote: > Hi again Larry, > > I know I'm probably pushing my luck, but I got past the last error, and now > have this: > > Caused by: com.ibatis.dao.client.DaoException: Failed to execute > queryForObject - id [getItem], parameterObject [EST-16]. Cause: > 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: [DataDirect][SQLServer JDBC > Driver][SQLServer]Ambiguous column name 'itemid'. > Caused by: java.sql.SQLException: [DataDirect][SQLServer JDBC > Driver][SQLServer]Ambiguous column name 'itemid'. > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: > > Thanks, > Bruce > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf > Of Larry Meadors > Sent: Thursday, March 23, 2006 1:05 PM > To: Bruce Wexler; [email protected] > Subject: Re: JPetstore question > > > I am replying to the list Bruce, in case others have the same problem > later, then they can google and get it. > > My guess is that the user connecting to the database does not see the > product table in the default schema. You may need to either connect as > another user, or qualify the table name. > > Larry > > > On 3/23/06, Bruce Wexler <[EMAIL PROTECTED]> wrote: > > Hi again Larry, > > > > OK, got past that, got another one for you: > > > > --- The error occurred in > > com/ibatis/jpetstore/persistence/sqlmapdao/sql/Product.xml. > > --- The error occurred while applying a parameter map. > > --- Check the getProductListByCategory-InlineParameterMap. > > --- Check the statement (query failed). > > --- Cause: java.sql.SQLException: [DataDirect][SQLServer JDBC > > Driver][SQLServer]Invalid object name 'PRODUCT'. > > Caused by: java.sql.SQLException: [DataDirect][SQLServer JDBC > > Driver][SQLServer]Invalid object name 'PRODUCT'. > > at > > com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForPaginatedList(SqlMapDaoTemplate.java:274) > > at > > com.ibatis.jpetstore.persistence.sqlmapdao.ProductSqlMapDao.getProductListByCategory(ProductSqlMapDao.java:19) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72) > > at $Proxy4.getProductListByCategory(Unknown Source) > > at > > com.ibatis.jpetstore.service.CatalogService.getProductListByCategory(CatalogService.java:47) > > at > > com.ibatis.jpetstore.presentation.CatalogBean.viewCategory(CatalogBean.java:126) > > ... 44 more > > > > The exception says to Check the > > getProductListByCategory-InlineParameterMap, but I'm not sure from looking > > through the docs what I'm missing. Can you tell from this snippet what I'm > > missing? Or could you point me to a resource that will explain this? > > > > <select id="getProductListByCategory" resultClass="product" > > parameterClass="string" cacheModel="productCache"> > > SELECT > > PRODUCTID, > > NAME, > > DESCN as description, > > CATEGORY as categoryId > > FROM PRODUCT > > WHERE CATEGORY = #value# > > </select> > > > > Thanks, > > Bruce > > > > >
