You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Sirish_Chandra <Si...@mahindrasatyam.com> on 2010/07/01 12:35:43 UTC
RE: geting Error in JDBC Connection Configuration
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:Sirish_Chandra@mahindrasatyam.com]
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: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: geting Error in JDBC Connection Configuration
Posted by Felix Frank <ff...@mpexnet.de>.
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:Sirish_Chandra@mahindrasatyam.com]
> 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: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
--
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: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org