java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect

[harsimran kochar]

table tr has only 2 column 1st is time period of type text nd second is rate also of type text

	try  {	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection con=DriverManager.getConnection("jdbc:odbc:DRIVER=Microsoft Access DRIVER (*.mdb);DBQ=trrelation.mdb");
		String tp=(String)mTimePd.getElementAt(cTimePd.getSelectedIndex());
		PreparedStatement ps=con.prepareStatement("select Rate from tr where TimePeriod=?");
		   ResultSet  rs=ps.executeQuery();
		ps.setString(1,tp);
						
	            while(rs.next()){
		 tRate.setText(rs.getString(2));
							
						
		}
	      con.close();
            }
            catch(Exception ex){
            	System.out.println(ex.toString());
            }

[Jeanne Boyarsky]

Welcome to CodeRanch! I've added code tags to your post to make it easier to read.

Regardless of how many columns the table has, you are only returning one in the query (rate.) This means when you call getString(2), it doesn't know what to do.

select Rate from tr where TimePeriod=?

[harsimran kochar]

so what should i do, can you suggest any change in code

[Jeanne Boyarsky]

Change the select to return both columsn. For example,

select Rate, count from tr where TimePeriod=?

[Paul Clapham]

Or, alternatively, use

rs.getString(1)

to get the one and only column you selected. If that was what you wanted.

[Darryl Burke]

harsimran , please BeForthrightWhenCrossPostingToOtherSites : http://www.java-forums.org/database/48338-java-sql-sqlexception-microsoft-odbc-microsoft-access-driver-count-field-incorrect.html