when i try to get the details of the product, it has a excetion:
my config:tomcat4.1.24+mysql5.02
i'm a newer,is there someone can help me? 3Q!
org.springframework.jdbc.UncategorizedSQLException : (SqlMapClient operation): encountered SQLException [
--- The error occurred in org/springframework/samples/jpetstore/dao/ibatis/maps/Item.xml.
--- The error occurred while applying a parameter map.
--- Check the getItemListByProduct-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Unknown type '0 in column 1 of 14 in binary-encoded result set.]; nested exception is com.ibatis.common.jdbc.exception.NestedSQLExceptio n:
--- The error occurred in org/springframework/samples/jpetstore/dao/ibatis/maps/Item.xml.
--- The error occurred while applying a parameter map.
--- Check the getItemListByProduct-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Unknown type '0 in column 1 of 14 in binary-encoded result set.
com.ibatis.common.jdbc.exception.NestedSQLExceptio n:
--- The error occurred in org/springframework/samples/jpetstore/dao/ibatis/maps/Item.xml.
--- The error occurred while applying a parameter map.
--- Check the getItemListByProduct-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Unknown type '0 in column 1 of 14 in binary-encoded result set.
Caused by: java.sql.SQLException: Unknown type '0 in column 1 of 14 in binary-encoded result set.
at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryWithCallback(GeneralStatemen t.java:181)
at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryForList(GeneralStatement.jav a:119)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForList(SqlMapExecutorDelegate.java:610)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForList(SqlMapExecutorDelegate.java:584)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.qu eryForList(SqlMapSessionImpl.java:105)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.que ryForList(SqlMapClientImpl.java:77)
at org.springframework.orm.ibatis.SqlMapClientTemplat e$3.doInSqlMapClient(SqlMapClientTemplate.java:226 )
at org.springframework.orm.ibatis.SqlMapClientTemplat e.execute(SqlMapClientTemplate.java:149)
at org.springframework.orm.ibatis.SqlMapClientTemplat e.executeWithListResult(SqlMapClientTemplate.java: 188)
at org.springframework.orm.ibatis.SqlMapClientTemplat e.queryForList(SqlMapClientTemplate.java:224)
at org.springframework.samples.jpetstore.dao.ibatis.S qlMapItemDao.getItemListByProduct(SqlMapItemDao.ja va:34)
at org.springframework.samples.jpetstore.domain.logic .PetStoreImpl.getItemListByProduct(PetStoreImpl.ja va:140)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method
... 59 more


Reply With Quote