[oracle] skąd cytat
arek r
nagle w aplikacji jest błąd java.sql.SQLException: ORA-00942: table or view does
not exist, tabela oczywiście jest i po pewnym błąd znika
Niedawno był wgrywany patch do 11.1.0.7.0 nie wiem czy ma to związek
Dostałem taki meil i chciałbym się dowiedzieć skąd pochodzi cytat i jaki jest
jego kontekst. Nie wiem czy ma on wogóle zastosowanie w świecie javy czy
sterowniku jdbc
Regarding the error about nonexistent table I think it still can happen even if
the string was properly sent to the server and parsed (especially if we are
using bind variables). For example there could be a situation where an
application forks a child process whilst the parent process is still connected
to the database and then attempts to use this connection in both the parent and
child process. This is not allowed in Oracle.
Following is some excerpt from Oracle documentation: “If the child is spawned
when the parent process is still connected to the database then both processes
will share a connection meaning that 2 user processes will be trying to
communicate with the same shadow process on the server, and therefore
potentially interfering with each other. If both the parent and child need to
connect, then the parent should reconnect after spawning the child.”
--
Wysłano z serwisu OnetNiusy: http://niusy.onet.pl