EJBException, causedBy: javax.ejb.FinderException: Find failed: java.sql.SQLException: ORA-00942: table or view does not exist

Thread view:

psamuel - 31 Oct 2003 18:29 GMT

EJBException, causedBy:javax.ejb.FinderException: Find failed:
java.sql.SQLException: ORA-00942: table or view does not exist

I get this error when I try to access (read) the table through an
entity bean (CMP).
I am using Jboss 3.2.2 and CMP 2.x and xdoclet tags to generate the
code.
When I check the jbosscmp-jdbc.xml, I am not seeing "<table-name>"
tag. But I have @ejb.persistence table-name="GROUP_NAME"
@jboss.persistence table-name="GROUP_NAME" as tags defined in the
code.

Please help!

Thanks in advance!
psamuel

Reply to this Message

Marek Lange - 31 Oct 2003 22:07 GMT

psamuel schrieb:

> EJBException, causedBy:javax.ejb.FinderException: Find failed:
> java.sql.SQLException: ORA-00942: table or view does not exist
[quoted text clipped - 6 lines]
> @jboss.persistence table-name="GROUP_NAME" as tags defined in the
> code.

I think the @jboss.persistence tag is not necessary in your case. Try
using @ejb.persistence table-name="GROUP_NAME". Is JBoss creating the
tables (did you set createTable="true" in your build file) or did you
create the table?

This always worked for me:
* @ejb.bean
* type="CMP"
* cmp-version="2.x"
* name="Group"
* jndi-name="GroupHome"
* view-type="local"
* primkey-field="groupId"
* @ejb.persistence table-name="UM_GROUP"

-marek

Reply to this Message

EJBException, causedBy: javax.ejb.FinderException: Find failed: java.sql.SQLException: ORA-00942: table or view does not exist

Free Magazines