and to the correct schema. I've experienced some strange things with JDBC 
connections not picking up the correct Oracle schema.

Alexander

At 18:29 04.04.01, you wrote:
>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


_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to