Solved

Hibernate fectch error

Posted on 2014-12-27
1
114 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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Eclipse Neon and jdk 1.8.0 11 135
jar file executable 12 40
tomcat not starting 6 30
eclipse with Angularjs2.0 3 16
Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …
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…

910 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now