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?
