SQL Error: 1054, SQLState: 42S22

manpreet Best Answer 3 years ago

Hello Everyone I'm trying to retrive some data from my database but I'm getting

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'subject_id' in 'where clause'

It works if I retrive some other column of same table. I'm using spring and hibernate

Here is my controller code

@RequestMapping(value = "/getAnyQuestion", method = RequestMethod.GET)
public @ResponseBody
String getAnyQuestion(
        @RequestParam(value = "subId", required = true) Long subId,
        @RequestParam(value = "questionType", required = true) String questionType) {

    Question questionList = questionService.getAnyQuestion(subId,questionType);

    if (questionList != null) {
        questionId = questionList.getId();
        return questionList.getQuestionText();
    }

    return "";
}

Here is my Service

 public Question getAnyQuestion(Long subId,String questionType) {             
    String query = "subject_id = " + subId +"  and "+ "questionType='" + questionType +"' and 1=1 order by rand()";       

    List<Question> questionList = hibernateTemplate.findByCriteria(DetachedCriteria.forClass(Question.class).add(Restrictions.sqlRestriction(query)),0,1);
    if (questionList.isEmpty()) {
        return null;
    }
    return questionList.get(0);
}

and here is my domain

@Entity

@Table(name = "question") public class Question {

@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Long id;
@Column(length = 50)
private String questionType;
@Column(length = 5000)
private String questionText;

@ManyToOne
private Syllabus syllabus;
@ManyToOne
private Subject subject;
@ManyToOne
private Roll roll;

public Long getId() {
    
                                                

                                                                                                        
                                                    
                                                
                                                

                                                    

                                                        
                                                            0
                                                            views 

                                                            0
                                                                likes 
                                                            
                                                            

                                                            0
                                                            shares
                                                            


    

         Facebook
        
         Twitter
        
        
         Linked In 
        
          WhatsApp