-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
 Post subject: SQL Error - "Left outer join" construct appearing
PostPosted: Wed Aug 03, 2005 11:27 am 
Newbie

Joined: Wed Mar 09, 2005 2:49 pm
Posts: 2
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=?


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 03, 2005 11:47 am 
Regular
Regular

Joined: Thu May 26, 2005 2:08 pm
Posts: 99
Looks like the forum might have eaten some of your post. Could you please post these details again.

Quote:
Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.