jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sirish_Chandra <Sirish_Chan...@mahindrasatyam.com>
Subject RE: geting Error in JDBC Connection Configuration
Date Fri, 02 Jul 2010 13:33:54 GMT
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 <Sirish_Chandra@mahindrasatyam.com>
Date: Thu, 1 Jul 2010 18:35:55
To: JMeter Users List<jmeter-user@jakarta.apache.org>
Reply-To: "JMeter Users List" <jmeter-user@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 <gsudheer.08@gmail.com>
Date: Thu, 1 Jul 2010 16:30:56
To: JMeter Users List<jmeter-user@jakarta.apache.org>
Reply-To: "JMeter Users List" <jmeter-user@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


Mime
View raw message