java.sql.SQLException: Invalid column index
I am using ojdbc7.jar while doing JDBC connection in my java application. I am executing 2 sql queries with executeQuery method, getting below error. java.sql.SQLException: Invalid column index at oracle.jdbc.driver.GeneratedScrollableResultSet.getString(GeneratedScrollableResultSet.java:868) at jDBcCheckPackage.TestConnection.executeSQl(TestConnection.java:140) at jDBcCheckPackage.TestConnection.executeSQlFile(TestConnection.java:112) at jDBcCheckPackage.TestConnection.main(TestConnection.java:55) Code Written: ResultSet rs = currentStatement .executeQuery( sqlQuery ); while ( rs .next()) { String str = rs .getString(1) ; //System.out.println("OUTPUT=================="+ str ); } ...
