Lexical error at line 1, column 32.

[javamula]

Dear All,

Please help what is going on when running the project...

here is the error message:
run:
INSERT INTO CURRENCY VALUES ("AFN','Afghanistan Afghanis',47.6326566391,0.0209940001)
Exception in thread "main" java.sql.SQLSyntaxErrorException: Lexical error at line 1, column 32. Encountered: "\ufeff" (65279), after : "".

When executing the following code...

static void insertTable(String tableName, String datName, Statement stmt)
            throws SQLException, IOException {
      BufferedReader in = new BufferedReader(new FileReader(datName +".dat"));
       String line;
      while ((line = in.readLine())!= null)
      {

      String command = "INSERT INTO  " +tableName +" VALUES  (" +line +")";

thank you for your kind help in this matter....

[r035198x]

Try passing the statements through a PreparedStatement instead.

[javamula]

Dear r035198x,
thank you for the advice. Case closed now.
but why only insert the ROW 1,3,5... while the ROW 2,4,6...being skipped in readLine()

static void insertTable(String tableName, String datName, Statement stmt, Connection conn) throws SQLException, IOException {
    
        String sql = "INSERT INTO CURRENCY VALUES (?,?,?,?)";
        PreparedStatement dataUpdate = conn.prepareStatement(sql);
        BufferedReader in = new BufferedReader(new FileReader(datName +".dat"));
        String line;
        String[] tokens = {null,null,null,null};
        while ((line = in.readLine())!= null){
        tokens = line.split(",");
        dataUpdate.setString(1, tokens[0]);
        dataUpdate.setString(2, tokens[1]);
        dataUpdate.setDouble(3, Double.valueOf(tokens[2]).doubleValue()); 
        dataUpdate.setDouble(4, Double.valueOf(tokens[3]).doubleValue()); 
        //stmt.executeUpdate("INSERT INTO CURRENCY VALUES ('ALL','Albania Leke',92.29,0.0108354101)");
        dataUpdate.executeUpdate();
        dataUpdate.clearParameters();
        line = in.readLine(); //read next line
        }
  }

TQ for the help...

[javamula]

Thank you for your kind attention...the case being solved by disabling the last row of the code:

line = in.readLine(); //read next line

[r035198x]

Dear r035198x,
thank you for the advice. Case closed now.
..
[/CODE]

TQ for the help...

Welcome, make sure you close all those connections in a finally block though.