SunOneAppServ with Oracle 10g vers. 10.1.0.3.0
Hello,
I'm using two different versions of SunOneAppServer,
Sun Java System Application Server Enterprise Edition 8.1_02(build b19-p08) and
Sun Java System Application Server 7 2004Q2UR2.
These two instances of Application Servers work over two different databases, Oracle 8 and Oracle 10g vers. 10.1.0.3.0.
When working with Oracle 10 I get locks over some records during transactions and that transactions don't run correctly so the records remain locked and all following transactions go on waiting indefinitely or until I kill the session using toad.
Looking at the query locking the record it seems to me it's a query done by the application server.
Using the same software and making the same operation over the database with Oracle 8 this doesn't happen.
Does anyone has the same problem or knows how to solve it?
A collegue of mines told me that these versions of application servers doesn't support Oracle 10g. Is it true?
