-->
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.  [ 1 post ] 
Author Message
 Post subject: select command generated with duplicate columns?
PostPosted: Tue Nov 16, 2004 12:42 am 
Newbie

Joined: Sun Aug 08, 2004 11:04 pm
Posts: 5
Hi all, why does Hibernate generate the sql select command with duplicate columns?

I'm using Hibernate 2.1.6 The table I am trying to read has a compound id. Note in the following sql there are 3 columns for ABSENCE_ID:

select prmabsence0_.ABSENCE_ID as ABSENCE_ID__, prmabsence0_.SEQUENCE as SEQUENCE__, prmabsence0_.ABSENCE_ID as ABSENCE_ID0_, prmabsence0_.SEQUENCE as SEQUENCE0_, prmabsence0_.LEAVE_ID as LEAVE_ID0_, prmabsence0_.HOUR_AMT as HOUR_AMT0_, prmabsence0_.OPS_GL as OPS_GL0_, prmabsence0_.FL_ID_NO as FL_ID_NO0_, prmabsence0_.FL_NO as FL_NO0_, prmabsence0_.HRS_OR_FTE as HRS_OR_FTE0_, prmabsence0_.AMENDMENT_STAT as AMENDMEN9_0_, prmabsence0_.UNIT_TYPE as UNIT_TYPE0_, prmabsence0_.LOCATION as LOCATION0_, prmabsence0_.ABSENCE_CODE as ABSENCE12_0_, prmabsence0_.ABSENCE_DATE as ABSENCE13_0_, prmabsence0_.FL_DIST_NO as FL_DIST_NO0_, prmabsence0_.INTERFACE_SEQ as INTERFA15_0_, prmabsence0_.EMPLOYEE_NO as EMPLOYE16_0_, prmabsence0_.STATUS as STATUS0_, prmabsence0_.START_TIME as START_TIME0_, prmabsence0_.AM_OR_PM as AM_OR_PM0_, prmabsence0_.AMENDMENT_RULE as AMENDME20_0_, prmabsence0_.WEEK_END_DATE as WEEK_EN21_0_, prmabsence0_.AMENDMENT_SEQ as AMENDME22_0_, prmabsence0_.REAL_HOURS as REAL_HOURS0_, prmabsence0_.DAY_COUNT as DAY_COUNT0_, prmabsence0_.UNIT_AMT as UNIT_AMT0_, prmabsence0_.OCCUPATION_CODE as OCCUPAT26_0_, prmabsence0_.PAY_RATE as PAY_RATE0_, prmabsence0_.LEAVE_UNITS as LEAVE_U28_0_, prmabsence0_.OPS_HOURS_AMT as OPS_HOU29_0_, prmabsence0_.BATCH_NO as BATCH_NO0_, prmabsence0_.DAY_AMT as DAY_AMT0_, prmabsence0_.HOURS_PER_DAY as HOURS_P32_0_, prmabsence0_.PAY_CODE as PAY_CODE0_, prmabsence0_.STATUS1 as STATUS10_, prmabsence0_.ABSENCE_POSITION as ABSENCE35_0_, prmabsence0_.PAYROLL_ID as PAYROLL_ID0_, prmabsence0_.SHIFT_CODE as SHIFT_CODE0_, prmabsence0_.INTERFACE_SRC as INTERFA38_0_, prmabsence0_.END_TIME as END_TIME0_, prmabsence0_.COST_CENTER as COST_CE40_0_, prmabsence0_.INTERFACE_STAT as INTERFA41_0_, prmabsence0_.FL_ORDER_NO as FL_ORDE42_0_, prmabsence0_.ABSENCE_ID as ABSENCE_ID0_ from ABSENCE_DETAIL prmabsence0_ where prmabsence0_.ABSENCE_ID='20040914000069


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

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.