Creating Model Layer

Creating Model Layer:-

• As Discussed earlier, Creating Model layer means creating model layer objects i.e. EO, VO, Association, View Link, AM. 

Creating a Database Connection :-

• As the model layer is completely Database dependent, we will first need to create a database connection. To achieve the same, follow the navigation below.
• Right click on model (or go to File -> New) -> Choose Database connection (Under General -> Connection) -> Click on OK. 
• Give your connection a name. In my case “MyConnection” 
• Select Appropriate Connection Type. In my case the connection type is Oracle (JDBC). It allows you to create connection with oracle Enterprise edition and Express edition as I have tested.
• Enter the User Name for your database schema that you have already created and enter the password for the schema. 
• Enter the Host Name, Port Number that your database is listening and the SID for your database.
• Click on Test Connection to ensure that the values you have entered is correct and it allows you to connect with the database.
• If it shows “Success!”, means your connection is ready to be created. Click on OK to finish creating the Database Connection.

  

• You can see the created connection under the Application Resource Palette as below.