BEA Weblogic Question:

Download Job Interview Questions and Answers PDF

Why does FOR UPDATE in Oracle 8 cause an ORA-01002 error?

BEA Weblogic Interview Question
BEA Weblogic Interview Question

Answer:

The Oracle 8 server generates an ORA-01002:fetch out of sequence error message when you use a FOR UPDATE statement with AUTOCOMMIT turned on (which is the default state when using JDBC). This is known to happen on Oracle 8.0 and 8.1 on Solaris and on Oracle 8.1 on Windows NT. If you turn AUTOCOMMIT off, you will not receive this error. Because this problem is due to a change in the Oracle 8 server, you should contact Oracle support for more information.

Download BEA Weblogic Interview Questions And Answers PDF

Previous QuestionNext Question
How can I control on which WebLogic Server(s) my application will run?Two managed ms1, ms2 servers is there in a cluster. how can you say that load is there on only one server?