Configuring a Connection Pool and Data Source in WebLogic

By default, createiopinstance creates a connection pool for the IOP server to communicate to the database that users create and configure in site.properties.To connect to additional databases used in data sources or other scripts, configure a connection pool as described in this section.

  To configure a connection pool and data source in WebLogic:

  1. Start WebLogic Admin Server Console:

    • To start WebLogic Admin Server, run the following command:

      • Windows:

        EPM_ORACLE_HOME/../user_projects/domains/EPMSystem/bin/startWebLogic.cmd

      • Linux

        EPM_ORACLE_HOME/../user_projects/domains/EPMSystem/bin/startWebLogic.sh

      or select Start, then All Programs, then Oracle WebLogic, then User Projects, then EPMSystem, and then Start Admin Server for WebLogic Server Domain.

    • Log on to WebLogic Admin Server Console at http://serverName:7001/console.

  2. At the WebLogic Admin Server home page, click the Data Sources hyperlink.

    The Summary of JDBC Data Sources window is displayed with a table of existing data sources.

  3. In Change Center, click Lock and Edit.

  4. Under the data source table, click New. Select Generic Data Source.

    The Create a new JDBC Data Source window is displayed.

  5. In Name, use the default name or change to a name of your preference.

  6. In JNDI Name, enter jdbc/JDBCDataSource-1.

    Note:

    You must use jdbc/jndiname because you are searching the entire available data source on jdbc/ search criteria.

  7. Select a Database Type.

  8. Click Next.

    The JDBC Data Source Properties window is displayed.

  9. Select a Database Driver.

  10. Click Next.

    The Transaction Options window is displayed.

  11. Clear Support Global Transactions.

  12. Click Next.

    The Connection Properties window is displayed.

  13. Enter the following values:

    • Database Name: Database Name

    • Host Name: Database Server Name

    • Port: 1521

    • Database User Name: dbusername

    • Password: dbPassword

    • Confirm Password: dbPassword

  14. Click Next.

    The Test Database Connection window is displayed.

  15. Click Test Configuration. The “Connection test succeeded” message appears (in green) at the top of the screen.

  16. Click Next.

    The Select Targets window is displayed.

  17. Select IOPServer_iopinstance1 from clusters and then click Finish.

    The Summary of JDBC Data Sources window is displayed with a new entry in the Data Sources table.

  18. In Change Center, (top left portion of the window), click Activate Changes.

  19. To access the data sources settings, click Lock & Edit for the selected data source from the Summary of JDBC Data Sources table, and then select the Configuration tab.