Error when connecting an oracle DB with Integration gateway
I followed the steps from the blog How to connect an Oracle DB with Integration Gateway in SMP3 and the ojdbc was deployed successfully to SMP. Still, i'm getting "Driver class oracle.jdbc.driver.OracleDriver not found" error message when i try to test my connection. The first difference i saw when completing these steps was that I'm using SMP3 SP05, could this be the issue?
Jitendra Kansal replied
Could you delete previously deployed jdbc jar file and recreate a new one as mentioned below:
- Copy the supported ojdbc driver to a temporary folder on the same partition as the SMP installation folder e.g. C:\ojdbc.
- Open a command prompt and select the folder "..\SAP\MobilePlatform3\Server\tools\dbconfig"
- Execute the following command: "create_jdbc_bundle.bat -oracle <path to the oracle ojdbc driver>"
C:\SAP\MobilePlatform3\Server\tools\dbconfig>create_jdbc_bundle.bat -oracle "C:\ojdbc\ojdbc6.jar"
- Copy the new created "oracle-jdbc-osgi_<version>_3.0.0.M1,jar" to "..\SAP\MobilePlatform3\Server\pickup"