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/06/30 08:37:32 UTC
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.
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
RE: geting Error in JDBC Connection Configuration
Posted by Sirish_Chandra <Si...@mahindrasatyam.com>.
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 Sirish_Chandra <Si...@mahindrasatyam.com>.
Thanks a lot.
The problem got solved.
1. Created a User DSN (odbc for Oracle) in the system after installing Oracle Client.
2. Configure that according to the requirement.
3. Give the Data base URL: jdbc:oracle:thin:@IPaddress:portnumber:sid
It may help to those who are facing same kind of problem.
Regards
Sirish
-----Original Message-----
From: Sudip Kumar Bhattacharya [mailto:skb.subscriptions@gmail.com]
Sent: Thursday, July 01, 2010 6:39 PM
To: JMeter Users List
Subject: Re: geting Error in JDBC Connection Configuration
Try using the same driver from a java application.
Sent on my BlackBerry(r) from Vodafone
-----Original Message-----
From: Sirish_Chandra <Si...@mahindrasatyam.com>
Date: Thu, 1 Jul 2010 18:35:55
To: JMeter Users List<jm...@jakarta.apache.org>
Reply-To: "JMeter Users List" <jm...@jakarta.apache.org>
Subject: RE: geting Error in JDBC Connection Configuration
Thank you very much
I am connecting through a VPN connection. My jmeter configuration is able to capture the general recording which I am doing through VPN.
I have tried also with the solution which you given, but no luck. any other thing regarding the solution or I am not using the correct driver for connecting to the database?
Regards
Sirish
-----Original Message-----
From: Sudip Kumar Bhattacharya [mailto:skb.subscriptions@gmail.com]
Sent: Thursday, July 01, 2010 5:09 PM
To: JMeter Users List
Subject: Re: geting Error in JDBC Connection Configuration
Are you by any chance going thru a proxy which is not configured for jmeter?
Sent on my BlackBerry(r) from Vodafone
-----Original Message-----
From: sudheer reddy <gs...@gmail.com>
Date: Thu, 1 Jul 2010 16:30:56
To: JMeter Users List<jm...@jakarta.apache.org>
Reply-To: "JMeter Users List" <jm...@jakarta.apache.org>
Subject: Re: geting Error in JDBC Connection Configuration
Hi Sirish
In the database URL try with jdbc:oracle:thin://hostname:portnumber:dbname
rgds
Sudheer
On Wed, Jun 30, 2010 at 12:07 PM, Sirish_Chandra <
Sirish_Chandra@mahindrasatyam.com> wrote:
> 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
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 Sudip Kumar Bhattacharya <sk...@gmail.com>.
Try using the same driver from a java application.
Sent on my BlackBerry® from Vodafone
-----Original Message-----
From: Sirish_Chandra <Si...@mahindrasatyam.com>
Date: Thu, 1 Jul 2010 18:35:55
To: JMeter Users List<jm...@jakarta.apache.org>
Reply-To: "JMeter Users List" <jm...@jakarta.apache.org>
Subject: RE: geting Error in JDBC Connection Configuration
Thank you very much
I am connecting through a VPN connection. My jmeter configuration is able to capture the general recording which I am doing through VPN.
I have tried also with the solution which you given, but no luck. any other thing regarding the solution or I am not using the correct driver for connecting to the database?
Regards
Sirish
-----Original Message-----
From: Sudip Kumar Bhattacharya [mailto:skb.subscriptions@gmail.com]
Sent: Thursday, July 01, 2010 5:09 PM
To: JMeter Users List
Subject: Re: geting Error in JDBC Connection Configuration
Are you by any chance going thru a proxy which is not configured for jmeter?
Sent on my BlackBerry(r) from Vodafone
-----Original Message-----
From: sudheer reddy <gs...@gmail.com>
Date: Thu, 1 Jul 2010 16:30:56
To: JMeter Users List<jm...@jakarta.apache.org>
Reply-To: "JMeter Users List" <jm...@jakarta.apache.org>
Subject: Re: geting Error in JDBC Connection Configuration
Hi Sirish
In the database URL try with jdbc:oracle:thin://hostname:portnumber:dbname
rgds
Sudheer
On Wed, Jun 30, 2010 at 12:07 PM, Sirish_Chandra <
Sirish_Chandra@mahindrasatyam.com> wrote:
> 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 Sirish_Chandra <Si...@mahindrasatyam.com>.
Thank you very much
I am connecting through a VPN connection. My jmeter configuration is able to capture the general recording which I am doing through VPN.
I have tried also with the solution which you given, but no luck. any other thing regarding the solution or I am not using the correct driver for connecting to the database?
Regards
Sirish
-----Original Message-----
From: Sudip Kumar Bhattacharya [mailto:skb.subscriptions@gmail.com]
Sent: Thursday, July 01, 2010 5:09 PM
To: JMeter Users List
Subject: Re: geting Error in JDBC Connection Configuration
Are you by any chance going thru a proxy which is not configured for jmeter?
Sent on my BlackBerry(r) from Vodafone
-----Original Message-----
From: sudheer reddy <gs...@gmail.com>
Date: Thu, 1 Jul 2010 16:30:56
To: JMeter Users List<jm...@jakarta.apache.org>
Reply-To: "JMeter Users List" <jm...@jakarta.apache.org>
Subject: Re: geting Error in JDBC Connection Configuration
Hi Sirish
In the database URL try with jdbc:oracle:thin://hostname:portnumber:dbname
rgds
Sudheer
On Wed, Jun 30, 2010 at 12:07 PM, Sirish_Chandra <
Sirish_Chandra@mahindrasatyam.com> wrote:
> 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 Sudip Kumar Bhattacharya <sk...@gmail.com>.
Are you by any chance going thru a proxy which is not configured for jmeter?
Sent on my BlackBerry® from Vodafone
-----Original Message-----
From: sudheer reddy <gs...@gmail.com>
Date: Thu, 1 Jul 2010 16:30:56
To: JMeter Users List<jm...@jakarta.apache.org>
Reply-To: "JMeter Users List" <jm...@jakarta.apache.org>
Subject: Re: geting Error in JDBC Connection Configuration
Hi Sirish
In the database URL try with jdbc:oracle:thin://hostname:portnumber:dbname
rgds
Sudheer
On Wed, Jun 30, 2010 at 12:07 PM, Sirish_Chandra <
Sirish_Chandra@mahindrasatyam.com> wrote:
> 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.
>
Re: geting Error in JDBC Connection Configuration
Posted by sudheer reddy <gs...@gmail.com>.
Hi Sirish
In the database URL try with jdbc:oracle:thin://hostname:portnumber:dbname
rgds
Sudheer
On Wed, Jun 30, 2010 at 12:07 PM, Sirish_Chandra <
Sirish_Chandra@mahindrasatyam.com> wrote:
> 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.
>