You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Ro...@gro-scotland.gsi.gov.uk on 2006/06/06 15:54:58 UTC
Database procedures
*******************************************************************************************************************************************************
This email and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed.
*******************************************************************************************************************************************************
I am attempting to run an Ingres database procedure and have obtained a
version of JMeter 2.1.1 with the fix for bug 38682. The database
procedure runs ok through a java program but I have had no success with
various formats in Jmeter. Here are a sample of my input and responses.
The sql on which the database procedure was written works fine.
Ron
execute(dbp_a("BROWN","WALTER","1871"))
execute dbp_a("BROWN","WALTER","1871")
HTTP response message: ca.gcf.util.SqlEx: line 1, Syntax error on
'execute'. The correct syntax is:
OPEN CURSORID CURSOR FOR fullselect
[FOR [DIRECT | DEFERRED] UPDATE OF column {, ... }]
[FOR READONLY]
call dbp_a("BROWN","WALTER","1871")
HTTP response message: ca.gcf.util.SqlEx: line 1, The dynamically
defined statement 'call' not found.
Perhaps a PREPARE or DESCRIBE wasn't successful.
The original of this email was scanned for viruses by Government Secure Intranet (GSi) virus scanning service supplied exclusively by Cable & Wireless in partnership with MessageLabs.
On leaving the GSI this email was certified virus free.
The MessageLabs Anti Virus Service is the first managed service to achieve the CSIA Claims Tested Mark (CCTM Certificate Number 2006/04/0007), the UK Government quality mark initiative for information security products and services. For more information about this please visit www.cctmark.gov.uk
Result in Jmeter vs Result in Jboss : why is there such a difference?
Posted by Gaël LHEZ <gl...@glowria.fr>.
Hi,
Now that I configured my test, tested them, and installed the whole test
platform, I begin to interest my self to the results. 100 users will connect
to a server, in 200 secons (ramp up)
Here is the configuration, note that all is in local network (Ethernet,
100MBits/s)
Win2k Terminal + SQLServer
|
Win2k Terminal + Jboss (jdk1.5_06)
|
RedHat + Apache 2.0.55
When I run the test, I hit the apache server, which handle what he can, and
let jk_mod handle the rest, then jBoss call the database if needed, etc.
Here a comparaison : (see below)
Result in red are strange : how could that sample be quicker than the thing
that create the sample? Since the difference is small, I think it simply due
to a redirect (which take less time)
Result in yellow are worse : I can understand that due to network there is
maximum 500ms seconds between the two result, but 2 seconds...
I also had this problems with the same conf, but Apache running on the same
machine than jMeter (on WinXp pro)
I'm looking for a good explanation of that?
(currently, I'm thinking that is due to thread issue : one thread is waiting
to get access to CPU's registry, and since System.getTimeMillis() is used to
determine start of time, we have the total lifespan of thread, not it alive
time)
Jboss Jmeter Difference
[prospect 2] /glow2/viewIndex.do 32 16 -16
[prospect 2] /viewTitleDetails.do?titreId=108580 0 15 15
[prospect 3] /glow2/viewIndex.do 16 31 15
[prospect 4] /glow2/viewIndex.do 16 15 -1
[prospect 2] /viewTitleDetails.do?titreId=111907 109 125 16
[prospect 5] /glow2/viewIndex.do 16 16 0
[prospect 1] /glow2/viewIndex.do 16 16 0
[prospect 5] /viewTitleDetails.do?titreId=108037 63 63 0
[prospect 1] /viewTitleDetails.do?titreId=107902 0 31 31
[prospect 6] /glow2/viewIndex.do 16 16 0
[prospect 4] /viewTitleDetails.do?titreId=12839 125 485 360
[prospect 3] /viewTitleDetails.do?titreId=20364 15 109 94
[prospect 7] /glow2/viewIndex.do 1047 1063 16
[prospect 5] /viewTitleDetails.do?titreId=102577 438 626 188
[prospect 5] /viewTitleDetails.do?titreId=11119 203 219 16
[prospect 14] /viewTitleDetails.do?titreId=21000 109 125 16
[prospect 17] /viewTopTitles.do 47 79 32
[prospect 25] /viewTopTitles.do 47 94 47
[prospect 12] /viewTitleDetails.do?titreId=13344 156 219 63
[prospect 27] /viewTopTitles.do 62 78 16
[prospect 1] /viewTitleDetails.do?titreId=120726 62 62 0
[prospect 5] /viewTitleDetails.do?titreId=15274 31 47 16
[prospect 24] /viewTitleDetails.do?titreId=123680 32 47 15
[prospect 29] /viewNewEditoTitles.do 47 141 94
[prospect 15] /viewTopTitles.do 47 79 32
[prospect 13] /viewTitleDetails.do?titreId=118276 78 125 47
[prospect 33] /viewNewEditoTitles.do 47 78 31
[prospect 32] /viewTitleDetails.do?titreId=14993 360 359 -1
[prospect 38] /viewTitleDetails.do?titreId=14863 578 579 1
[prospect 4] /viewTitleDetails.do?titreId=114928 16 16 0
[prospect 11] /viewTopTitles.do 46 94 48
[prospect 17] /viewTitleDetails.do?titreId=123968 157 156 -1
[prospect 22] /viewTitleDetails.do?titreId=13155 16 47 31
[prospect 9] /viewTitleDetails.do?titreId=13609 110 172 62
[prospect 44] /glow2/viewIndex.do 16 16 0
[prospect 4] /viewTitleDetails.do?titreId=125315 31 31 0
[prospect 23] /viewTitleDetails.do?titreId=399 171 187 16
[prospect 40] /viewTitleDetails.do?titreId=113054 203 204 1
[prospect 36] /viewTitleDetails.do?titreId=22515 203 219 16
[prospect 19] /viewTitleDetails.do?titreId=103015 281 297 16
[prospect 8] /viewTitleDetails.do?titreId=100586 203 203 0
[prospect 15] /viewTitleDetails.do?titreId=117370 78 78 0
[prospect 35] /viewTitleDetails.do?titreId=122611 16 47 31
[prospect 28] /viewTitleDetails.do?titreId=12443 78 94 16
[prospect 2] /viewTitleDetails.do?titreId=112495 234 235 1
[prospect 18] /viewTitleDetails.do?titreId=112228 31 2049
2018
[prospect 29] /viewTitleDetails.do?titreId=21079 0 31 31
[prospect 30] /viewTopTitles.do 78 1111 1033
[prospect 9] /viewTitleDetails.do?titreId=114931 281 1611
1330
[prospect 16] /viewTitleDetails.do?titreId=125148 250 1485
1235
[prospect 5] /viewTitleDetails.do?titreId=15489 313 2987
2674
[prospect 4] /viewTitleDetails.do?titreId=114409 360 2049
1689
Re: Database procedures
Posted by sebb <se...@gmail.com>.
Have you tried using :
{call dbp_a("BROWN","WALTER","1871")}
A quick Google suggests that the enclosing {} may be required.
If so, and that does not work:
Are you using the same JDBC libraries for the Java program and JMeter?
If so, can you perhaps send me (privately) the relevant Java code that
calls the stored procedure?
Or maybe you could compare your Java code with that in the JMeter code:
http://svn.apache.org/repos/asf/jakarta/jmeter/branches/rel-2-1/src/protocol/jdbc/org/apache/jmeter/protocol/jdbc/sampler/JDBCSampler.java
S.
On 06/06/06, Ron.Bell@gro-scotland.gsi.gov.uk
<Ro...@gro-scotland.gsi.gov.uk> wrote:
> *******************************************************************************************************************************************************
> This email and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed.
> *******************************************************************************************************************************************************
>
> I am attempting to run an Ingres database procedure and have obtained a
> version of JMeter 2.1.1 with the fix for bug 38682. The database
> procedure runs ok through a java program but I have had no success with
> various formats in Jmeter. Here are a sample of my input and responses.
> The sql on which the database procedure was written works fine.
>
> Ron
>
> execute(dbp_a("BROWN","WALTER","1871"))
> execute dbp_a("BROWN","WALTER","1871")
>
> HTTP response message: ca.gcf.util.SqlEx: line 1, Syntax error on
> 'execute'. The correct syntax is:
> OPEN CURSORID CURSOR FOR fullselect
> [FOR [DIRECT | DEFERRED] UPDATE OF column {, ... }]
> [FOR READONLY]
>
> call dbp_a("BROWN","WALTER","1871")
>
> HTTP response message: ca.gcf.util.SqlEx: line 1, The dynamically
> defined statement 'call' not found.
> Perhaps a PREPARE or DESCRIBE wasn't successful.
>
>
> The original of this email was scanned for viruses by Government Secure Intranet (GSi) virus scanning service supplied exclusively by Cable & Wireless in partnership with MessageLabs.
> On leaving the GSI this email was certified virus free.
> The MessageLabs Anti Virus Service is the first managed service to achieve the CSIA Claims Tested Mark (CCTM Certificate Number 2006/04/0007), the UK Government quality mark initiative for information security products and services. For more information about this please visit www.cctmark.gov.uk
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org