Exception: Data not found using JDBC

[Brad Thiru]

Hi All,

Can someone help me with the following code that displays only the first column value and with the msg as "Exception: Data not found" although i've values in the excel sheet for 6 columns.

This happens if i include the "If" stmt mentioned inside the "For" loop. But it displays all the column values properly without "If" stmt inside the "For" loop (i.e., only rs.getString(i)).

Also if I tried to display rs.getString(1); or rs.getString(2) etc... individually,but it displays ths same as mentioned above.

I'm using Eclipse for Java developers and have Windows 7 64 bit and the JDBC connection is working good. But not too sure about this.. I've doubt about the JRE.. if it requires to be re-installed.

I got bit struck on this. Any help would be greatly appreciated

  public void setUpInitialData() throws Exception
	  {
		  try {
	            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	            Connection con = DriverManager.getConnection("jdbc:odbc:SeleniumDS");
	            Statement st = con.createStatement();
	            ResultSet rs = st.executeQuery("Select * from [Sheet1$]");
	            
	            ResultSetMetaData rsmd = rs.getMetaData();
	            int numberOfColumns = rsmd.getColumnCount();
	            
	            while (rs.next())
	            {
	            	for (int i = 1; i <= numberOfColumns; i++)
	                {
	                    if (i > 1)
	                    {
	                        System.out.print(", ");
	                    }
	                   if (rs.getString(6).contentEquals("Yes"))
// Problem happens because of this If stmt.. but without this if Stmt it displays fine
	                    {	
	                    	String columnValue = rs.getString(i);
	                    	System.out.println(columnValue);
	                    }
	                    	//{		
      // Following stmts displays Exception data not found if uncommented except for rs.getString(1)

	                        //System.out.println(rs.getString(1));
	                        //System.out.println(rs.getString(2));
	                        //System.out.println(rs.getString(3));
	                        //System.out.println(rs.getString(4));
	                        ///System.out.println(rs.getString(5));
	                        //System.out.println(rs.getString(6));
	                    //}
	                }
	                System.out.println("");
	                
	            }
	           
	 
	            st.close();
	            con.close();
	 
	        }

REgards,
Brad

[Martin Vajsar]

Some database drivers might require that you access columns in the resultset in an increasing order. My suggestion would be either to read all columns into local variables incrementally and then to process them, or (perhaps better) use a Java library to read Excel files (such as Apache POI or jExcel API) instead of ODBC.

And welcome to the Ranch!

[Campbell Ritchie]

Welcome again
Please use the code button and avoid long lines; I have applied the code button to your post and you can see how much better it looks. On this forum (JDBC) only, you may have to disable smilies otherwise :odbc appears as dbc!