Mailing-List: contact jmeter-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "JMeter Users List" <jmeter-user@jakarta.apache.org>
Received-SPF: pass (nike.apache.org: domain of gsudheer.08@gmail.com
 designates 209.85.210.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=duzG9padNQGVpHAaNotOdI7mmB9u/sFiGQgFzarhOHesWycZOTbPT7K9Sk/Ywlpyaa
         AAHt7Xl+2v2xGJidoO8NHGeSZQZGbVU5XQxbiKXxE48cU+3LuYXFzlTesAnL3mC9GtGw
         E8MAmaHP2wNtS5626WOysvyejGaBvSS/k3oLY=
MIME-Version: 1.0
In-Reply-To: 
 <9CD370EF3E98D840BDC9FC7EEAB2A3661A885C06@HDLMBX001.corp.satyam.ad>
References: 
 <9CD370EF3E98D840BDC9FC7EEAB2A3661A885C06@HDLMBX001.corp.satyam.ad>
Date: Thu, 1 Jul 2010 16:30:56 +0530
Message-ID: <AANLkTimtX5WLzAboDMO-m8-BnPVSodLgbpHisj1CGNvB@mail.gmail.com>
Subject: Re: geting Error in JDBC Connection Configuration
From: sudheer reddy <gsudheer.08@gmail.com>
To: JMeter Users List <jmeter-user@jakarta.apache.org>
Content-Type: multipart/alternative; boundary=00163646d6ae873fc1048a516258

--00163646d6ae873fc1048a516258
Content-Type: text/plain; charset=ISO-8859-1

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.
>

--00163646d6ae873fc1048a516258--