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 Tue, 20 Nov 2007 05:22:02 GMT

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