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... View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3983619#3983619 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3983619 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user