Hi All
When I run my application I get the error message
sql.SQLException: ORA-00942: table or view does not exist
This message comes when I save my data using the entity bean.
I have already checked my descriptors regarding the table names and column
names
I am using java version jdk1.3
here is the stack trace of the error.
2001-04-03 11:48:33,324 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteAgentBean (SiteAgentBean.j
ava:34) - SiteAgentBean.setSessionContext
2001-04-03 11:48:33,344 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteAgentBean (SiteAgentBean.j
ava:48) - in the EJB create
2001-04-03 11:48:33,404 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.EJBUtil (EJBUtil.java:300) - C
onf param = null
2001-04-03 11:48:33,414 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.Configuration (Configuration.j
ava:40) - Read Settings
2001-04-03 11:48:33,584 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.Configuration (Configuration.j
ava:70) - Application Server Param
2001-04-03 11:48:33,594 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.Configuration (Configuration.j
ava:75) - Vendor Namejboss
2001-04-03 11:48:33,604 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.Configuration (Configuration.j
ava:93) - name:java.naming.factory.initial
2001-04-03 11:48:33,734 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.Configuration (Configuration.j
ava:93) - name:java.naming.factory.url.pkgs
2001-04-03 11:48:33,734 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.Configuration (Configuration.j
ava:93) - name:java.naming.provider.url
2001-04-03 11:48:33,744 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.Configuration (Configuration.j
ava:93) - name:dsjndi
2001-04-03 11:48:33,875 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.Configuration (Configuration.j
ava:98) - DAtasource Jndi Namejava:/eres
2001-04-03 11:48:33,885 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.Configuration (Configuration.j
ava:180) - Current DB Node<DB>
<DRIVER>oracle.jdbc.driver.OracleDriver</DRIVER> <DB_URL>jdbc:oracle:
thin:@192.8.8.44:1521:eapp</DB_URL> <USERID>er</USERID> <PWD>er</PWD> </DB>
2001-04-03 11:48:33,895 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.Configuration (Configuration.j
ava:183) - DBDriverNameoracle.jdbc.driver.OracleDriver
2001-04-03 11:48:33,905 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.Configuration (Configuration.j
ava:185) -
2001-04-03 11:48:33,915 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.Configuration (Configuration.j
ava:187) - DBUserer
2001-04-03 11:48:33,915 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.Configuration (Configuration.j
ava:189) - DBPwder
2001-04-03 11:48:34,145 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.EJBUtil (EJBUtil.java:302) - C
onf param = {java.naming.provider.url=localhost:1099,
java.naming.factory.initial=org.jnp.interfaces
.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming}
2001-04-03 11:48:34,706 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteAgentBean (SiteAgentBean.j
ava:68) - Error in getUserDetails() in
SiteAgentBeanjavax.ejb.ObjectNotFoundException: Object with p
rimary key 46 not found in storage
2001-04-03 11:48:34,716 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteAgentBean (SiteAgentBean.j
ava:70) - Returning from SiteAgentBean.getSiteDetails SiteStateKeeper null
2001-04-03 11:48:34,836 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.EJBUtil (EJBUtil.java:300) - C
onf param = {java.naming.provider.url=localhost:1099,
java.naming.factory.initial=org.jnp.interfaces
.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming}
2001-04-03 11:48:34,846 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.EJBUtil (EJBUtil.java:302) - C
onf param = {java.naming.provider.url=localhost:1099,
java.naming.factory.initial=org.jnp.interfaces
.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming}
2001-04-03 11:48:34,936 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteBean (SiteBean.java:172) -
IN EJB CREATE
2001-04-03 11:48:34,936 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteBean (SiteBean.java:203) -
IN Site STATE STATE HOLDER
2001-04-03 11:48:34,946 DEBUG [RMI TCP Connection(7)-192.8.8.49]
common.EntityAdapter (EntityAdapter
.java:55) - GetConnection Function Call
2001-04-03 11:48:34,956 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.EJBUtil (EJBUtil.java:300) - C
onf param = {java.naming.provider.url=localhost:1099,
java.naming.factory.initial=org.jnp.interfaces
.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming}
2001-04-03 11:48:34,956 DEBUG [RMI TCP Connection(7)-192.8.8.49]
util.EJBUtil (EJBUtil.java:302) - C
onf param = {java.naming.provider.url=localhost:1099,
java.naming.factory.initial=org.jnp.interfaces
.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming}
2001-04-03 11:48:34,986 DEBUG [RMI TCP Connection(7)-192.8.8.49]
common.EntityAdapter (EntityAdapter
.java:58) - INITIAL CONTECXT:javax.naming.InitialContext@52d1a4conf
Pathc:\eResApp\conf\eresearch.xm
l
2001-04-03 11:48:35,066 DEBUG [RMI TCP Connection(7)-192.8.8.49]
common.EntityAdapter (EntityAdapter
.java:62) - JNDI NAME DS NAMEjava:/eres
2001-04-03 11:48:35,116 DEBUG [RMI TCP Connection(7)-192.8.8.49]
common.EntityAdapter (EntityAdapter
.java:64) - DATASOURCE org.jboss.minerva.datasource.XAPoolDataSource@417690
2001-04-03 11:48:35,256 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteBean (SiteBean.java:208) -
Connection :oracle.jdbc.driver.OracleConnection@632382
[siteentity] select SEQ_ER_SITE.nextval from dual
2001-04-03 11:48:35,487 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteBean (SiteBean.java:211) -
GOT SITE ID709
2001-04-03 11:48:35,497 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteBean (SiteBean.java:212) -
GOT SITE ID46
2001-04-03 11:48:35,507 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteBean (SiteBean.java:215) -
after setSiteCode
2001-04-03 11:48:35,507 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteBean (SiteBean.java:219) -
after SiteAccountId
2001-04-03 11:48:35,517 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteBean (SiteBean.java:222) -
after setSitePerAdd
2001-04-03 11:48:35,527 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteBean (SiteBean.java:225) -
setSiteName
2001-04-03 11:48:35,537 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteBean (SiteBean.java:227) -
setSiteDept
2001-04-03 11:48:35,547 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteBean (SiteBean.java:230) -
setSiteInfo
2001-04-03 11:48:35,567 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteBean (SiteBean.java:233) -
setSiteStatus
2001-04-03 11:48:35,617 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteBean (SiteBean.java:235) -
setSiteParent
2001-04-03 11:48:35,667 DEBUG [RMI TCP Connection(7)-192.8.8.49]
impl.SiteBean (SiteBean.java:237) -
saving the data in the site bean
Error in setSiteDetails() in SiteAgentBean javax.ejb.CreateException: Could
not create entity:java.s
ql.SQLException: ORA-00942: table or view does not exist
Dinesh
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
