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);

}

 

}

}

 

 

Revised Code:

 

ResultSet rs = currentStatement.executeQuery(sqlQuery);

ResultSetMetaData meta = rs.getMetaData();

int numberOfColumns = meta.getColumnCount();

//If you want column name then uncomment below

//String dataHeaders = meta.getColumnName(1);

 

/*if(numberOfColumns>0 ){

for (int i = 2 ; i < numberOfColumns + 1 ; i ++ ) {

dataHeaders += delimiter + meta.getColumnName(i) ;

}

writer.println(dataHeaders) ;

}*/

 

while (rs.next()) {

String row = rs.getString(1) ;

for (int i = 2 ; i < numberOfColumns + 1 ; i ++ ) {

row += delimiter + rs.getString(i);

System.out.println("Written: "+row);

}
 

}