Facing error while creating jdbc connection with oracle from "Universe Design Tool"
1. Open "Universe Design Tool" and create a new connection.
2. Fill correct details about connection and test it.
oracle installation path - "\app\******\product\11.2.0\dbhome_1\jdbc\lib"
or
Download the ojdbc driver from internet
It is good practice to paste the jdbc driver in C drive "C:\Users\******"
2. Now move to the installation directory of BO
"SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\"
3. Edit the file "oracle.sbo", open with notepad++.
Edit tab classpath, add new line highligheted in yellow color, which is pointing to the ojdbc driver (place in c drive as above).
4. Restart "universe design tool"
5. Try to create same connection again.
1. Open "Universe Design Tool" and create a new connection.
2. Fill correct details about connection and test it.
Error:
CS: Java Class not found in classpath : oracle.jdbc.OracleDriverCause : Missing JDBC driver
Resolve:
1. Copy Oracle JDBC driver from oracle server/client installtion path and paste it somewhere on machine at safe place.oracle installation path - "\app\******\product\11.2.0\dbhome_1\jdbc\lib"
or
Download the ojdbc driver from internet
It is good practice to paste the jdbc driver in C drive "C:\Users\******"
2. Now move to the installation directory of BO
"SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\"
3. Edit the file "oracle.sbo", open with notepad++.
Edit tab classpath, add new line highligheted in yellow color, which is pointing to the ojdbc driver (place in c drive as above).
4. Restart "universe design tool"
5. Try to create same connection again.
what should be specified in Netservice:
ReplyDelete