Make sure that 1. IP / Port are actually correct 2. the Jmeter machine can actually connect to said IP/Port combination
Can Jmeter make other (say, HTTP) connections? HTH Felix On 07/01/2010 12:35 PM, Sirish_Chandra wrote: > I am getting the Error Like this: > > Response message: java.sql.SQLException: Io exception: The Network Adapter > could not establish the connection.. > > Bellow I have given the details. I was trying to solve it, I did some > googling but not getting where to hit. > > Can you please give me some suggestion, those who may be come across this > type of problem, so that I can proceed further. > > Any help is appreciable. > > Thanks & regards, > Sirish > > -----Original Message----- > From: Sirish_Chandra [mailto:[email protected]] > Sent: Wednesday, June 30, 2010 12:08 PM > To: JMeter Users List > Subject: geting Error in JDBC Connection Configuration > > Hi > > My data base is Orcle 10g installed in a Linux system(redhat 32 bit OS). > I am trying to connect to my data base from "JDBC Connection Configuration" > config element. The configuration what I have done is mentioned bellow: > > Name: JDBC Connection Configuration > Variable Name: my db pool > Max number of connections: 10 > Pool time out: 10000 > Ideal clean up interval: 60000 > Auto commit: True > Keep alive : True > Max connection age: 5000 > Validation query: Select 1 > Data base URL: jdbc:oracle:thin://IP address:port number > JDBC Driver Class : oracle.jdbc.driver.OracleDriver > Username: test > Password: test > > I am using ojdbc14.jar as my database is oracle and I have kept it in the > lib folder of the jmeter. > > I have added the JDBC sampler and the configuration is like this: > > Name: JDBC Request > Variable name: my db pool > Query type: Select statement > The query is select * FROM OB_REFNUM WHERE order_base_gid = > 'P2.21738'; > > The above query is running fine and tested independently. > > Now I am getting the Error Like this: > > Response message: java.sql.SQLException: Io exception: The Network Adapter > could not establish the connection > > Need some help... > > > Regards > Sirish > > > > Mahindra Satyam is powering IT for the 2010 FIFA World Cup(TM). > To learn more, visit: www.mahindrasatyam.com/fifa/index.asp > > ________________________________ > DISCLAIMER: > This email (including any attachments) is intended for the sole use of the > intended recipient/s and may contain material that is CONFIDENTIAL AND > PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or > distribution or forwarding of any or all of the contents in this message is > STRICTLY PROHIBITED. If you are not the intended recipient, please contact > the sender by email and delete all copies; your cooperation in this regard is > appreciated. > > > Mahindra Satyam is powering IT for the 2010 FIFA World Cup(TM). > To learn more, visit: www.mahindrasatyam.com/fifa/index.asp > > DISCLAIMER: > This email (including any attachments) is intended for the sole use of the > intended recipient/s and may contain material that is CONFIDENTIAL AND > PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or > distribution or forwarding of any or all of the contents in this message is > STRICTLY PROHIBITED. If you are not the intended recipient, please contact > the sender by email and delete all copies; your cooperation in this regard is > appreciated. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > -- MPeX.net GmbH / Werner-Voß-Damm 62 / D-12101 Berlin / Germany MPeXnetworks / www.mpexnetworks.de Tel: ++49-30-78097 180 / Fax: ++49-30-78097 181 Sitz, Registergericht: Berlin, Amtsgericht Charlottenburg, HRB 76688 Geschäftsführer: Lars Bräuer, Gregor Lawatscheck --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
