Forum Discussion

cybrey's avatar
cybrey
New Contributor
15 years ago

Oracle JDBC driver and LoadUI

I suspect the answer to this question is pretty simple. I have a working testcase in soapUIpro using an Oracle datasource feeding into a SOAP request. I've also a different testcase feeding from a static request into the same request. If I pull the static one into loadUI it works no problems, if I pull the Oracle based one it doesn't work.

I've created an 'ext' directory in the loadui root and added ojdbc5.jar into it, beyond this what am I missing?

7 Replies

  • cybrey's avatar
    cybrey
    New Contributor
    15 years ago

    "0","[]","1290694035109","java.lang.Exception: Failed to prepare testStep [GetEventSource]; com.eviware.soapui.support.SoapUIException: Failed to init connection for drvr [oracle.jdbc.driver.OracleDriver], connectionString [jdbc:oracle:thin:geneva_admin/#####@<IP ADDY>:1521:<SID>]"


    After reading the thread above I hooked up the error output and this is appearing. So yes its struggling to make the jdbc connection.

    Should also note I've read around on the forum and tried the driver file in the lib directory of loadui as well.
  • cybrey's avatar
    cybrey
    New Contributor
    15 years ago
    Little bit more invesitgation... moved the ojdbc driver back to the newly created 'ext' folder and we get this error:

    "9","[]","1290702033301","java.lang.NoClassDefFoundError: org/ietf/jgss/GSSException"
  • cybrey's avatar
    cybrey
    New Contributor
    15 years ago
    Finally .. a fix..

    Adding in the rt.jar file into <loadui>\ext fixed the issue.
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    15 years ago
    Hello,

    The problem with the org.ietf.jgss package is that is is not imported by the soapUI bundle from OSGi runtime. An alternative to adding rt.jar to the ext may be to edit the config.properties file which should be available in the "conf" directory of your loadUI installation. Find and modify the exiting line:

    org.osgi.framework.bootdelegation=com.jprofiler.agent


    and change it to:

    org.osgi.framework.bootdelegation=com.jprofiler.agent,org.ietf.jgss


    If you try this, please let us know your results!

    Regards,
    Dain
    eviware.com
  • Beno_Iskratel's avatar
    Beno_Iskratel
    Frequent Contributor
    15 years ago
    Hi,

    I'm having this error:
    I copied SolidDriver2.0.jar file in /jre/lib/ext
    Is this the right path?

    0 [com.eviware.soapui.support.SoapUIException: Failed to init connection for drvr [solid.jdbc.SolidDriver], connectionString [jdbc:solid://172.18.113.28:1325/itsolid/#####], com.eviware.soapui.support.SoapUIException: Failed to init connection for drvr [solid.jdbc.SolidDriver], connectionString [jdbc:solid://172.18.113.28:1325/itsolid/#####], com.eviware.soapui.support.SoapUIException: Failed to init connection for drvr [solid.jdbc.SolidDriver], connectionString [jdbc:solid://172.18.113.28:1325/itsolid/#####]] 1291200398371 Failing due to failed test step

    I also added this line:
    org.osgi.framework.bootdelegation=com.jprofiler.agent,org.ietf.jgss
    into config.properties but no success.

    Test case is working with SoapUI.
    Here's similar topic from SoapUI: http://www.eviware.com/forum/viewtopic.php?f=2&t=5447

    With best regards,
    Beno
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    15 years ago
    Hello,

    The correct path to place the SolidDriver jar file into is in <loadui installation>/ext/, so for example, it might be: c:\Program Files\eviware\loadUI-1.0.2-SNAPSHOT\ext\ under Windows. This ext directory doesn't exist by default, so you will probably have to create it. Hope this helps!

    Regards,
    Dain
    eviware.com