---

                    final RepServiceAsync service = GWT.create(RepService.class);
                    final RepProperties props = GWT.create(RepProperties.class);


            RpcProxy<PagingLoadConfig, PagingLoadResult<ReportsList>> proxy = new RpcProxy<PagingLoadConfig, PagingLoadResult<ReportsList>>() {
                @SuppressWarnings("unchecked")
                @Override
                public void load(PagingLoadConfig loadConfig, AsyncCallback  callback) {
                  service.getReports(callback);
                }
              };


            ListStore<ReportsList> store = new ListStore<ReportsList>(props.key());
            final PagingLoader<PagingLoadConfig, PagingLoadResult<ReportsList>> loader = new PagingLoader<PagingLoadConfig, PagingLoadResult<ReportsList>>(
                    proxy);


            loader.setRemoteSort(true);
            loader.addLoadHandler(new LoadResultListStoreBinding<PagingLoadConfig, ReportsList, PagingLoadResult<ReportsList>>(
                    store));


            final PagingToolBar toolBar = new PagingToolBar(50);
            toolBar.getElement().getStyle().setProperty("borderBottom", "none");
            toolBar.bind(loader);


            ColumnConfig<ReportsList, String> nameCol = new ColumnConfig<ReportsList, String>(
                    props.name(), 150, "Name");
            ColumnConfig<ReportsList, String> pathCol = new ColumnConfig<ReportsList, String>(
                    props.path_name(), 150, "Path");


            List<ColumnConfig<ReportsList, ?>> l = new ArrayList<ColumnConfig<ReportsList, ?>>();
            l.add(nameCol);
            l.add(pathCol);


            ColumnModel<ReportsList> cm = new ColumnModel<ReportsList>(l);


            Grid<ReportsList> grid = new Grid<ReportsList>(store, cm) {
                @Override
                protected void onAfterFirstAttach() {
                    super.onAfterFirstAttach();
                    Scheduler.get().scheduleDeferred(new ScheduledCommand() {
                        @Override
                        public void execute() {
                            loader.load();
                        }
                    });
                }
            };


            grid.getView().setForceFit(true);
            grid.setLoadMask(true);
            grid.setLoader(loader);

---

---

public interface RepProperties extends PropertyAccess<ReportsList> {
    @Path("id")
    ModelKeyProvider<ReportsList> key();
    ValueProvider<ReportsList, String> name();
    ValueProvider<ReportsList, String> path_name();
}

---

---

public class ReportsList  implements Serializable {
    private static final long serialVersionUID = 1L;
    @Id
    int id;
    String name;
    String path_name;
   
    public ReportsList() {       
    }
   
    public ReportsList(int id, String name, String path_name) {
        super();
        this.id = id;
        this.name = name;
        this.path_name = path_name;
    }
   
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getPath_name() {
        return path_name;
    }
    public void setPath_name(String path_name) {
        this.path_name = path_name;
    }
}

---

---

public class RepServiceImpl extends RemoteServiceServlet implements RepService {
   
    private static final long serialVersionUID = 1L;
    @EJB
    private ReportEjb repManager;


    @Override
    public List<ReportsList> getReports() {
        List<ReportsList> reports = null; 
        reports = repManager.getReports();
        return reports;
    }
}

---

---

@Stateless
public class ReportEjbBean implements ReportEjb {

    @Resource(name = "java:jboss/datasources/gl_sec")
    private DataSource dataSource;
    private Connection con;


    @PostConstruct
    public void initialize() {
        try {
            con = dataSource.getConnection();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
   
    @PreDestroy
    public void ceanup() {
        try {
            con.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }


    @Override
    public List<ReportsList> getReports() {
        ArrayList<ReportsList> repList = new ArrayList<ReportsList>();
        String selectSQL = "SELECT id, name, path_name  FROM gl_reports";
        try {
            PreparedStatement preparedStatement = con
                    .prepareStatement(selectSQL);
            ResultSet rs = preparedStatement.executeQuery(selectSQL);
            while (rs.next()) {
                repList.add(new ReportsList(rs.getInt("id"), rs.getString("name"), rs
                        .getString("path_name")));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return repList;
    }
}

---

---

<div>{streamItem.comments:linkUrls}</div>

---