ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Balaji Jankay" <bal...@objectec.com>
Subject Re: ORA-00942: table or view does not exist
Date Tue, 20 Nov 2007 14:29:38 GMT
grant select on the sequence for the userid/role.  Then try.

Balaji

----- Original Message ----- 
From: "cuong PN" <pncuong83@yahoo.com>
To: <user-java@ibatis.apache.org>
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 <pncuong83@yahoo.com> 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:
>>> com.ibatis.dao.engine.impl.StandardDaoManager@f91c8f
>>> com.ibatis.dao.client.DaoException: Failed to queryForList - id 
>>> [SomeID],
>>> parameterObject [com.sums.entity.SomeEntity@1bbfd3a].  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.
>
>
>
> 



Mime
View raw message