I am new on CAF.
Instead of using database connector, which is no much flexible for the query statement. I want to build a dynamic query against Oracle database, and display result in a table on view.
I would like to write a following code in Designer, and binding the result with table in view.
Connection connection = DriverManager.getConnection(url, “user”, password");
rs=stmt.executeQuery(“SELECT * FROM tbl_Employee”);
Is it a correct approach?