Hi

    I am using jonas-2.1.2 on linux
    I am running theEJBServer on two machines.
    I am having the same configuration of both thae machines.
    I am passing some query to my session bean ,
    in session bean  i am doing ...


public Object getQueryResult(String sqlQ)
     throws RemoteException{
        //This is treemap which contains Key Value
        java.util.Vector retVect = new java.util.Vector();
        System.out.println("Hello In side getqueryResult Session Beans");
        try{
           Context sessionContext = new InitialContext();
           DataSource ds  = (DataSource) sessionContext.lookup("jdbc_1");
           String   retStr= "";

           Connection con = ds.getConnection();
           Statement stmt = con.createStatement();
           ResultSet rS = null;
           rS   = stmt.executeQuery(sqlQ);
           while(rS.next()){
              retStr="";
              for(int cntr=1;cntr<=(rS.getMetaData()).getColumnCount();cntr++){
                 if(cntr==1){
                    retStr=rS.getString(cntr);
                    continue;
                 }
                 retStr +="|"+rS.getString(cntr);
              }
              retVect.add(retStr);
           }
           rS.close();
           stmt.close();
           con.close();
        }
        catch(Exception E){


----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".

Reply via email to