Hi Larry Thanks for replying!:-)
The table is there. the permissions are all set fine. Other statements executed using the same account worked alright. That's why we're pretty puzzled. anyway, I'll tell the team to double check. Cuong Larry Meadors-2 wrote: > > 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. >> >> > > -- View this message in context: http://www.nabble.com/ORA-00942%3A-table-or-view-does-not-exist-tf4840853.html#a13851103 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
