ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fxbird <fxbird1...@163.com>
Subject JPetstore5.0+mysql error:XXXX in field list is ambiguous
Date Thu, 03 Jun 2010 13:53:33 GMT

Hi, I'm a new learner of ibatis, I download the JPetstore5.0 example, when db
is hsqldb, everything is ok,but if mysql, I encounter the similar error when
add an item into shopcart, the error is below:

Stack
    org.apache.struts.beanaction.BeanActionException: Error dispatching bean
action via URL pattern ('addItemToCart').  Cause:
org.apache.struts.beanaction.BeanActionException: Error invoking Action. 
Cause: java.lang.reflect.InvocationTargetException
	at org.apache.struts.beanaction.BeanAction.execute(BeanAction.java:249)
	at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
	at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
	at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
	at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873)
	at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
	at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
	at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
	at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.struts.beanaction.BeanActionException: Error invoking
Action.  Cause: java.lang.reflect.InvocationTargetException
	at org.apache.struts.beanaction.ActionInvoker.invoke(ActionInvoker.java:18)
	at
org.apache.struts.beanaction.DefaultActionInterceptor.intercept(DefaultActionInterceptor.java:5)
	at org.apache.struts.beanaction.BeanAction.execute(BeanAction.java:246)
	... 21 more
Caused by: java.lang.reflect.InvocationTargetException
	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:597)
	at org.apache.struts.beanaction.ActionInvoker.invoke(ActionInvoker.java:16)
	... 23 more
Caused by: com.ibatis.dao.client.DaoException: Failed to execute
queryForObject - id [getItem], parameterObject [EST-4].  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:
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column
'ITEMID' in field list is ambiguous
Caused by:
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column
'ITEMID' in field list is ambiguous
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:
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column
'ITEMID' in field list is ambiguous
Caused by:
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column
'ITEMID' in field list is ambiguous
	at
com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDaoTemplate.java:164)
	at
com.ibatis.jpetstore.persistence.sqlmapdao.ItemSqlMapDao.getItem(ItemSqlMapDao.java:42)
	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:597)
	at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
	at $Proxy7.getItem(Unknown Source)
	at
com.ibatis.jpetstore.service.CatalogService.getItem(CatalogService.java:59)
	at
com.ibatis.jpetstore.presentation.CartBean.addItemToCart(CartBean.java:60)
	... 28 more
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:
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column
'ITEMID' in field list is ambiguous
Caused by:
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column
'ITEMID' in field list is ambiguous
	at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
	at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
	at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:561)
	at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:536)
	at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:93)
	at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:70)
	at
com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDaoTemplate.java:162)
	... 37 more
Caused by:
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column
'ITEMID' in field list is ambiguous
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
	at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:874)
	at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:180)
	at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
	at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
	... 43 more
-- 
View this message in context: http://old.nabble.com/JPetstore5.0%2Bmysql-error%3AXXXX-in-field-list-is-ambiguous-tp28767832p28767832.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Mime
View raw message