Throw this out as an idea... Are the schema names the same? That is, is your application using the same schema name qualifier for your tables as when you use the command prompt? This can be based off the user, or it could be "hard coded".
Kevin On Fri, Sep 17, 2010 at 10:32 AM, Sambaiah Kilaru <[email protected]>wrote: > > ----- Original Message ----- > From: "Michael Dick" <[email protected]> > To: [email protected] > Sent: Friday, September 17, 2010 7:21:52 PM GMT +05:30 Chennai, Kolkata, > Mumbai, New Delhi > Subject: Re: issue with Oracle and openjpa1.2.1 > > That's odd. > > The exception is coming from Oracle, OpenJPA is just reporting it. Are you > using OpenJPA's internal datasources (openjpa.ConnectionDriverName, > openjpa.ConnectionURL, etc) or a datasource from JNDI? > > > I noted few more observations, problem exist only for this table and the > issue happens only > for some cases and some of the cases db updates works fine. > > I don't see any H/W issue, but more like any bad cache from openjpa? > It is all speculation at this moment. > > thanks, > Sam > > On Thu, Sep 16, 2010 at 9:11 PM, Sambaiah Kilaru <[email protected] > >wrote: > > > > > ----- Original Message ----- > > From: "Michael Dick" <[email protected]> > > To: [email protected] > > Sent: Friday, September 17, 2010 5:17:32 AM GMT +05:30 Chennai, Kolkata, > > Mumbai, New Delhi > > Subject: Re: issue with Oracle and openjpa1.2.1 > > > > >> Hi Sam, > > > > >> Does the COORD_JOBS table exist, and is it readable by the Oracle > user? > > > > > > Yes, the table exist and I can login using the same username and pass my > > application is using > > and insert entries > > > > thanks, > > Sam > > > > >
