Http://blog.sina.com.cn/s/blog_a45aac720100yu3h.html
Error-util.jdbcexceptionreporter>: Breach of agreement
Error-util.jdbcexceptionreporter>: OALL8 in an inconsistent state!
Recently been entangled in this problem for a long time, yesterday finally found the right solution, summed up, the cause of this problem is generally
Two
1. Connect the Oracle driver mismatch. For example, in a 11g+jdk6.0 environment, use Ojdbc5.jar.
2, the intermediate changes in the table structure and other information, will also lead to the above error. (Restarting the web won't happen again)
3. When manipulating field data, do not operate according to the field type specification. This is a relatively hidden problem. For example, I have a table that has 2 fields, a number type Tid, and a varchar2 type of tname. From the Database Building table specification, the table should have a primary key, so set the first field as the primary key, increment by sequence. So, how do you reproduce the exception? Consider the following SQL:
SELECT * FROM table where tid = ' 1 ';
from the results, This SQL is no problem, do not believe that you can try on PL/SQL. However, it is clear that the TID is a number type, but it is followed by a value that compares a string type.
And I have this problem because of this, in my Java written in the HQL statement (hibernate), there are several places (because of the use of templates, so the time when the copy did not pay attention to these), resulting in the frequent occurrence of such problems. (It may also be related to hibernate, specifically I did not do more to delve into it.) ）
Oracle violates protocol OALL8 in an inconsistent state
