First illustrate the environment where problems appear:
OS environment Windows 2000
Development environment JDK1.4.2
Operating environment WebLogic 813
DB Oracle9i
DB interface JDBC
When the problem occurs when the code is modified, when a record is written to a table in a table, JDBC throws such an error "invalid column index", I immediately checked Google. Only one ITPUB answered this question, it said that the relevant index is rebuilt. After practical, this suggestion can not solve my problem. So I recall the changes: I added a field at that time. Then carefully check it to the SQL statement less? This exception caused. This table has 36 fields, 35 in the STATEMENT SQL statement? No., and Statement has 36 parameters when setting the parameters. Is it added when adding a field? The number is caused. After the problem is solved.
