Re: JPetstore question

[Larry Meadors <lm...@apache.org>]

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 <bw...@massconnections.com> 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
>
>