Hi Angelo, Unfortunately I don't know the solution or the exact cause. I just lately read a message on some Polish database related mailing list [1]. Basically the guy says he is experiencing random ORA-00942 errors after upgrading to 11.1.0.7.0 and he has no idea what's happening. Not sure whether he means database or driver upgrade. This message along with yours made me suspect that Oracle introduced some incompatibility or bug with the upgrade.
Greetings, Milosz [1] http://groups.google.com/group/pl.comp.bazy-danych/browse_thread/thread/e7f329a3531c6eb4# > > Hi Milosz, > > Yes, he is my co-worker. Our application used openjpa 1.2.1 with ojdbc > 11.1.0.7.0 and the oracle server, I believe, is 11.2. You said you heard > some similar situations happened in other cases. Could you tell us what will > be potential problems here? The ORA-00942 happened randomly and we have no > way to predict when it will happen again. Sometimes it happened in insert, > but sometimes in update. The first thing we can try is to update our ojdbc > version to match with oracle server version. > > Thanks, > Angelo >
