Re: Return a struct or a ResultSet ?

Hello Darren,

The First problem is resolve. You was correct thx a lot !

java -Xbootclasspath/p:OB.jar  hello.Server
was the solution of my first problem.

Is it possible to return a ResultSet ( Java.sql.*) ?

To return a structure, I have some error :

Console Server : (always the same errors)
azureus0 // Println of my resultset

azureus Version du projet : 0 // println of my object 

warning: Servant method raised a non-CORBA exception

Client receives this exception as CORBA::UNKNOWN

operation name: "req"

id: iiop

local address: 192.168.0.13:1185

remote address: 192.168.0.13:1186

java.lang.NullPointerException

at com.ooc.CORBA.OutputStream.write_string(OutputStream.java:1073)

at Test.projectHelper.write(projectHelper.java:113)

at Test.myprojectsHelper.write(myprojectsHelper.java:76)

at Test.SqlPOA._OB_op_req(SqlPOA.java:111)

at Test.SqlPOA._invoke(SqlPOA.java:84)

at com.ooc.OBPortableServer.ServantDispatcher.dispatch(ServantDispatcher.java:214)

at com.ooc.OBPortableServer.POA_impl._OB_dispatch(POA_impl.java:1775)

at com.ooc.OB.DispatchRequest_impl.invoke(DispatchRequest_impl.java:52)

at com.ooc.OB.DispatchSameThread_impl.dispatch(DispatchStrategyFactory_impl.java:46)

at com.ooc.OB.Upcall.invoke(Upcall.java:434)

at com.ooc.OB.ThreadedGIOPConnectionHandler.doReceive(ThreadedGIOPConnectionHandler.java:516)

at com.ooc.OB.GIOPReceiverThread.run(ThreadedGIOPConnectionHandler.java:57)




Console Client :
org.omg.CORBA.UNKNOWN vmcid: 0x0 minor code: 0 completed: No

at com.ooc.OB.Util.unmarshalSystemException(Util.java:272)

at com.ooc.OB.GIOPConnection.processReply(GIOPConnection.java:743)

at com.ooc.OB.GIOPConnection.processMessage(GIOPConnection.java:625)

at com.ooc.OB.ThreadedGIOPConnectionHandler.doReceive(ThreadedGIOPConnectionHandler.java:484)

at com.ooc.OB.GIOPReceiverThread.run(ThreadedGIOPConnectionHandler.java:57)

The error appear on  this instruction :
 in the Client :
project[] proj =sql.req();

the corp of req() :(located in sql_impl.java) it's just a little method to try Orbacus before the conception of my project
public project[] req() {
  // TODO Auto-generated method stub
  
  try {
   pstmt=con.prepareStatement("SELECT * FROM project WHERE proj_projectID = ?");
   pstmt.setInt(1,2);
   rs=pstmt.executeQuery();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  try {
   
   project[] myprojects ;
   Vector proj = new Vector();
   //while(rs.next());
   //{

   rs.next();
 
   System.out.println(rs.getString("proj_name")+rs.getString("proj_version")+"viens : ");
   project p = new project ( rs.getString( "proj_name" ),rs.getString("proj_version"));
   p.affiche();
   proj.addElement( new project ( rs.getString( "proj_name" ),rs.getString("proj_version")) );

      //}
     myprojects = new project[proj.size()];
 
        proj.copyInto(myprojects);
 
   pstmt.close(); 
 
     
   return myprojects ;
   //myprojects;
   }
  catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
   }
   return null;
 }



Thx a lot for your help.

Regards,
Julien Regnart

_______________________________________________
OB-Users Mailing List - [email protected]
http://mail.ooc.nf.ca/mailman/listinfo/ob-users
Visit our support FAQ before you send a message.
http://www.orbacus.com/faq/support.html