Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Hibernate fectch error

Posted on 2014-12-27
1
Medium Priority
?
126 Views
Last Modified: 2014-12-30
Hello there,

I am trying to fetch data from the MSSQL 2008 database using hibernate. But for some reason I get this error

data:"[Ljava.lang.Object; cannot be cast to com.erp.shared.entities.custom.CusNeighbourGroupInfo",

here is my hibernate code.

public DSResponse fetch(DSRequest dsRequest) throws Exception
    {
        logger.info("> fetch");
        DSResponse dsResponse = new DSResponse();
        Session hibernateSession = HibernateUtills.getInstance().getHibernateSession();

        String select = "SELECT\r\n" + 
                "    dbo.province.provincename as province,\r\n" + 
                "    dbo.province.capital,\r\n" + 
                "    dbo.province.code,\r\n" + 
                "    dbo.province.telcode,\r\n" + 
                "    dbo.province.taxcode,\r\n" + 
                "    dbo.county.countyname as county,\r\n" + 
                "    dbo.district.districtname as district,\r\n" + 
                "    dbo.zone.alternateName as zone,\r\n" + 
                "    dbo.neighbourhood.alternateName as neigbhour,\r\n" + 
                "    dbo.city.cityname as city,\r\n" + 
                "    dbo.city.taxcode,\r\n" + 
                "    dbo.city.fdocode,\r\n" + 
                "    count(dbo.customer.customeraltname) as countCustomer\r\n" + 
                "FROM\r\n" + 
                "    dbo.county\r\n" + 
                "INNER JOIN\r\n" + 
                "    dbo.province\r\n" + 
                "ON\r\n" + 
                "    (\r\n" + 
                "        dbo.county.provinceID = dbo.province.id)\r\n" + 
                "INNER JOIN\r\n" + 
                "    dbo.district\r\n" + 
                "ON\r\n" + 
                "    (\r\n" + 
                "        dbo.county.id = dbo.district.countyID)\r\n" + 
                "INNER JOIN\r\n" + 
                "    dbo.city\r\n" + 
                "ON\r\n" + 
                "    (\r\n" + 
                "        dbo.district.id = dbo.city.districtID)\r\n" + 
                "INNER JOIN\r\n" + 
                "    dbo.zone\r\n" + 
                "ON\r\n" + 
                "    (\r\n" + 
                "        dbo.city.id = dbo.zone.cityId)\r\n" + 
                "INNER JOIN\r\n" + 
                "    dbo.neighbourhood\r\n" + 
                "ON\r\n" + 
                "    (\r\n" + 
                "        dbo.zone.id = dbo.neighbourhood.zoneId)\r\n" + 
                "INNER JOIN\r\n" + 
                "    dbo.customer\r\n" + 
                "ON\r\n" + 
                "    (\r\n" + 
                "        dbo.neighbourhood.id = dbo.customer.neighbourhoodId)\r\n" + 
                "        Group By dbo.province.provincename,\r\n" + 
                "    dbo.province.capital,\r\n" + 
                "    dbo.province.code,\r\n" + 
                "    dbo.province.telcode,\r\n" + 
                "    dbo.province.taxcode,\r\n" + 
                "    dbo.county.countyname,\r\n" + 
                "    dbo.district.districtname,\r\n" + 
                "    dbo.zone.alternateName,\r\n" + 
                "    dbo.neighbourhood.alternateName,\r\n" + 
                "    dbo.city.cityname,\r\n" + 
                "    dbo.city.taxcode,\r\n" + 
                "    dbo.city.fdocode\r\n" + 
                "";

        Query query = hibernateSession.createSQLQuery(select);

        List<CusNeighbourGroupInfo> order = query.list();

        for (int i = 0; i < order.size(); i++)
        {
            if (order.get(i).getProvince() != null)
            {
                DebugTools.printj(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>                                    "+order.get(i).getProvince());
                order.get(i).getCounty();
                order.get(i).getDistrict();
                order.get(i).getCity();
                order.get(i).getZone();
                order.get(i).getNeighbour();
            }
        }

        Integer rowCount = order.size();

        dsResponse.setStartRow(0);
        dsResponse.setEndRow(rowCount);
        dsResponse.setTotalRows(rowCount);
        dsResponse.setData(order);
        HibernateUtills.getInstance().closeSession();
        DebugTools.printj(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>     FETCHEDDDDDDDD                               ");
        logger.info("< fetch");
        return dsResponse;
    }

Open in new window


and my POJO class

public class CusNeighbourGroupInfo
{
    private String province;
    private String county;
    private String district;
    private String city;
    private String zone;
    private String neighbour;
    
    public CusNeighbourGroupInfo()
    {

    }

    public CusNeighbourGroupInfo(String province, String county, String district, String city, String zone,
            String neighbour)
    {
        super();
        this.province = province;
        this.county = county;
        this.district = district;
        this.city = city;
        this.zone = zone;
        this.neighbour = neighbour;
    }

    public String getProvince()
    {
        return province;
    }

    public void setProvince(String province)
    {
        this.province = province;
    }

    public String getCounty()
    {
        return county;
    }

    public void setCounty(String county)
    {
        this.county = county;
    }

    public String getDistrict()
    {
        return district;
    }

    public void setDistrict(String district)
    {
        this.district = district;
    }

    public String getCity()
    {
        return city;
    }

    public void setCity(String city)
    {
        this.city = city;
    }

    public String getZone()
    {
        return zone;
    }

    public void setZone(String zone)
    {
        this.zone = zone;
    }

    public String getNeighbour()
    {
        return neighbour;
    }

    public void setNeighbour(String neighbour)
    {
        this.neighbour = neighbour;
    }

    @Override
    public String toString()
    {
        return "CusNeighbourCubeInfo [province=" + province + ", county=" + county + ", district=" + district +
                ", city=" + city + ", zone=" + zone + ", neighbour=" + neighbour + "]";
    }   
}

Open in new window


please help

cheers
Zolf
0
Comment
Question by:zolf
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 21

Accepted Solution

by:
Amitkumar Panchal earned 1500 total points
ID: 40521466
Your query returns multiple fields than the your POJO has. I would suggested keep the fields same as your POJO or create another POJO by accomodating all the fields.


Hope this helps.
0

Featured Post

Build and deliver software with DevOps

A digital transformation requires faster time to market, shorter software development lifecycles, and the ability to adapt rapidly to changing customer demands. DevOps provides the solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
I had a project requirement for a displaying a user workbench .This workbench would consist multiple data grids .In each grid the user will be able to see a large number of data. These data grids should allow the user to 1. Sort 2. Export the …
The viewer will learn how to implement Singleton Design Pattern in Java.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Suggested Courses

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question