Home > Installation

Oracle 10g Configuration on WebSphere Application Server 6.0

ebx.properties configuration

In section « Persistence parameters » of file ebx.properties, define oracle as the persistence database as follows: ebx.persistence.factory=oracle. Parameters url, user and password are not necessary, they are defined in WAS (WebSphere Application Server) data source configuration.

ORACLE_JDBC_DRIVER_PATH configuration

  1. Open WebSphere Administrative Console

  2. Select Environment > WebSphere Variables

  3. Select ORACLE_JDBC_DRIVER_PATH, enter the path to Oracle JDBC driver libraries (the directory that contains files ojdbc14.jar and orai18n.jar for Oracle 10g)

  4. Click on Apply button, then Save

JDBC providers configuration

  1. Select Resources > JDBC Providers

  2. Click on New

  3. Step 1: Select the database type, select Oracle

  4. Step 2: Select the provider type, select Oracle JDBC Driver

  5. Step 3: select the implementation type, select Connection pool data source

  6. Click on Next

  7. Click on Apply, then Save

  8. Select Oracle JDBC Driver

  9. Click on Data sources (Version 4) in Additional Properties

  10. Click on New

  11. Enter name Oracle JDBC Driver - 4.0 DataSource

  12. Enter the necessary parameters, especially Database name, Default user ID, Default password

  13. Click on Apply, then Save

  14. Select Oracle JDBC Driver - 4.0 DataSource

  15. Click on Custom properties in Additional Properties

  16. Modify the URL value, for example jdbc:oracle:thin:@127.0.0.1:1521:orcl

  17. Modify the driverType value, enter the value thin for example in Custom properties

  18. Click on Apply, then Save

  19. Click on Test connection button in page JDBC providers > Oracle JDBC Driver > Data sources (version 4) > Oracle JDBC Driver - 4.0 DataSource.

  20. Check the message for the connection test

Connection Pool Timeout and Transaction Service Timeout configuration

  1. Select Resources > JDBC Providers > Oracle JDBC Driver > Data sources (version 4) > Oracle JDBC Driver - 4.0 DataSource > Connection pool properties, configure the parameters according to your needs

  2. Select Servers > Application Servers > server name > Container services > Transaction service, configure the parameters according to your needs

ebxPlatform.ear deployment

  1. In page Applications > Install New Application, select the application to deploy (here ebxPlatform.ear), then click next, next, continue

    1. Step 1: Specify options for installing enterprise applications and modules

    2. Step 2: Map modules to servers

    3. Step 3: Map resource references to resources, select the JNDI ressource name already configured. In our example, it is jdbc/Oracle JDBC Driver - 4.0 DataSource. Select the module ebx.war, enter the JNDI name in the displayed table, then click on OK button

    4. Step 4: Map virtual hosts to web modules

    5. Step 5: Summary, click on "finish" button

  2. If the application is already deployed, you can select Applications > Enterprise Applications > EBX.Platform > Mapping resource references to resources

 

Home > Installation