ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From cuong PN <pncuon...@yahoo.com>
Subject Re: ORA-00942: table or view does not exist
Date Wed, 21 Nov 2007 01:28:06 GMT

Hi guys

Really appreciate your replies:-)

Our problem, as we always wanted to believe, lies in connection to the wrong
db. But it still took us so long to believe in what we saw, i.e. the
exception message :-D

Thanks again!


Balaji-3 wrote:
> 
> 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.
>>
>>
>>
>> 
> 
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/ORA-00942%3A-table-or-view-does-not-exist-tf4840853.html#a13869448
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message