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?
--
View this message in context:
http://openjpa.208410.n2.nabble.com/openjpa-1-2-1-oracle-table-not-found-tp5552340p5552340.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
