?
Solved

how do client get data packet returned from EJB method (public List getResultset(String sql)) ?

Posted on 2003-11-23
6
Medium Priority
?
492 Views
Last Modified: 2013-11-24
Hi,
  where I define one method in Entity bean which return query result,I test it in Entity bean body,it can get right return.But from client ,I can not get returned data. What is the reason for that?
java.lang.NullPointerException

      void com.evermind.server.rmi.RMIConnection.EXCEPTION_ORIGINATES_FROM_THE_REMOTE_SERVER(java.lang.Throwable)

            RMIConnection.java:1558

      java.lang.Object com.evermind.server.rmi.RMIConnection.invokeMethod(com.evermind.server.rmi.RMIContext, long, long, java.lang.reflect.Method, java.lang.Object[])

            RMIConnection.java:1511

      java.lang.Object com.evermind.server.rmi.RemoteInvocationHandler.invoke(java.lang.Object, java.lang.reflect.Method, java.lang.Object[])

            RemoteInvocationHandler.java:55

      java.lang.Object com.evermind.server.rmi.RecoverableRemoteInvocationHandler.invoke(java.lang.Object, java.lang.reflect.Method, java.lang.Object[])

            RecoverableRemoteInvocationHandler.java:22

      java.util.List __Proxy1.getResultset(java.lang.String)

      void Samplebbs_live.Tb_userClient.main(java.lang.String[])

            Tb_userClient.java:84

  Entity Bean:
  public List getResultset(String sql)
  {
   List list = new ArrayList();      
    try
   {
    dbconn = getConnection();
    st = dbconn.createStatement();
    rs = st.executeQuery(sql);
    ResultSetMetaData mtdata = rs.getMetaData();
    if (rs==null)
    {
      System.out.println("null data");
      return Collections.EMPTY_LIST;      
    }      
    int col = mtdata.getColumnCount();
    while (rs.next())
    {
       map = new HashMap(col);
       for (int i=1;i<=col;i++)
       {
           map.put(mtdata.getColumnName(i),rs.getString(i));                
       }
       list.add(map);
    }
    dbclose(st,rs,dbconn);
    for (int j=0;j<list.size();j++)
   {
     Map m = new HashMap(col);
     m = (Map)list.get(j);
     System.out.println(j);
     System.out.println((String)m.get("mailaddr"));
   }
   }

   catch (Exception se)
   {
     se.printStackTrace();
     return Collections.EMPTY_LIST;
   }   System.out.println("4");
    return list;
  }
but when I called it from client by the following way:
...............
      List lt = new ArrayList();
      lt = tb_user.getResultset("select * from tb_user");    ---error here
     //tb_user ---EJB Object
..............
0
Comment
Question by:hexiaoquan
[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
  • 3
6 Comments
 
LVL 35

Expert Comment

by:girionis
ID: 9809290
 Can you do a System.out.println(list) in your EJB before this line: return list; and tell us the output?
0
 
LVL 35

Expert Comment

by:girionis
ID: 9809297
 Also look at the server console/logs for any possible exceptions.
0
 

Author Comment

by:hexiaoquan
ID: 9809357
Yeah,I can get System.out.println(List) in EJB

  for (int j=0;j<list.size();j++)
   {
     Map m = new HashMap(col);
     m = (Map)list.get(j);
     System.out.println(j);
     System.out.println((String)m.get("mailaddr"));
   }

 It can run well.
Now I get the right answer,Return value Type shout implements java.io.Serializable,
but list do not implement it.so I change it to Vector or rowset.It is ok now

thanks.
0
 
LVL 35

Expert Comment

by:girionis
ID: 9809361
 Ah... yes true, the object should implement serializable if you want to return it...

  Please ask a question here http://www.experts-exchange.com/Community_Support/ for zero points to PAQ the question and refund the points to you.
0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
ID: 11688317
Submitted to PAQ with points refunded (50)

DarthMod
Community Support Moderator
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

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…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month13 days, 10 hours left to enroll

800 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