Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Hibernate fectch error

Posted on 2014-12-27
1
Medium Priority
?
131 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
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
A solution for Fortify Path Manipulation.
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.
Suggested Courses

824 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