Databases
StackOverflow2013
Postsdbo
POerror: org.hibernate.PropertyNotFoundException: no appropriate constructor in class: com.a.offering.dto.SellerDetailsDto
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POerror: org.hibernate.PropertyNotFoundException: no appropriate constructor in class: com.a.offering.dto.SellerDetailsDto
    primarykey
    data
    text
    <p>I am using following query String queryString = "select NEW com.h.offering.dto.SellerDetailsDto(p.productId,p.sellerId, p.sellerSku, p.sellPrice, " + "p.transferPrice, p.sellerMRP,p.aCommission,p.baseShippingFee,p.addnShippingFee, " + "p.propogationLevel,p.propogationValue,a.warehouseName,a.quantity,a.maxShippingTime,a.minShippingTime) " + "from PriceDetails p, AvailabilityDetails a " + "where a.productId = p.productId " + "and a.sellerSku = p.sellerSku " + "and a.sellerId = :sellerId";</p> <p>while executing i am getting error</p> <p>org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [com.a.offering.dto.SellerDetailsDto] [select NEW com.s.offering.dto.SellerDetailsDto(p.productId) from com.a.offering.db.domain.PriceDetails p, com.a.offering.db.domain.AvailabilityDetails a where a.productId = p.productId and a.sellerSku = p.sellerSku and a.sellerId = :sellerId] at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54) at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47) at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82) at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)</p> <p>and so on...</p> <p>I am unable to figure out the error. Help me out</p> <pre><code>The code for SellerDetailsDto.java is package com.a.offering.dto; public class SellerDetailsDto { public String productId; public String sellerId; public String sellerSku; public Double sellPrice; public Double transferPrice; public Double sellerMRP; public Double a; public Double baseShippingFee; public Double addnShippingFee; public String propogationLevel; public String propogationValue; public String warehouseName; public int quantity; public int maxShippingTime; public int minShippingTime; public String getProductId() { return productId; } public void setProductId(String productId) { this.productId = productId; } public String getSellerId() { return sellerId; } public void setSellerId(String sellerId) { this.sellerId = sellerId; } public String getSellerSku() { return sellerSku; } public void setSellerSku(String sellerSku) { this.sellerSku = sellerSku; } public String getWarehouseName() { return warehouseName; } public void setWarehouseName(String warehouseName) { this.warehouseName = warehouseName; } public int getQuantity() { return quantity; } public void setQuantity(int quantity) { this.quantity = quantity; } public int getMaxShippingTime() { return maxShippingTime; } public void setMaxShippingTime(int maxShippingTime) { this.maxShippingTime = maxShippingTime; } public int getMinShippingTime() { return minShippingTime; } public void setMinShippingTime(int minShippingTime) { this.minShippingTime = minShippingTime; } public Double getSellPrice() { return sellPrice; } public void setSellPrice(Double sellPrice) { this.sellPrice = sellPrice; } public Double getTransferPrice() { return transferPrice; } public void setTransferPrice(Double transferPrice) { this.transferPrice = transferPrice; } public Double getSellerMRP() { return sellerMRP; } public void setSellerMRP(Double sellerMRP) { this.sellerMRP = sellerMRP; } public Double a() { return a; } public void a(Double aa) { </code></pre> <p>a }</p> <pre><code> public Double getBaseShippingFee() { return baseShippingFee; } public void setBaseShippingFee(Double baseShippingFee) { this.baseShippingFee = baseShippingFee; } public Double getAddnShippingFee() { return addnShippingFee; } public void setAddnShippingFee(Double addnShippingFee) { this.addnShippingFee = addnShippingFee; } public String getPropogationLevel() { return propogationLevel; } public void setPropogationLevel(String propogationLevel) { this.propogationLevel = propogationLevel; } public String getPropogationValue() { return propogationValue; } public void setPropogationValue(String propogationValue) { this.propogationValue = propogationValue; } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAashish Katta
    1. USAashish Katta
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COCan you post the code of com.tradus.offering.dto.SellerDetailsDto?
      singulars
      1. POerror: org.hibernate.PropertyNotFoundException: no appropriate constructor in class: com.a.offering.dto.SellerDetailsDto
      1. USPablo
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload