Oracle DB connection
Hi I have to connect to the Oracle DB using Oracle Thin. I have added the jar to the ext folder I want to connect both using JDBC step and Groovy And i want to connect using OS Authentication . ...
Forum Discussion
Hey sreedv1986,
Are you saying you want to configure a connection using groovy as well as using the jdbc gui config?
Can you confirm that please? Reason i ask, if youve already got a connection setup in your jdbc preferences then you dont need to configure the connection in groovy to use it...
Also. If you want a db connection have you checked what version of db youre using to ensure you have the correct jdbc drivers and likewise ensured youve got the correct version of java to run the jdbc drivers?
Also, as with the other oracle post on the board at the moment, youll need to confirm whether youre connecting to a db using service name or sid as they require different connectiom strings.
Cheers,
Rich
Are you saying you want to configure a connection using groovy as well as using the jdbc gui config?
Can you confirm that please? Reason i ask, if youve already got a connection setup in your jdbc preferences then you dont need to configure the connection in groovy to use it...
Also. If you want a db connection have you checked what version of db youre using to ensure you have the correct jdbc drivers and likewise ensured youve got the correct version of java to run the jdbc drivers?
Also, as with the other oracle post on the board at the moment, youll need to confirm whether youre connecting to a db using service name or sid as they require different connectiom strings.
Cheers,
Rich
Hi Richie,
oracle jar - ojdbc8.jar
Oracle is on version 18
Java is on 1.8.0_231
I have the ojdbc8.jar in the bin\ext folder path
and the ready api preference have the oracle thin configured
I have to use os authentication(intergrated security) to connect so i haven`t tried the jdbc connection step.
I would like to know how to connect in jdbc step with os authentication
and also want groovy script with os authentication as i would need to call stored proc from oracle with TVP(table values params)
And i want to connect using servicename
