executing sql does not work

Question

I'm trying to execute a query in java but it throws an exception

try {
 conn = DriverManager.getConnection(DatabaseURL + DatabaseName, UserName, Password);
 System.out.println("1");
 Message = "data retrieved successfully ...";
 //Statement st = this.conn.createStatement();// Membuat Statement
 System.out.println("2");
 pr = conn.prepareStatement("SELECT `الكلمة` FROM `name1` WHERE `الموضوع` LIKE 'أداة الطحن' ;");
 System.out.println("3");
 res = pr.executeQuery();
 System.out.println("4");
} catch (Exception e) {
 System.out.println("5");
 Message = "connection failed \r\n " + e.getMessage();
 return null;
}

it prints 1 2 3 5 so there is a problem in executing the query so that it does not print 4 I tried to run it on sql and it works what's the problem here???

• Ugur Artun: What is the error code and dbms?
• cyroxx: Which Exception is thrown?
• assylias: Do you really have a column called الموضوع?
• M Abbas: can you replace System.out.println("5"); by e.printStackTrace(); and post the stacktrace please?
• Marwa88: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column '??????' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

Answer 1

You have a semicolon at last in the query.Maybe this is the problem.