[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5844?page=c... ] Gail Badner commented on HHH-5844: ---------------------------------- Please provide a test case that reproduces your issue. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5844?page=c... ] guy bashan commented on HHH-5844: --------------------------------- Here is the part of code that generates the exception: ------------------------------------------------------------------ public List<CampaignBrowse> getNetworkCampaigns(String searchText, String status, Integer publisherId, Integer advertiserId, Integer agencyId, String sortColumn, String sortDir, int from, int recordsNum) { String queryStr = "select c.campaign_id 'campaignId', c.order_id 'orderId', c.campaign_name 'campaignName', c.order_name 'orderName', c.status 'status'," + " c.cost_model 'costModel', cast(c.cost as float) 'cost', c.start_date 'startDate', c.end_date 'endDate', c.private_name 'privateName', c.family_name 'familyName', " + " c.advertiser_name 'advertiserName', c.update_date 'updateDate', cast(c.fill_rate as float) 'fillRate', c.time_zone 'timeZone', " + "c.agency_id 'agencyId', c.advertiser_id 'advertiserId', c.ps 'ps' " + getNetworkCampaignsQuery() + " order by " + sortColumn + " " + sortDir; SQLQuery sqlQuery = session.createSQLQuery(queryStr); Query query = sqlQuery.setParameter("publisherId", publisherId) .setInteger("advertiserId", advertiserId) .setInteger("agencyId", agencyId) .setString("searchText", "%" + searchText + "%") .setString("status", status) .setFirstResult(from) .setMaxResults(recordsNum); return query.setResultTransformer(Transformers.aliasToBean(CampaignBrowse.class)).list(); And here is the bean that I use: ---------------------------------------- import javax.persistence.*; import java.io.Serializable; import java.util.Date; import java.util.TimeZone; @Entity @Table(name = "cmp_browse_data") public class CampaignBrowse implements Serializable { @Id @Column(name="campaign_id") private Integer campaignId; @Column(name="campaign_name") private String campaignName; @Column(name="order_id") private Integer orderId; @Column(name="order_name") private String orderName; @Column(name="status") private String status; @Column(name="cost_model") private String costModel; @Column(name="cost") private Double cost; @Column(name="start_date") private Date startDate; @Column(name="end_date") private Date endDate; @Column(name="private_name") private String privateName; @Column(name="family_name") private String familyName; @Column(name="advertiser_name") private String advertiserName; @Column(name="update_date") private Date updateDate; @Column(name="fill_rate") private Double fillRate; @Column(name="time_zone") private String timeZone; @Column(name="agency_id") private Integer agencyId; @Column(name="advertiser_id") private Integer advertiserId; @Column(name="ps_") private Double ps; public Integer getCampaignId() { return campaignId; } public void setCampaignId(Integer campaignId) { this.campaignId = campaignId; } public String getCampaignName() { return campaignName; } public void setCampaignName(String campaignName) { this.campaignName = campaignName; } public Integer getOrderId() { return orderId; } public void setOrderId(Integer orderId) { this.orderId = orderId; } public String getStatus() { return status; } public void setStatus(String status) { this.status = status; } public String getCostModel() { return costModel; } public void setCostModel(String costModel) { this.costModel = costModel; } public Date getStartDate() { return startDate; } public void setStartDate(Date startDate) { this.startDate = startDate; } public Date getEndDate() { return endDate; } public void setEndDate(Date endDate) { this.endDate = endDate; } public String getPrivateName() { return privateName; } public void setPrivateName(String privateName) { this.privateName = privateName; } public String getFamilyName() { return familyName; } public void setFamilyName(String familyName) { this.familyName = familyName; } public String getAdvertiserName() { return advertiserName; } public void setAdvertiserName(String advertiserName) { this.advertiserName = advertiserName; } public Date getUpdateDate() { return updateDate; } public void setUpdateDate(Date updateDate) { this.updateDate = updateDate; } public Double getFillRate() { return fillRate; } public void setFillRate(Double fillRate) { this.fillRate = fillRate; } public String getTimeZone() { return timeZone; } public void setTimeZone(String timeZone) { this.timeZone = timeZone; } public TimeZone getTimeZoneObj() { return TimeZone.getTimeZone(timeZone); } public Integer getAgencyId() { return agencyId; } public void setAgencyId(Integer agencyId) { this.agencyId = agencyId; } public Integer getAdvertiserId() { return advertiserId; } public void setAdvertiserId(Integer advertiserId) { this.advertiserId = advertiserId; } public Double getCost() { return cost; } public Double getPs() { return ps; } public void setPs(Double ps) { this.ps = ps; } public Double getPublisherCost() { return CampaignPerformanceUtil.getPublisherCost(cost, ps); } public void setCost(Double cost) { this.cost = cost; } public String getOrderName() { return orderName; } public void setOrderName(String orderName) { this.orderName = orderName; } } -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5844?page=c... ] Strong Liu resolved HHH-5844. ----------------------------- Resolution: Duplicate duplicated by HHH-3244 -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira