jmeter « oracle « Java Database Q&A





1. Calling Stored Procedure on Oracle 10    jmeter.512774.n5.nabble.com

I am trying to call a Stored Procedure (SP) from a JMeter JDBC request to an Oracle 10 database. The SP has the following form: DECLARE var1 VARCHAR(256); var2 VARCHAR(256); ...

2. Connection to Oracle database with JDBC    jmeter.512774.n5.nabble.com

Hi, I try to connect to an Oracle database. Downloaded classes12.zip, copied it to the lib folder and renamed it to classes12.jar. Started Jmeter (version 2.3.1) and added JDBC configuration configuration to my testplan with the following settings: JDBC Driver Class : oracle.jdbc.driver.OracleDriver. Run my testplan and I see in the log the following warning: 2008/01/14 11:20:31 WARN - ...

3. Feedback testing Oracle JD Edwards EnterpriseOne web application    jmeter.512774.n5.nabble.com

Hello, I'm working on a performance project on Oracle JD Edwards EntrepriseOne (web application part). I want use Jmeter (2.5.1) to make some performance test. Have you got some feedback about this ? It seems that the web application contains a lot of Ajax call. During my run test, I am having difficulties to retrieve some variables which are then sent ...

4. JDBC calls oracle -nothing happens    jmeter.512774.n5.nabble.com

Hi, First of all, thanks for updating the documentation at such short notice. I am using the edbc driver to connect to Ingres. Also, I was trying a sample test to connect to an Oracle db like shown in the example. I have carried the instructions to the letter, but the queries that I fire do not reach the db (I ...

5. JDBC Connection to Oracle through Proxy    jmeter.512774.n5.nabble.com

Dear Reader, Hi, I want to test a JDBC connection to Oracle through proxy. I tested it directly (without a proxy) successfully but i do not know how can i test it through a proxy .. ??! any references or docs? It will be really appreciated if someone can help me. Thanks in advanced Regards, aLi nAvAb

6. oracle database connection    jmeter.512774.n5.nabble.com

aoa, can anyone help me by telling how to setup an oracle database connection with JMeter for db testing. thanx azeem --------------------------------- Yahoo! Mail Bring photos to life! New PhotoMail makes sharing a breeze. ...

7. Oracle Database Testing    jmeter.512774.n5.nabble.com

Hi, I have searched the forum for answers relating to my problem and applied those solutions to my problem but still dont seem to get anywhere. Can anyone please help me by telling how to setup an oracle database connection with JMeter for db testing? I am very new to JMeter, and so dont know the correct way to do it. ...

8. Oracle DB Connection    jmeter.512774.n5.nabble.com

hello, i checked archives but havent found how to setup an oracle db connection or from where to find oracle driver..please help me beacuse i need to know this urgently. help in this regard will greatly be appriciated thanx Azeem ...

9. Oracle Exception on the JDBC Driver    jmeter.512774.n5.nabble.com

Hi, JDBC Exception in aggregate report logs.





10. Oracle JDBC Connection Problem    jmeter.512774.n5.nabble.com

> Hello, > > I'm using JMeter 2.3.2 and the Oracle JDBC ojdbc14_10.2.0.4.0.jar file. I'm trying > to connect to a database that is using a service name, not a SID. I've set up > my JDBC Connection Configuration/Database URL to be in the format: > > jdbc:oracle:thin:@:: > > I realize this is not a JMeter issue ...

11. Oracle JDBC Connection - Response was NULL    jmeter.512774.n5.nabble.com

Dear All , Greetings , We are executing a test plan with JDBC Connection Configuration . We are using Oracle Database and Java Application . I have used the Database URL in JDBC Connection Configuration panel with following all possible syntax i. jdbc:oracle:thin:user/pass@//host:port/service OR ii. jdbc:oracle:thin:@//host:port/service OR iii. jdbc:oracle:thin:@(description=(address=(host={mc-name})(protocol=tcp)(port={port-no}))(connect_data=(sid={sid}))) and I have placed ...

12. oracle jdbc connection    jmeter.512774.n5.nabble.com

13. Oracle JDBC Connection    jmeter.512774.n5.nabble.com

Hi, I would like to use JMeter in our company for webinterface testing in connection with database. At the moment I try to get an small proof of concept for database testing, but it doesn't work. My steps I have done so far: 1) created an oracle jdbc connection - jdbc:oracle:thin:@localhost:1521:dbname - oracle.jdbc.driver.OracleDriver 2) created select statement with a ...

14. Oracle protocol support...    jmeter.512774.n5.nabble.com

15. Oracle Single Sign-On redirect failure    jmeter.512774.n5.nabble.com

Hi team, I am trying to replay against an Oracle dashboard application (recording with HTTP proxy works fine) and it fails on an implicit re-direct. This single sign-on redirect gets the user's credentials from [*somewhere*] and authenticates the user. When I play back the initial page request, a redirect happens to the authentication page, which comes back with a 401 Unauthorised ...

16. Oracle Stored Procedure output parameters    jmeter.512774.n5.nabble.com

Hi, I am having difficulty calling an Oracle stored procedure to populate User Defined Variables from the output parameters The configuration is Callable Statement: call messaging_intf.get_message (?,'Y',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameter Values: ${STREAM},${SESSION_CTX},${MESSAGE_FOUND},${TRANSACTION_ID},${APPLICATION},${CUSTOMER},${CORRELATION_ID},${MESSAGE_ID},${USER},${LOB},${TIMESTAMP},${MESSAGE_PAYLOAD},${DEPENDENCY_CHECK_KEY},${SEQUENCE_NUMBER},${MESSAGE_KEY},${SESSION_CTX} Parameter Types: VARCHAR,VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT INTEGER,OUT INTEGER,OUT VARCHAR Variable Names: I understand this field is only for select type queries and have ...





17. Problems with Oracle & JDBC query    jmeter.512774.n5.nabble.com

Hi guys, I've searched the forums for a similar problem - and I havent found any like this one. When I'm running a basic "select count(*)...." - nothing seems to happen in JMeter - and I've no errors etc in the logs. I added both classes12.jar & ojdbc14.jar to my %JMETER%/lib directory. I've ...

18. Re: Re:JDBC calls oracle -nothing happens    jmeter.512774.n5.nabble.com

Hehehee, Got it working. I just pulled the JDBC request and placed it AFTER the jdbc Connection Configuration instead of as its child. And now it is working fine. Thanks a lot for your help. Best Regards, Sayali. MASTEK "Making a valuable difference" Mastek in NASSCOM's 'India Top 20' Software Service Exporters List. In the US, we're called MAJESCOMASTEK ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Opinions ...

19. Recording of funtionality on Oracle forms.. can it be possible?    jmeter.512774.n5.nabble.com

Hi. i am recording an oracle application, and it has many FORMS pages, how can i record the funtionality on those forms, i already did this with http proxy server but it seems Jmeter only records the forms bt not the funtionality on the forms it self ? please let me know where is the prob and sugesstion too. Thanks. -Gp ...

20. Strange Oracle database problem    jmeter.512774.n5.nabble.com

Hi all, I have my database settings configured and a select statement is working fine. select * from ipmgr.client_ip where ip_address = '80.60.92.102' The next statement is an update. UPDATE ipmgr.client_ip SET status = '1' WHERE ip_address = '80.60.92.102' And this is giving me some problems. No result in the result tree and the following error message in the jmeter.log. The ...

21. Testing Oracle ERP Suite    jmeter.512774.n5.nabble.com

Hi Viswanathan The Oracle E-Business Suite delivers Oracle's market-leading database and application server products in a single, consolidated technology stack. Featuring tight integration with Oracle's infrastructure management tools such as Oracle Enterprise Manager 10g Grid Control. I have to do performance testing of Oracle suite. I am new to this area. Please help Purvi ...