Any options to connect groovy scripts to an Oracle Database?

[piKolin]

Hi!

There is some way to connect a groovy script to an Oracle Database using ojdbc6.jar?

I've been trying to build muy own docker image from the openapi plugin image, and copy the .jar to some paths (lib), but always get a java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Thanks for reading!

Awesome project!!

[outofcoffee]

Hi @piKolin, great question.

Imposter supports Stores; if there was an Oracle/JDBC store implementation would that meet your needs?

[piKolin]

It's possible, but i really need to perform a SQLquery, to get a mock response that depends on the http operation and the querystring parameters.

Right now i get this with SoapUI.

[hilsonp]

@piKolin This may help you: https://github.com/outofcoffee/imposter/issues/381 I described there how I could provide additional jar to groovy scripts. It worked fine with groovy-xml.jar One of my next test will be to try giving odbc7.jar and then I see no reason I would not be able to perform SQL queries from the groovy script into an Oracle database.

This is a few items down in my todo list and when I get there, I'll post my findings here.