Angelo, There is another thread which mentions the same problem [1]. Is it the same environment? What version of Oracle are you using? Was it upgraded these months? It might be Oracle configuration/bug.
Cheers, Milosz [1] http://openjpa.208410.n2.nabble.com/issue-with-Oracle-and-openjpa1-2-1-td5540421.html#a5540421 > What I would do here is to turn on sql logging. see what sql it's > bombing on. And then then try to run that sql as the same user that > your application server is connecting as. > > -Andy > > On Mon, 2010-09-20 at 14:08 -0700, Angelo K. Huang wrote: > > We are using openjpa version 1.2.1 with oracle db. There are five tables in > > the db. One error "ORA-00942 table or view does not exist" throws out > > occasionally when the system tries to access the table by insert or update. > > The account we were using has the synonyms to other schema. For example, we > > used "test_user" which has synonyms for the tables in "test" schema. All > > tables are there and we also used sqlplus to test the setup of accounts. The > > error is not throwing in a very consistent way. Sometimes, the system was > > running fine. Sometimes, this error would start throwing out and we had to > > restart the system. After the restart, the error might, or might not, > > happen. Does anyone have a similar experience like this? Do we need to > > upgrade openjpa to a newer version? > > >
