Query is as shown below. Because of words "Left outer join", query gives error "SQL command not ended properly".


Hibernate version: 2.2

select formdatade0_.id as id1_, formdatade0_.CREATED_ON as CREATED_ON1_, formdatade0_.CREATED_BY as CREATED_BY1_, formdatade0_.PROPERTY_NAME as PROPERTY4_1_, formdatade0_.QUESTION as QUESTION1_, formdatade0_.ANSWER_TYPE as ANSWER_T6_1_, formdatade0_.QUESTION_NUMBER as QUESTION7_1_, formdatade0_.ANSWER_NUMBER as ANSWER_N8_1_, formdatade0_.SPECIAL_TREATMENT as SPECIAL_9_1_, formdatade0_.PAGE_NO as PAGE_NO1_, formdatade0_.LINE_NO as LINE_NO1_, formdatade0_.MAX_LENGTH as MAX_LENGTH1_, formdatade0_.LINE_BREAK as LINE_BREAK1_, formdatade0_.TAG_VALUE as TAG_VALUE1_, formdatade0_.VALIDATION as VALIDATION1_, formdatade0_.LIST_OF_VALUES as LIST_OF16_1_, formdatade0_.LAST_CHANGE_BY as LAST_CH17_1_, formdatade0_.LAST_CHANGE_ON as LAST_CH18_1_, formdatade0_.FULL_ANSWER as FULL_AN19_1_, formdatade0_.parent_ques_id as parent_20_1_, formdatabo1_.id as id0_, formdatabo1_.CREATED_ON as CREATED_ON0_, formdatabo1_.CREATED_BY as CREATED_BY0_, formdatabo1_.PROPERTY_NAME as PROPERTY4_0_, formdatabo1_.QUESTION as QUESTION0_, formdatabo1_.PAGE_NO as PAGE_NO0_, formdatabo1_.CHILD_QUESTION as CHILD_QU7_0_, formdatabo1_.PARENT_QUESTION as PARENT_Q8_0_, formdatabo1_.PARENT_QUESTION_NUMBER as PARENT_Q9_0_, formdatabo1_.ANSWER_TYPE as ANSWER_10_0_, formdatabo1_.ANSWER as ANSWER0_, formdatabo1_.QUESTION_NUMBER as QUESTIO12_0_, formdatabo1_.SPECIAL_TREATMENT as SPECIAL13_0_, formdatabo1_.IS_SECTION as IS_SECTION0_, formdatabo1_.IS_BOILERPLATE as IS_BOIL15_0_, formdatabo1_.IS_INPRINT as IS_INPRINT0_, formdatabo1_.LINE_NO as LINE_NO0_, formdatabo1_.USER_REF_NO as USER_RE18_0_, formdatabo1_.PROT_NO as PROT_NO0_, formdatabo1_.MAX_LENGTH as MAX_LENGTH0_, formdatabo1_.FORM_ID as FORM_ID0_, formdatabo1_.VALIDATION as VALIDATION0_, formdatabo1_.LAST_CHANGE_BY as LAST_CH23_0_, formdatabo1_.LAST_CHANGE_ON as LAST_CH24_0_ from form_data_details formdatade0_ left outer join form_data formdatabo1_ on formdatade0_.parent_ques_id=formdatabo1_.id where formdatade0_.id=?

Looks like the forum might have eaten some of your post. Could you please post these details again.