Problem:

• Product Name: BES
• Product Version: 5.x and 6.x
• Product Component: Database Connection
• OS: Windows and Solaris

How to configure the JBDC OCI driver in the BES5.x and 6.x servers on the Unix environment?

Resolution:

Steps to configure:

1) Deploy Oracle JDBC driver (ojdbc14.jar) into the BES partition.

2) On BES server side, where your EJB is talking to the Oracle Database.

  Please do the following steps:

    a) Right click on the partition name.

    b) Select configure and then add the following environment variables into the "Environment variables" box:

        LD_LIBRARY_PATH=/export/home/starteam/OraHome1/lib

        ORACLE_HOME=/export/home/starteam/OraHome1

      Please adjust the above environment variables according to your Oracle Environment.

3) There is no need to copy any of the Oracle/lib files into the BES/lib

4) Open the EAR file in the Borland DDE, then make changes on the JNDI file according to your Oracle database and click save and exit of the DDE.

5) Deploy the modifed EAR file into the BES partition.

6) Restart the partition.