cancel
Showing results for 
Search instead for 
Did you mean: 

SMP3.0 SP09 PL01 - Oracle Driver Not Found

vicenteveiga
Participant
0 Kudos

Hi all,

After a failed attempt to get SMP3.0 to consume a SOAP WS, I'm about to try to directly consume an Oracle DB.

I've followed several tutorials on how to setup the SMP to consume the Oracle DB, after creating the Destination configuration for the Oracle DB, I get the following message: "Connection test failed - Driver class oracle.jdbc.driver.OracleDriver not found".

I already followed several possible fixes for this issue:

  • Started with
  • Checked the note 2146914
  • Followed the following discussion resolution

I've tried the ojdbc6.jar and ojdbc7.jar. I've tried the generated bundle from eclipse and SMP "create_jdbc_bundle.bat", I've tried to put it directly in the Server\lib folder and also in the pickup folder.

Can anyone explain me why after following all the above tutorial, SAP note and discussion I can't get it to work?

Best regards,

Vicente

Accepted Solutions (1)

Accepted Solutions (1)

Jitendra_Kansal
Product and Topic Expert
Product and Topic Expert
0 Kudos

Thanks Vicente for sharing this solution. Copying solution to those don't have access to Market place:


Cause of this question: after adding the sqljdbc4.jar into server\lib the service needs to be re-generated to reflect the CLASSPATH change for it.

Resolution

  1. Stop the SMP processes and delete the contents of ${MobilePlatform3}\Server\configuration\org.eclipse.osgi\*
  2. Copy the sqljdbc4.jar into server\lib dir.
  3. Re-generate the SMP services.
    a)      Stop all the smp service/processes and ensure that there are no java processes running for SMP.
    b)      In a DOS command window, go to the server\bin directory.
    c)      Run:  svcutil.bat -uninstall
    d)      Run:  svcutil.bat -generate
    e)      Run:  svcutil.bat –install

Regards,

JK

Answers (1)

Answers (1)

Jitendra_Kansal
Product and Topic Expert
Product and Topic Expert
0 Kudos

Did you also try with command line as below? What output do you see?

F:\SAP\MobilePlatform3\Server\tools\dbconfig>create_jdbc_bundle.bat -oracle C:\temp\ojdbc7.jar

vicenteveiga
Participant
0 Kudos

Hi Jitendra,

Unfortunately I've tried your suggestion several times but none of them worked:

Regards,

Vicente

Jitendra_Kansal
Product and Topic Expert
Product and Topic Expert
0 Kudos

Oh, i didnt know this message:


Starting with SMP 3.0 SP08 there is no requirement to wrap the JDBC driver as an OSGi bundle.

The unaltered JDBC driver can be placed into $SMP_HOME/lib and it will be exposed through the system classloader (or if previously wrapped, that bundle could be also placed in $SMP_HOME/lib, as long as it was an inline wrapping).

If the driver has been placed previously in the pickup directory with SP07, this should be removed.

Also please verify that the bundle was successfully uninstalled (no entries for this bundle in $SMP_HOME/configuration/org.eclipse.equinox.simpleconfigurator/bundles.info, otherwise remove those lines) and restart.

The normal procedure for installing the oracle or mssql driver prior to SP08 was to wrap the driver as mentioned above and install it into the server at $SMP_HOME/plugins/sqlserver-jdbc-osgi_3.0.0.M3.jar.

Upgrading from this is definitely handled by the installer. If the driver was in the pickup folder, then please follow the manual steps as mentioned

.

Since you are SP09, you dont need to wrap JDBC driver as OSGi bundle. Have you also tried it?

Calling


Regards,

JK

andreas_wegmann
Employee
Employee
0 Kudos

Hi Vicente,
as Jitendra mentioned since SMP 3.0 SP08 it's no longer required to wrap JDBC driver as OSGI bundle.
Please take a look at SAP KBA 2146914 https://service.sap.com/sap/support/notes/2146914
Kind regards,
Andreas

vicenteveiga
Participant
0 Kudos

: I've tried both ojdbc6.jar and oracle-jdbc-osgi_11.2.0.x_3.0.0.M3.jar placed in /Server/lib folder and inside the /Server/plugins folder as well.

: As I was reporting to Jitendra, I've followed those instructions and did it the following way:

  1. Removed the oracle-jdbc-osgi_11.2.0.x_3.0.0.M3.jar from the /Server/pickup as well as the ".deploy" file from .state folder.
  2. Placed the oracle-jdbc-osgi_11.2.0.x_3.0.0.M3.jar inside /Server/lib folder with SMPServer stopped, started the server and still no Oracle Driver is found when testing the connection.
  3. Removed the oracle-jdbc-osgi_11.2.0.x_3.0.0.M3.jar and placed the ojdbc6.jar inside /Server/lib folder with SMPServer stopped, started the SMP3.0 Server and still no Oracle Driver is found when testing the connection.

I've also removed the lines regarding the osgi bundle inside configuration/org.eclipse.equinox.simpleconfigurator/bundles.info file before starting the SMP Server.

Regards,

Vicente

Jitendra_Kansal
Product and Topic Expert
Product and Topic Expert
0 Kudos

Last point from my side,

As per SAP Note, Did you verify that the bundle was successfully uninstalled (no entries for this bundle in $SMP_HOME/configuration/org.eclipse.equinox.simpleconfigurator/bundles.info, otherwise remove those lines) ?

I would also recommend you to raise an OSS ticket on this.

Regards,

JK

vicenteveiga
Participant
0 Kudos

I was wondering if I downgrade the SMP Server to SP5 or so, I would be able to get to test the connection...

I'm very disappointed with SMP3. Everytime I try to do something I "hit a wall".

There's not a working "debug mode" for those who need to develop custom code services and if I follow the SAP notes and discussion solutions I'm not able to get the JDBC driver integration with SMP3.

Perhaps SMP needs a new complete version (SMP4?) focusing developers. Or perhaps a developing environment to later deploy on a production environment.

Well, thank you all for your answers.

Regards,

Vicente

vicenteveiga
Participant
0 Kudos

Hi all,

I've opened an incident in SAP customer support as you suggested and SAP Support indicated the SAP KBA 2202778 and now the error went away.

Best regards,

Vicente