Forum Discussion

MCotter's avatar
MCotter
Occasional Contributor
13 years ago

Problems setting up a JDBC Datasource test step

Hi SmartBear Support

I'm trying to create a satasource test step that links to a database. I've populated the connection string and drvier but testing the connection gives the following error:

Failed to init connection for drvr [oracle.jdbc.driver.OracleDriver], connectionString [jdbc:oracle:thin@10.**.***.**:****:wsdev5]

Is there some additional configuration that I need to make this work?

6 Replies

  • Hi,

    hmm.. have you put the JDBC driver in the bin\ext folder? If yes - can you show the contents of the error log tab (at the bottom of the main soapUI window) which might give some more details!?

    thanks!

    /Ole
    SmartBear Software
  • Hi,

    thanks - well.. that doesn't give much more info.. is there any additional error information in the soapui-errors.log file in the soapui-pro\bin folder?

    regards!

    /Ole
    SmartBear Software
  • MCotter's avatar
    MCotter
    Occasional Contributor
    Hi

    Here is the file again - updated with additional lines of errors.

    Just to confirm there should be a JDBC driver in the bin/ext folder (the one with a readme file in it- is that correct?
  • Hi,

    yes - you should see a line in the soapui log tab showing that it has read the JDBC driver, for example

    Tue Jul 10 09:43:24 CEST 2012:INFO:Adding [C:\workspace\soapui-pro-4.5.1-nightly\bin\ext\mysql-connector-java-5.1.6-bin.jar] to extensions classpath

    The error you are getting suggests that it actually can not find the driver - do you have the above line for the oracle jdbc jar?

    /Ole
    SmartBear Software
  • MCotter's avatar
    MCotter
    Occasional Contributor
    Hi SmartBear Support.

    Got there in the end. I have established the connection. The performance is a bit slow but I have got the connection.

    Thanks for the tips.