How Do I Issue a Query to the Database?

Coming from a PL/SQL background, it seems like executing a query on the database should be the simplest thing in the world. In PL/SQL, you just embed the query inside the code and provide variables for the return values. Unfortunately, in Java, this is not a trivial task at all. Unlike PL/SQL, Java has no native understanding of SQL and you have to do a lot of work to just get to the point where you can start submitting a statement to the database. ADF Business Components, of course, is designed to carry out a lot of the low-level work and makes the whole process more straightforward. So, knowing this, if you want to create a query using ADF Business Components, what do you do?

To illustrate the process, ...

Get Oracle JDeveloper 10g for Forms & PL/SQL Developers: A Guide to Web Development with Oracle ADF now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.