Recently too busy, too busy, it is the surface of the faint sky ....
Being a little ape. When I work hard, a quick flashing avatar pulls me back into reality, the field program reads the Data times wrong: SQLException: Violation of the agreement, when the little ape I thought a long time, this is what ghosts. By virtue of my some of the code farming experience, open search engine a search, it is different opinions, we have words. But there are two kinds of arguments to sum up:
1. Driver mismatch
2. Data problems (Chinese questions, field type, length)
Come, since there is a direction, then fight it, first looked at the driver, the database for oracle10g (10.2.0.5), looked at the official website recommended driver for Classes12.jar (jdk1.2or1.3 use) or Classes14.jar ( jdk1.4or1.5 use), On-site JDK is 1.6, in view of the JDK backwards compatibility, classes1.4.jar should be no problem, check the Classpatch application is also in use Classes14.jar this relieved, supposedly no problem (alas, is so self-righteous then eat a lot of bitterness, something again); A lengthy process of troubleshooting data and coding has started in the event of a problem. A variety of tracking logs and programming optimization, still do not solve the problem, crash ah ... Self-confidence has been lost, how is good?
Suddenly a flash of light, the Classes14.jar, is not the official offer of the latest bar? With the last glimmer of hope, in the official website re-download the latest Classes14.jar, replace restart, simple two-step after, the program is normal. Heaven has eyes, not a conscientious ah ....
Summarize:
1. It is really the driving problem, actually those who say is the data problem causes the end or the driving problem
2. Do not blindly believe in the predecessors Ah, I simply look at it is not classes14.jar and do not take the official website of the latest jar to compare, cause oneself dazed for a long time (because most of the program is from the history, many jar packages have not adapted to the latest situation, so we are responsible for the program of the people to do with The Times)
Problems can not be underestimated, their own work in the methods, habits and thinking problems should not be underestimated, often reflect on it
SqlException: Breach of agreement