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:[email protected]] 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 <[email protected]> Date: Thu, 1 Jul 2010 18:35:55 To: JMeter Users List<[email protected]> Reply-To: "JMeter Users List" <[email protected]> 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:[email protected]] 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 <[email protected]> Date: Thu, 1 Jul 2010 16:30:56 To: JMeter Users List<[email protected]> Reply-To: "JMeter Users List" <[email protected]> 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 < [email protected]> 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: [email protected] For additional commands, e-mail: [email protected] 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: [email protected] For additional commands, e-mail: [email protected]
