- Oracle ADF Faces Cookbook
- Amr Gawish
- 379字
- 2021-07-16 12:12:07
Connecting your application to a database
In this application, we want to display employees' data from the HR schema on a web browser and be able to navigate between different records using buttons that help us go to the first, next, previous, and last records; employees' information should be displayed in a form-based view.
In order to retrieve employees' information, we need to establish a connection with the HR database.
In this recipe, we will use JDeveloper to establish a connection between our new ADF application and the HR schema, which comes by default with the Oracle database.
How to do it…
In order to establish a connection with the HR schema, follow the ensuing steps:
- Expand the Connect to a Database checklist item from the checklist and click on the Create a Database Connection button that will open the Create Database Connection dialog.
- Choose a connection name of your choice; I named it
HRConnectionfor clarification. - Change the username and password of the HR user to match your database's HR schema; make sure you are pointing to the right host.
- Click on the Test Connection button to make sure everything works fine, and if everything is fine, you should see a Success! message.
- Click on OK to close the dialog box.
- Mark this item as done in the checklist as well.
How it works…
When working with applications in ADF, you will need to have connections in order to establish a communication channel with different systems. One of the important connections that will be usually needed is a database connection, which establishes a connection between your application and database.
When you entered the information, you provided the connection with all the information needed in order to connect to a specific user in a specific database instance.
Your connection can be an application-based resource like the one we configured in this recipe; alternatively, it can be inside JDeveloper's resource catalog, which can be helpful if you have multiple applications that use the same database connection.
After creating a database connection, we need to create the Business Service Layer that will use the database connection.
- Truffle Quick Start Guide
- 新一代物聯網架構技術：分層算力網絡
- 局域網組建、管理與維護項目教程（Windows Server 2003）
- Building RESTful Web services with Go
- 數字調制解調技術的MATLAB與FPGA實現：Altera/Verilog版（第2版）
- Android UI Design
- INSTANT LinkedIn Customization How-to
- 云工廠：開啟中國制造云時代
- 數字王國里的虛擬人：技術、商業與法律解讀
- 工業以太網技術：AFDX/TTE網絡原理、接口、互連與安全
- 物聯網
- 信息技術安全評估準則：源流、方法與實踐
- 區塊鏈社區運營手冊
- 無線傳感器網絡定位方法及應用
- 互聯網安全的40個智慧洞見（2018）