On 30/06/2010, jz wrote:
> This is exactly what i did.
>
> I wanted to open all 10 connections before i do actual testing.
>
> For this i added Thread Group 1 with 10 threads and a dummy select
> statement.
As I already explained, unless you switch off pooling, there is no
guarantee that the s
This is exactly what i did.
I wanted to open all 10 connections before i do actual testing.
For this i added Thread Group 1 with 10 threads and a dummy select
statement. Now thread group 2 which has 100 threads, starts with a delay of
5 seconds. In those 5 seconds Thread Group 1 has opened all co
To give you more idea. Here are current settings:
Test Plan
-JDBC Connection Config
-Thread Group 1
--JDBC Request 1
-Thread Group 2
--JDBC Request 2
-View Result in Table
Here both JDBC Requests are using same connection pool.
Regards,
Jehanzeb Qayyum
On
On 30/06/2010, sebb wrote:
> On 30/06/2010, jz wrote:
>
> > Guys its a web applications. And connection pooling will be provided by
> > container. I wanted to test only the time taken by query/stored procedure,
> > not the time of spent in opening connection.
>
>
> So don't use connection poo
Results do not agree with your proposition.
For Thread group 1 average sample time was 2000 ms
and for thread group 2 average sample time 250 ms
Regards,
Jehanzeb Qayyum
On Wed, Jun 30, 2010 at 3:31 PM, sebb wrote:
> On 30/06/2010, jz wrote:
> > Guys its a web applications. And connectio
Vodafone
-Original Message-
From: sebb
Date: Wed, 30 Jun 2010 11:31:11
To: JMeter Users List
Reply-To: "JMeter Users List"
Subject: Re: JMetere JDBC Test Confusing Result
On 30/06/2010, jz wrote:
> Guys its a web applications. And connection pooling will be provided by
> con
On 30/06/2010, jz wrote:
> Guys its a web applications. And connection pooling will be provided by
> container. I wanted to test only the time taken by query/stored procedure,
> not the time of spent in opening connection.
So don't use connection pooling in JMeter.
If you think about it, there
Guys its a web applications. And connection pooling will be provided by
container. I wanted to test only the time taken by query/stored procedure,
not the time of spent in opening connection.
Regards,
Jehanzeb Qayyum
On Wed, Jun 30, 2010 at 3:19 PM, sebb wrote:
> On 30/06/2010, Sudip Kumar B
On 30/06/2010, Sudip Kumar Bhattacharya wrote:
> If it is a j2ee web application, app server wud be doing the connection
> pooling.
Yes, agreed.
> If it is a desktop app running from multiple terminals then connection
> pooling won't be there across multiple users.
Yes, agreed.
> I hope yo
ginal Message-
From: sebb
Date: Wed, 30 Jun 2010 11:01:58
To: JMeter Users List
Reply-To: "JMeter Users List"
Subject: Re: JMetere JDBC Test Confusing Result
The target application is irrelevant.
What is important is what use-case you are trying to simulate.
If you are trying to e
nection
> > objects
> > > > and getting the connection to the db?
> > > > You can take the connection creation overhead by running your query in
> > a
> > > > loop of say hundred iteration.
> > > > Then if you average out by taking
if you average out by taking total time /total iterations, you
> may get
> > > the expected output.
> > > Sent on my BlackBerry® from Vodafone
> > >
> > > -Original Message-
> > > From: jz
> > > Date: Wed, 30 Jun 2010 10:42:03
> &g
tions, you may get
> > the expected output.
> > Sent on my BlackBerry® from Vodafone
> >
> > -Original Message-
> > From: jz
> > Date: Wed, 30 Jun 2010 10:42:03
> > To:
> > Reply-To: "JMeter Users List"
> > Subject: JMet
-Original Message-
> From: jz
> Date: Wed, 30 Jun 2010 10:42:03
> To:
> Reply-To: "JMeter Users List"
> Subject: JMetere JDBC Test Confusing Result
>
> Hi,
>
> I am running JMeter JDBC test. I am getting confusing results which vary
> with no. of
expected output.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: jz
Date: Wed, 30 Jun 2010 10:42:03
To:
Reply-To: "JMeter Users List"
Subject: JMetere JDBC Test Confusing Result
Hi,
I am running JMeter JDBC test. I am getting confusing results which vary
w
Hi,
I am running JMeter JDBC test. I am getting confusing results which vary
with no. of threads and no. of connection in pool
Query: select sysdate from dual
Test Case 1:
no. of threads: 10
no. of connetcions: 1
Avg Sample Time is 5 ms
Now i increase no. of connections to 2, thinking that it
g that the above call command should be closer right?
Thanks
> Date: Fri, 5 Jun 2009 18:32:46 +0100
> Subject: Re: Stored Procedure failure on JDBC test run
> From: seb...@gmail.com
> To: jmeter-user@jakarta.apache.org
>
> On 05/06/2009, AL BUNDY wrote:
> >
> >
orrect format or tell me
> what to correct so I know the right syntax?
AIUI JDBC uses the same syntax for all databases.
As per the JMeter docs, this is either:
{CALL procedure(param)}
or
CALL procedure(param)
> Thanks again
>
>
> > Date: Thu, 4 Jun 2009 23:14:21 +0100
&g
09 23:14:21 +0100
> Subject: Re: Stored Procedure failure on JDBC test run
> From: seb...@gmail.com
> To: jmeter-user@jakarta.apache.org
>
> On 04/06/2009, AL BUNDY wrote:
> >
> > Hi,
> > Thanks for your response. I'm afraid that link points to the way to crea
On 04/06/2009, AL BUNDY wrote:
>
> Hi,
> Thanks for your response. I'm afraid that link points to the way to create a
> simple SQL query. I already did that and now need to do the stored procedure
> that triggers multiple SQL queries.
>
> I guess my issue is how to do the right SYNTAX with Jm
Hi,
Thanks for your response. I'm afraid that link points to the way to create a
simple SQL query. I already did that and now need to do the stored procedure
that triggers multiple SQL queries.
I guess my issue is how to do the right SYNTAX with Jmeter. I understand the
concept and logic, just
On 04/06/2009, AL BUNDY wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hello,
> I am attempting to run an existing stored procedure on Jmeter
> passing a variable to it. I keep getting diff exception errors on the
> result tree using these 3 popular commands.
>
>
> 1- BEGIN
> GET_USER_BY_EMAIL_SP();
Hello,
I am attempting to run an existing stored procedure on Jmeter
passing a variable to it. I keep getting diff exception errors on the
result tree using these 3 popular commands.
1- BEGIN
GET_USER_BY_EMAIL_SP(); end; Throws SQLException: ORA-06550: line 1,
column 7: PLS-00201:
On 16/09/2008, Sean Tiley <[EMAIL PROTECTED]> wrote:
> Sorry, the attachment did not work.
>
> I started over and now it works, seems I had my Sampler at the wrong
> spot in the test plan
>
> Boy, I feel dumb!
>
> Apologies :-)
Thanks for letting us know the problem has been resolved.
> Sean
Sorry, the attachment did not work.
I started over and now it works, seems I had my Sampler at the wrong
spot in the test plan
Boy, I feel dumb!
Apologies :-)
Sean
On Tue, Sep 16, 2008 at 3:15 PM, Sean Tiley <[EMAIL PROTECTED]> wrote:
> I do appreciate all the input.
>
> I added listeners to a
If none of the tabs have any information, then the listener is not
seeing any completed samples.
Either there are none, or the Listener is in the wrong place to see them.
On 16/09/2008, Sean Tiley <[EMAIL PROTECTED]> wrote:
> Nothing at all, just blank
> 'Sampler result' tab has nothing on it
>
Nothing at all, just blank
'Sampler result' tab has nothing on it
Sean
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
All looks OK - what does the Tree View Listener show?
On 16/09/2008, Sean Tiley <[EMAIL PROTECTED]> wrote:
> The test is completing, here is my log file from a run.
>
> It looks like, from the last line that the test completes.
>
>
>
> 2008/09/16 14:15:08 INFO - jmeter.util.JMeterUtils: Setting
On 16/09/2008, Jose Castro <[EMAIL PROTECTED]> wrote:
> I use a regular expression to retrieve the values
That will only work if the response has been received...
> regex
> inputVar
> (.*),(.*)
> $1$$2$
> -1
> 0,0
>
>
> my sql
> select col1,col2 from table
>
>
> after that use a beanshel
The test is completing, here is my log file from a run.
It looks like, from the last line that the test completes.
2008/09/16 14:15:08 INFO - jmeter.util.JMeterUtils: Setting Locale to en_US
2008/09/16 14:15:08 INFO - jmeter.JMeter: Loading user properties
from: C:\Sean\java\jakarta-jmeter-2.
I use a regular expression to retrieve the values
regex
inputVar
(.*),(.*)
$1$$2$
-1
0,0
my sql
select col1,col2 from table
after that use a beanshell with logn to display results
I have to say that selecting the right variable was a pain for me.
For example to display my data I have to logn t
On 16/09/2008, Sean Tiley <[EMAIL PROTECTED]> wrote:
> Hello, and thanks for the responses
>
> Yes, the jar file is in the right spot because if i remove it I see
> error messages in the log.
>
> I changed my query to a simple select but I do not know how to tell if
> it worked. I have a 'View
Hello, and thanks for the responses
Yes, the jar file is in the right spot because if i remove it I see
error messages in the log.
I changed my query to a simple select but I do not know how to tell if
it worked. I have a 'View Results Tree' listener but nothing shows up
at all.
---
Did you install the ojdbc14.jar on the lib directory??
On Tue, Sep 16, 2008 at 12:11 PM, Sean Tiley <[EMAIL PROTECTED]> wrote:
> Hello,
> I am trying to create a test that will connect to an oracle DB via
> jdbc and run a number of update and delete statements.
>
> I have created everything accord
On 16/09/2008, Sean Tiley <[EMAIL PROTECTED]> wrote:
> Hello,
> I am trying to create a test that will connect to an oracle DB via
> jdbc and run a number of update and delete statements.
>
> I have created everything according to the instructions
> (http://jakarta.apache.org/jmeter/usermanual/
Hello,
I am trying to create a test that will connect to an oracle DB via
jdbc and run a number of update and delete statements.
I have created everything according to the instructions
(http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html).
There are entries in the JMeter log statin
rrect. The Oracle
documentation should tell you what to use.
S.
On 26/02/06, Abdul Azeem Khan <[EMAIL PROTECTED]> wrote:
> AOA,
> i am using JMeter for buliuding a JDBC test plan.i am using ORACLE 9i as
> database.i have downloaded postgresql.jar and also added it to class path.in
&
AOA,
i am using JMeter for buliuding a JDBC test plan.i am using ORACLE 9i as
database.i have downloaded postgresql.jar and also added it to class path.in my
test first i create a thread grp then a JDBC configuration elemnt and then JDBC
request and then of course a listner.but still i am
Thanks, I added a Response Listener and Listener Assertion under my JDBC
Request to debug the JDBC connection problem
Craig
-Original Message-
From: Jacqui Guerrero [mailto:[EMAIL PROTECTED]
Sent: Friday, May 07, 2004 5:04 PM
To: JMeter Users List
Subject: RE: JDBC Test problem
You
PROTECTED]
Subject: JDBC Test problem
Help Please, I'm new to jmeter, and I'm trying to use it to simulate
load on
a database via JDBC.
I followed the steps in the manual for Building a database test plan.
When I
run the test plan the green light is displayed graph results are
displayed,
Help Please, I'm new to jmeter, and I'm trying to use it to simulate load on
a database via JDBC.
I followed the steps in the manual for Building a database test plan. When I
run the test plan the green light is displayed graph results are displayed,
but I don't see any database connections. I sav
Hi Michal,
Thanks a lot for the pointers !!!
Regards,
Hari.
--- Michal Kostrzewa <[EMAIL PROTECTED]>
wrote: > Hello Hari,
>
> > I am a new user of Jmeter. I was testing the JDBC
> hits
> > using Jmeter using SQL's like
> >
> > select * from table_name
> >
> > Can I make it configurable.. somet
Hello Hari,
> I am a new user of Jmeter. I was testing the JDBC hits
> using Jmeter using SQL's like
>
> select * from table_name
>
> Can I make it configurable.. something like
>
> select * from table_name where value = ?
>
> and the values should come from a text file. Is it
> possible with Jmet
Hi,
I am a new user of Jmeter. I was testing the JDBC hits
using Jmeter using SQL's like
select * from table_name
Can I make it configurable.. something like
select * from table_name where value = ?
and the values should come from a text file. Is it
possible with Jmeter ?
Thanks and Regards,
I'm using Oracle 8.1.7 and I'm trying use the following settings in the JDBC
test plan , but I don't obtain positive results.
JDBC URL: jdbc:oracle:thin:@192.168.0.6:1522:famisana
Driver class: oracle.jdbc.driver.OracleDriver
what settings should I use for the Oracle JDBC co
, March 18, 2003 5:16 AM
To: JMeter Users List
Subject: Re: Validating results from JDBC test
I don't use JDBC with JMeter much, but I tried it and it worked fine for me.
I'm
using the latest code in CVS, so maybe something's been fixed since 1.8.1?
I was
able to see the results in t
.
-Mike
On 17 Mar 2003 at 13:49, Tim Wilkinson wrote:
> This question was asked about a month ago, but I never saw an answer to
> this, so I'll ask again. Is there a way to validate the results from a JDBC
> test? Looking at the user manual, it seems to say that an assertion can be
This question was asked about a month ago, but I never saw an answer to
this, so I'll ask again. Is there a way to validate the results from a JDBC
test? Looking at the user manual, it seems to say that an assertion can be
used to verify the results from a query, but when I have tried this
Hi all!
Is there an example of JDBC test plan somewhere?? I tried to look it up in
the jmeter user´s manual, but it says that it is still going to be
written...
I would be very grateful if anybody told me that, or sent me an example!
Mauricio.
-
From: Stover, Michael [mailto:[EMAIL PROTECTED]]
Sent: Freitag, 22. März 2002 14:34
To: 'JMeter Users List'; Baudier, Mathieu
Subject: RE: Problems with JDBC test - Release connection
This is a real bug, unfortunately. You might try the following to fix it:
go into the file JDBC
Hi,
I'm trying to use JMeter in order to test our database (SAP-DB).
1. I have built a simple test plan : connection to the DB and simple SELECT
statement. (see attached file "SAPDB Ess 1-noPasswd.jmx")
2. I start JMeter :
...
C:\Program Files\JMeter\bin>set LOCALCLASSPATH=
C:\Program Files\
51 matches
Mail list logo