[jboss-user] [JNDI/Naming/Network] - Re: The JNDI problem when deploying the JPetStore with jboss
bobicyao
do-not-reply at jboss.com
Thu Nov 23 04:06:34 EST 2006
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 at 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...
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3988088#3988088
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3988088
More information about the jboss-user
mailing list