Cannot establish JDBC connection

0
votes

I am getting below error while running the jmeter command in non-gui mode from jenkins.

1525245708238,63941,JDBC Request,null 0,java.sql.SQLException: Cannot create PoolableConnectionFactory (IO Error: The Network Adapter could not establish the connection),SQL 1-1,text,false,,106,0,1,1,0,0,63940 1525245772189,63135,JDBC Request,null 0,java.sql.SQLException: Cannot create PoolableConnectionFactory (IO Error: The Network Adapter could not establish the connection),SQL 1-1,text,false,,106,0,1,1,0,0,63135

1
jenkinsjmeter

1 Answers

0
votes

Most probably the host where Jenkins (or its build agent) lives cannot establish connection to Oracle host so you will need to inspect/amend Oracle Network Configuration or your operating system firewall settings to allow connections from Jenkins master or build agent.

You can use Oracle Instant Client or SQL Developer or similar in order to verify connectivity, given you will be able to establish connection to the database from Jenkins host or build agent - JMeter should also be able to connect and execute queries (assuming you have appropriate Oracle JDBC driver in JMeter Classpath)