Hope you are doing great!!!
I have created a Jenkins freestyle project and invoking the DevTest scripts via Invoke Ant build step, it has a JDBC step (Oracle DB)
In ITR execution mode, there is no error encountered what so ever, however when the same test is executed via Jenkins following error is thrown
java.sql.SQLException: Connections could not be acquired from the underlying database!Any help would be highly appreciated.Thanks in advance.
Where is your Jenkins running? On the same machine you are running the ITR from? If not make sure you have access to the port the Oracle database is running on from Jenkins.
Thanks for your quick response.
Jenkins is installed on the same machine in which DevTest is present.
Thanks in advance.
Thanks for sharing the details. I have noticed similar issue before, when I run test through Jenkins. Can you please try by uncheck the check boxes "Use Connection poll" and "keep connections open" options are in JDBC exectuion step, so that when you run through Jenkins, it will establish a new connection and connect to database.
Thanks & Regards
Sorry for the delay in response.
I tried the above suggestion, however no luck
Note:-Same error is thrown "java.sql.SQLException: Connections could not be acquired from the underlying database! ", when the Test Cases are staged locally or run against the Registry.
Any help would be much appreciated.