A little little little bit of code would be really great.

Log the class type and find out what the incoming class is.

result are coming from two pojo and we are not able to get where should we place the return type

It's obvious that the results are coming from your two POJOs Company and Founder but you only get two properties. So I think you get an array with two Strings.
To check that log the type of each element that is in your idList. If it is an array iterate the array and log the type of each field. Then check your casts if you expect another type that...

below is the code , please advice me where i am doing wrong

List getrecordsList4=new ArrayList();
List mylist=new ArrayList();

getrecordsList4 = getHibernateTemplate().find("select co.chinesename fo.englishname from Company as co , founder as fo where co.companyid=fo.companyid);


if (getrecordsList4 != null && getrecordsList4.size() > 0)
{

Iterator itr = getrecordsList4.iterator(); // this line shows class cast exception
while (itr.hasNext())
{
Company company = (Company)itr.next();
CompanyDTO companyDTO = new CompanyDTO();
companyDTO.setChinesename(company.getChinesename());
mylist.add(companyDTO);

}

return mylist;
}

it is showing the same error in the below (this time i am using one pojo)

getrecordsList4 = getHibernateTemplate().find("select co.chinesename from Company as co where co.companyid=2"");

I cannot believe that the line you placed the comment in throws the exception. The post the stacktrace of the exception and the complete class so we can compare the linenumbers.

This line is wrong: Company company = (Company)itr.next();
The next element from the iterator is not a company. Even in your last post you do NOT receive an instance of Company. You get the type of the field "chinesename" (I think a String.)

thanks CDillinger

as i changed the this code String ss = (String)itr.next();

getHibernateTemplate().find("select co.chinesename from Company as co where co.companyid=2"); this query is running fine now

but when i use two pojos it gives me below exception

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: [Ljava.lang.Object; cannot be cast to java.lang.String
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:545)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:486)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)


root cause

java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to java.lang.String
com.uhc.add.actions.CompanyAction.getrecordsList4(CompanyAction.java:473)
com.uhc.add.actions.CompanyAction.execute(CompanyAction.java:288)
org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)


note The full stack trace of the root cause is available in the Apache Tomcat/5.5.20 logs

i have tried below , it is not showing an exception but there is no output

List getrecordsList4=new ArrayList();
getrecordsList4 =getHibernateTemplate().find("select co.chinesename,fo.fenglishname from Company as co,Founder as fo where co.companyid=fo.companyid and co.companyid=1");

if (getrecordsList4 != null && getrecordsList4.size() > 0)
{
Iterator itr = getrecordsList4.iterator();
while (itr.hasNext())
{
Object object= itr.next();
if (object instanceof Company)
{
Company company=(Company)object;
company.getChinesename();
}

}

i have log the class type also it is rsulting the array of Object []

correct me if i m wrong

"select co.englishname,fo.englishname from Company co,Founder fo where co.companyid=fo.companyid"

"select new NewClass(co.englishname,fo.englishname) from Company co,Founder fo where co.companyid=fo.companyid"

now retrieve the object of NewClass.
NewClass must have same constuctor.

Great thanks Tarun

my qyery is running absolutely fine with your suggestions.