Just a semi-educated guess, but make sure you are resolving to the correct
database.
----- Original Message -----
From: Dinesh Khurana <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 2:27 AM
Subject: [JBoss-user] sql.SQLException: ORA-00942: table or view does not
exist
> 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
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
