Skip to Content
0
Former Member
Feb 07, 2007 at 12:34 PM

Connection to BI-JDBC System fails

27 Views

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