grant select on the sequence for the userid/role. Then try.
Balaji
----- Original Message -----
From: "cuong PN" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, November 19, 2007 11:22 PM
Subject: Re: ORA-00942: table or view does not exist
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.
