hql with select , where

[indu iyengar]

Hi all am trying to get the records with where clause using hql from mysql db, then it shows the exception as

 Hibernate: from courses where courseName='english'
14:52:03,622 WARN  [JDBCExceptionReporter] SQL Error: 1064, SQLState: 42000
14:52:03,622 ERROR [JDBCExceptionReporter] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from courses where courseName='english'' at line 1

in my java source class..

		  for(int i=0;i<courseNames.length;i++)
		  {
			  String sqlqry ="from courses";
			  Query qry = session.createSQLQuery(sqlqry);
			  System.out.println( "... b4 ... ");
			  Course c = (Course) qry.list();
			  System.out.println(c.getCourseID()+" ---- "+c.getCourseName()+" ---- "+c.getCreditPoints());
			  System.out.println(" ... af4 ...");
			  
		  }
			

am using hibernate 3 and mysql 5.1

please help me guys..

[indu iyengar]

my code is ::

 for(int i=0;i<courseNames.length;i++)
		  {
			  String sqlqry ="from courses where courseName='"+courseNames[i]+"'";
			  Query qry = session.createSQLQuery(sqlqry);
			  System.out.println( "... b4 ... ");
			  Course c = (Course) qry.list();
			  System.out.println(c.getCourseID()+" ---- "+c.getCourseName()+" ---- "+c.getCreditPoints());
			  System.out.println(" ... af4 ...");
			  
		  }

[Bogdan Baraila]

Like the name of the method you use is saying (createSQLQuery) you are not creating a hql query but a native sql query that will apply directly to the database. Try using the createQuery method.