create global temporary table TEMP(ID NUMBER not  null ) on commit preserve rows;

             try  {
                InitialContext initialContext =  new  InitialContext();
                ds = (DataSource) initialContext.lookup(EJB_CONSTANTS.
                    DATASOURCE_NAME);
                Iterator it = hs.iterator();
                con = ds.getConnection();
                 while  (it.hasNext()){
                    String id = (String)it.next();
                stmt = con.prepareStatement(
                    "INSERT INTO TEMP (ID) VALUES ("+id+")");
                stmt.executeUpdate();
                }
            }
             catch  (Exception e) {
                 throw   new  EJBException(e);
            }
             finally  {
                 if  (stmt !=  null ) {
                    stmt.close();
                }
                 if  (con !=  null ) {
                    con.close();
                }
            }