Home > Installation

SQL Server Configuration on WebSphere Application Server 6.1

ebx.properties configuration

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

SQL_SERVER_JDBC_DRIVER_PATH configuration

  1. Open WebSphere Administrative Console

  2. Select Environment > WebSphere Variables

  3. Click on New

  4. Input name SQL_SERVER_JDBC_DRIVER_PATH, enter the path to SQL Server JDBC driver libraries (the directory that contains file sqljdbc.jar)

  5. 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 User defined

  4. Step 2: Modify the implementation class name com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource

  5. Step 3: Modify the provider name SQL Server JDBC Driver

  6. Click on Next

  7. Step 4: Modify class path ${SQL_SERVER_JDBC_DRIVER_PATH}/sqljdbc.jar

  8. Click on Finish, then Save

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

  10. Click on New

  11. Enter name SQL Server JDBC Driver - 4.0 DataSource

  12. Enter the necessary parameters: Default user ID, Default password. Database name may be left blank since we shall provide a connect URL.

  13. Click on Apply, then Save

  14. Select SQL Server JDBC Driver - 4.0 DataSource

  15. Click on Custom properties in Additional Properties

  16. Click New

  17. Modify the property name URL

  18. Modify the property value, for example jdbc:sqlserver://127.0.0.1:1043;databasename=ebx

  19. Click on Apply, then Save

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

  21. Check the message for the connection test

Connection Pool Timeout and Transaction Service Timeout configuration

  1. Select Resources > JDBC Providers > SQL Server JDBC Driver > Data sources (version 4) > SQL Server 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 resource name already configured. In our example, it is jdbc/SQL Server 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