ORA-00942: table or view does not exist

[anike...@gmail.com]

Hi,

I have solved the local-JNDI-name issue (post: defining local-JNDI-name in WAS). Now I am getting following error.
Any clue about what this exception is related.

I am using oracle 10G DB. Username, Password for DB is correct. schema is also correct. I am not able to find thge cause
for it. Any idea????

[3/27/06 14:58:29:782 IST] 0000002e ExceptionUtil E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "getProductDetail" on bean "BeanId(XXXXXX#XXXXXX.jar#ProductService, null)". Exception data: com.XXXXXX.exception.XXXXXXEJBException: MSG: javax.ejb.TransactionRolledbackLocalException: ; nested exception is: java.sql.SQLException: ORA-00942: table or view does not exist
DSRA0010E: SQL State = 42000, Error Code = 942 ; nested exception is: java.sql.SQLException: ORA-00942: table or view does not exist
DSRA0010E: SQL State = 42000, Error Code = 942 TIME: 0
at com.XXXXXX.util.EJBUtil.handleSysError(EJBUtil.java:40)
at com.XXXXXX.util.EJBUtil.handleSysError(EJBUtil.java:59)
at com.XXXXXX.server.product.ejb.ProductServiceEJB.getProductDetail(ProductServiceEJB.java:119)
at com.XXXXXX.server.product.ejb.EJSRemoteStatelessProductService_8a255b9e.getProductDetail(Unknown Source)
at com.XXXXXX.server.product.ejb._ProductService_Stub.getProductDetail(_ProductService_Stub.java:495)
at com.XXXXXX.client.bean.sales.ProductSearchBean.setProductCode(ProductSearchBean.java:729)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at org.apache.jasper.runtime.JspRuntimeLibrary.handleSetProperty(JspRuntimeLibrary.java:733)
at com.ibm._jsp._find._jspService(_find.java:321)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629)
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:117)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:171)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:94)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:601)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)

[3/27/06 15:00:48:246 IST] 0000002e SessionContex W SESN0066E: Response is already commited to client. Session cookie cannot be set.
[3/27/06 15:00:48:216 IST] 0000002f SessionContex W SESN0066E: Response is already commited to client. Session cookie cannot be set.
[3/27/06 15:00:48:256 IST] 0000002e SRTServletRes W WARNING: Cannot set session cookie. Response already committed.
[3/27/06 15:00:48:266 IST] 0000002f SRTServletRes W WARNING: Cannot set session cookie. Response already committed.

[Sunit Patke]

Does the table exist? Does the ID you are using have access to the table?
Have you tries connecting using the same uid and password to your db and
execute the query?

Sunit

<anike...@gmail.com> wrote in message
news:750823488.1143453323...@ltsgwas007.sby.ibm.com...

[anike...@gmail.com]

Hi,

Yes table does exist in the DB. I am using the same uid and passw which I use to access the Db, that uid has all rights.

The table is aleardy present in the DB. I migrating from weblogic to websphere to DB is already created. I also check the query for which the exception is coming, and run on oracle editor with same uid, it did not gave any exception.

Is this error related to any SQL rights or something.????

please help....

Thanx

[Ken Hygh]

If it's SQL rights, then it's an Oracle issue.

Ken

[anike...@gmail.com]

HI,

Do I need to create any websphere specific user? I am using Oracle XA driver. Is there any websphere specifig SQl configuration which I must do??

Please help me in this.

Thanx

[anike...@gmail.com]

HI,

Thanx for you reply. Just to confirm Following are the details.

Class names
BusinessSKUEntityHome
BusinessSKUEntity
BusinessSKUEntityEJB

Table Name
BusinessSKU

JNDI Name
BusinessSKUEntity

So you are saying that websphere is trying with the name BusinessSKUEntity instead of BusinessSKU, And I should change the name of EJB from BusinessSKUEntity to BusinessSKU. Am I correct?

Thanx

[Ken Hygh]

When you created the EJB, you gave it a table name. Looks like that name
is wrong. You should be able to use any Oracle userid that has the right
permissions, you do not need anything websphere specific.

Ken

[Ken Hygh]

Table names do not directly map to EJB names nor JNDI names. When your
programmers created the EJBs, they created them with particular table
names. I have no idea what they used.

Ken