Look at your mapped statement, make sure that you can run it if you connect to the database as the user that ibatis connects as.
My guess is that a table was not created, or a view was not created, or that the permissions are wrong. Larry On Nov 19, 2007 7:29 PM, cuong PN <[EMAIL PROTECTED]> wrote: > > Hi all > > We've been trying to solve this problem without any success yet. Hope you > guys can help!:-) > > We're hitting this error: > > DaoConfig: getDaoManager: > [EMAIL PROTECTED] > com.ibatis.dao.client.DaoException: Failed to queryForList - id [SomeID], > parameterObject [EMAIL PROTECTED] Cause: > com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred while applying a parameter map. > --- Check the SomeID-InlineParameterMap. > --- Check the statement (query failed). > --- Cause: java.sql.SQLException: ORA-00942: table or view does not exist > > Caused by: java.sql.SQLException: ORA-00942: table or view does not exist > > at > com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:284) > at > com.sums.implementation.SumsDaoImpl.getDetails(SumsDaoImpl.java:40) > at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72) > at $Proxy10.getDetails(Unknown Source) > at > com.sums.beans.SomeBean.validate(JobPaymentEnquiryRetrieveBean.java:472) > at com.portnet.base.BaseServlet.doPost(BaseServlet.java:318) > at com.portnet.base.SecureServlet.doPost(SecureServlet.java:53) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1077) > at > weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465) > at > weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:348) > at > weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:7047) > at > weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) > at > weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121) > at > weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3902) > at > weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2773) > at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224) > at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183) > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred while applying a parameter map. > --- Check the SomeID-InlineParameterMap. > --- Check the statement (query failed). > --- Cause: java.sql.SQLException: ORA-00942: table or view does not exist > > Everything runs fine in our DEV environment. But the moment we move it to > SIT, it shows that error. Some googling has been done but no solution found. > At most I've read that it has something to do with DUAL or SEQUENCE in > Oracle Database Server (we're running 10g). But I don't quite get it. Any > help will be greatly appreciated! > > Many personal thanks! :-) > Cuong > -- > View this message in context: > http://www.nabble.com/ORA-00942%3A-table-or-view-does-not-exist-tf4840853.html#a13849799 > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > >
