JBossDeveloper

I encountered the same problem as you,have u solved it?please help me,how to solve the problem of "itemID",thank you very much!

my email : bobicyao@hotmail.com
thanks.

"jzhuqlfeixia" wrote:
Thanks!!!!! It's so nice of you. There is no JNDI problem any more??
But but but there is a new problem?? Could you go on to help me....
When I use the JPetStore. For example, I went into the "Fish" item, then I

went to a Product ID, and then I went into a Item ID, then I appeared the

problem as follow:

Error!
org.apache.struts.beanaction.BeanActionException
Error dispatching bean action via URL pattern ('viewItem'). Cause:

org.apache.struts.beanaction.BeanActionException: Error invoking Action.

Cause: java.lang.reflect.InvocationTargetException


Stack
 org.apache.struts.beanaction.BeanActionException: Error dispatching bean

action via URL pattern ('viewItem'). 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:697)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter

(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter

(ApplicationFilterChain.java:173)
 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter

(ReplyHeaderFilter.java:96)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter

(ApplicationFilterChain.java:202)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter

(ApplicationFilterChain.java:173)
 at org.apache.catalina.core.StandardWrapperValve.invoke

(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke

(StandardContextValve.java:178)
 at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke

(SecurityAssociationValve.java:175)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke

(AuthenticatorBase.java:432)
 at org.jboss.web.tomcat.security.JaccContextValve.invoke

(JaccContextValve.java:74)
 at org.apache.catalina.core.StandardHostValve.invoke

(StandardHostValve.java:126)
 at org.apache.catalina.valves.ErrorReportValve.invoke

(ErrorReportValve.java:105)
 at org.apache.catalina.core.StandardEngineValve.invoke

(StandardEngineValve.java:107)
 at org.apache.catalina.connector.CoyoteAdapter.service

(CoyoteAdapter.java:148)
 at org.apache.coyote.http11.Http11Processor.process

(Http11Processor.java:869)
 at

org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processC

onnection(Http11BaseProtocol.java:664)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket

(PoolTcpEndpoint.java:527)
 at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run

(MasterSlaveWorkerThread.java:112)
 at java.lang.Thread.run(Thread.java:595)
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)
 ... 25 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:585)
 at org.apache.struts.beanaction.ActionInvoker.invoke

(ActionInvoker.java:16)
 ... 27 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: java.sql.SQLException: Column 'ITEMID' in field list is ambiguous
Caused by: java.sql.SQLException: 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: java.sql.SQLException: Column 'ITEMID' in field list is ambiguous
Caused by: java.sql.SQLException: 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:585)
 at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
 at $Proxy53.getItem(Unknown Source)
 at com.ibatis.jpetstore.service.CatalogService.getItem

(CatalogService.java:59)
 at com.ibatis.jpetstore.presentation.CatalogBean.viewItem

(CatalogBean.java:141)
 ... 32 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: java.sql.SQLException: Column 'ITEMID' in field list is ambiguous
Caused by: java.sql.SQLException: Column 'ITEMID' in field list is ambiguous
 at

com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWith

Callback(GeneralStatement.java:185)
 at

com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForO

bject(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)
 ... 41 more
Caused by: java.sql.SQLException: Column 'ITEMID' in field list is ambiguous
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
 at com.mysql.jdbc.PreparedStatement.executeInternal

(PreparedStatement.java:936)
 at com.mysql.jdbc.PreparedStatement.execute

(PreparedStatement.java:773)
 at sun.reflect.GeneratedMethodAccessor106.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke

(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke

(PreparedStatementLogProxy.java:62)
 at $Proxy60.execute(Unknown Source)
 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.executeQueryWith

Callback(GeneralStatement.java:173)
 ... 47 more

I google for it. But I can't find the answer. Help me...