2018.6.10 Common error summaries for Oracle databases

1, classnofoundexception can not find the registration driver

Possible cause:1> driver name is incorrect
2> Database driver package not imported

2, the SQL statement can use any valid function, function operation of the column, you must specify an alias, otherwise it will appear

Java.sql.SQLException: Invalid column name

3. Java.sql.SQLException: Invalid column index:

SQL string inside? The number of numbers is inconsistent with the number of variables provided

4. Java.sql.SQLException: The result set is exhausted

When you manipulate the result set, the pointer to the result set points to the result set, for example: Rs.beforefirst ();

5, appear SqlException, through SYSTEM.OUT.PRINTLN (SQL); Print the contents of the SQL statement to view the SQL statement syntax error 6, JDBC subscript starting from 1, if starting from 0, Throws an exception Java.sql.SQLException: Invalid column index: getValidColumnIndex7, java.sql.SQLException Io exception: The Network Adapter could not Establish the connection is because the IP address of the URL is not written to the IP address of its home host 8, Java.sql.SQLException: invalid operation on a read-only result set: updatestring Because Sun provides this interface statement in the resutset.concur_upddatable, but Oracle provides the driver package is not supported, MySQL support 9, java.sql.SQLException: Invalid characters A semicolon is added to the SQL statement; 10java.sql.sqlexception: is the index missing in or out? Number is inconsistent with the given value 11, Exception in thread "main" Java.lang.ExceptionInInitializerError12, Java.sql.SQLException: Invalid column name Specify column name 13, ORC: line number when no function operation is given to the SQL statement .... are SQL statements with errors, console errors are consistent with errors in the database

2018.6.10 Common error summaries for Oracle databases