java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch i

[smyle khanna]

i have developed a program tht generated a random number n later with those
numbers i have 2 retrieve the data matchin those numbers from database but its givin the exception when i run the program:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

import java.sql.*;
import java.util.Random;
class RandomNumberBounds1 {
       public static int[] doRawRandomNumber() {
    int max = 10;
        Random ranGen = new Random();
        int[] random = new int[15];
        int i=0;
        while(i<15){
          int next= ranGen.nextInt(max+1);
          System.out.println(next);
          if(next==0 || !isValid(i,next,random))
             continue;
          random[i] = next;
          ++i;
        }
        return random;
    }
   //latestIndex is that index is the index of the last element in that array
   public static boolean isValid(int latestIndex,int newVal,int[] input){
        int start=0;
        if(latestIndex >4)
          start=latestIndex-4;
        for(int i=start;i<latestIndex;++i)
           if(input[i]== newVal) return false;      
        return true;
    }
   }
public class example extends RandomNumberBounds1 {
public static void main(String[] args)
{
try {
int[] ranNumbers = doRawRandomNumber();
        System.out.println("after validation");
        for(int i=0;i<ranNumbers.length;++i)       
        {
        System.out.println(ranNumbers[i]);
        }
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc :-o	 dbc:CandidateInfo");
Statement stat=con.createStatement();
for(int j=o;j<ranNumbers.length;++j)
{
ResultSet rs=stat.executeQuery("Select * from VBques where QuestionNo='ranNumbers'");
System.out.println(rs.getString(2));
}


}
catch(SQLException sqle)
{
System.out.println("sql error"+sqle);
}
catch(Exception e)
{
System.out.println("general error"+e);
}
}
}

how 2 resolve this problem
thanks in advance

[Joe Ess]

Originally posted by smyle khanna:

ResultSet rs=stat.executeQuery("Select * from VBques where QuestionNo='ranNumbers'");

If QuestionNo is a numeric data type you should not quote the value you are searching for in the query. The quotes make the value CHAR or VARCHAR.
[ February 03, 2004: Message edited by: Joe Ess ]