Dear SDNs,
I have created a BI JDBC system object to connect to the oracle database.
When i try to test the connection test, it gives system alias successful and backend connection fails please check the connection properties.
I have followed the procedure mentioned in the documetn called, "How to configure a BI JDBC System for Visual Composer".
Here are parameters i have used in the system object.
Connection URL: jdbc:oracle:thin:guidev/guidev@137.172.40.107:1521:gdev
Driver Class Name: oracle.jdbc.driver.OracleDriver
User Management: Admin,User
I have configured JDBC connector in Visual Administrator also.
Created a Oracle Driver by pointing to classes12.jar.
created a datasource by using the above created driver and used the Driver class Name name and URL are same as used in System object.
and the icon of datasource shows a right icon, if the parameters are wrong it sholud show, cross/wrong mark. Am i right!
In the log file it has mentioned that oracle.jdbc.driver.OracleDriver not found. when i try to test using connector container.
How can we solve this.
Ur inputs will be appreciated.
Thanks in advance,
Regards,
Sireesha.B