Managing Data Sources - Oracle

Here are the steps that enable you to manage data sources using the OC4J home page of the Application Server Control:

1. On the OC4J home page, click the Administration tab.
   
2. In the Application Defaults section, click Data Sources.
   
3. In the Application Data Sources page (titled Data Sources), you’ll see a list of all the available global data sources, which all the deployed applications can use. Figure 8-5 shows the Data Sources page. Notice the OracleDS default data source shown in that page, which is an emulated data source. This means that applications can use only a specific database through this data source. A non-emulated data source will let the application access multiple databases.
   
4. You can create a new data source by clicking the Create button or edit a data source by clicking the Edit button in the Data Source Properties page. You’ve already seen how you can create a new data source in the previous section. Let’s see how you can edit a data source’s properties by using the Edit Data Source page, which you reach by clicking the Edit button.
   
5. In the Edit Data Source page, shown in Figure 8-6, you can configure data sources so they are mapped to Oracle and non-Oracle databases. You can configure the following data source-– related attributes from this page:
   
   
   Figure 8-5.  The Data Sources Page
   
   
   
   Figure 8-6.  The Edit Data Source Page

• Data source name
  
• Data source class
  
• JDBC URL
  
• Database username and password
  
• JNDI locations
  
• Connection attributes

Now that you have learned how to create and manage data sources, let’s turn to a discussion of the deployment methodologies for Web and EJB applications in the following subsections.