SAP Lumira connectivity error.

[former_member539587]

Hi,

I am trying to connect to free hand SQL on a database. I am trying to connect to oracle 11g database. I have installed the drivers also. But still getting the error, 'Java class not found in classpath: oracle.jdbc.Oracledriver. Please help.

Thanks in advance,

Priyanka

[TammyPowlas · Accepted solution]

Please share details such as if you are using Lumira Desktop, which version, etc.

Please also share screen shots (use the camera icon to upload)

[former_member539587 · Accepted solution]

Hi Tammy,

I am using Lumira Desktop, the version is 1.28.. Please find the screen shot of the error that is occuring while i am trying to query using sql below.

Please share your valuable suggestions on how to rectify the same.

Thanks in advance,

Priyanka

[TammyPowlas · Accepted solution]

Hi - thank you for the screen shot

I don't have an Oracle 11 database to try this myself; I Googled the error message and found this on Stack Overflow:

java - JDBC Driver class not found: oracle.jdbc.OracleDriver in oracle 11g - Stack Overflow

Could this apply in your situation?

[former_member539587]

Hi Tammy/Shankar,

Thank you so much for your help. I had not set the class path bec of which i was getting that error. Got it resolved now. Thanks again.

Regards,

Priyanka

[shankarsgs]

Hi Saipriyanka,

Glad you got it resolved.

Regards

Shankar

[shankarsgs]

Hi Saipriyanka,

Did you download the right version of driver? Also include the driver JDBC path in your environment variables so that the supporting JAR files will be used by your main driver.

Regards