jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sudheer reddy <gsudheer...@gmail.com>
Subject Re: geting Error in JDBC Connection Configuration
Date Thu, 01 Jul 2010 11:00:56 GMT
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.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message