How To Cause Java.Sql.Sqlexception: Invalid Column Index
"java.sql.SQLException: Invalid column index" is a frequent mistake spell working inwards Java Database Connectivity (JDBC). As the name suggests "Invalid column index" its related to accessing or setting column inwards your SQL Query using prepared arguing inwards Java. I convey seen " java.sql.SQLException: Invalid column index " coming to a greater extent than oft than non due to 2 reason: 1) S etting col umn information using setXXXX(int coloumIndex) e.g. setInt(0) setString(0) 2) Getting column information using getXXX(int columnIndex) e.g. getInt(0) getString(0) Most mutual crusade of " java.sql.SQLException: Invalid column index " is a misconception that column index started alongside "0" similar array or String index but that's non truthful instead column index starts alongside "1" together with therefore whenever yous endeavor to teach or Set column information alongside column index "0"...