Service Virtualization

Hi,

Could you please let me know how to connect CA Devtest with Oracle database . I wanted to set up JDBC-ODBC connection. I entered JDBC Driver and Connect string and entered my Uid & password. Getting below error when I click on Test Connection buttton

java.lang.ClassNotFoundException: JDBC-ODBC Bridge (sun.jdbc.odbc.JdbcOdbcDriver)
 at java.net.URLClassLoader$1.run(Unknown Source)
 at java.net.URLClassLoader$1.run(Unknown Source)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.net.URLClassLoader.findClass(Unknown Source)
 at java.lang.ClassLoader.loadClass(Unknown Source)
 at java.lang.ClassLoader.loadClass(Unknown Source)
 at com.itko.lisa.jdbc.JDBCNode.getConnection(JDBCNode.java:613)
 at com.itko.lisa.jdbc.JDBCNode.executeSQL(JDBCNode.java:370)
 at com.itko.lisa.jdbc.JDBCNodeEditor.doExec(JDBCNodeEditor.java:483)
 at com.itko.lisa.jdbc.JDBCNodeEditor$6.doCallback(JDBCNodeEditor.java:417)
 at com.itko.util.swing.panels.ProcessingDialog$2.run(ProcessingDialog.java:194)
 at java.lang.Thread.run(Unknown Source)

Am I missing to add any .jar file ? please let me know why I'm getting this error. Thanks !!!

We deliver the Oracle JDBC driver in the DEVTEST_HOME/lib/shared folder, so make sure you are using this driver and not another one.  Are you using a different Oracle JDBC driver than what we deliver?

    To connect to Oracle database from Devtest, use the driver name as: oracle.jdbc.driver.OracleDriver and connection string format as "jdbc:oracle:thin:@SERVERNAME:1521:DBNAME and give server credentials to connect to the database.

   Since the JDBC driver for oracle database has shipped with the product, you no need to copy the driver jar files manually.

Thanks a bunch Srikanth. This solved my problem :-)