You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Sean Tiley <se...@gmail.com> on 2008/09/16 18:11:23 UTC
JDBC test
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 stating my test is running with no
errors but nothing seems to be happening when I execute the test (I
run a check and my records have not been updated / deleted).
Anyone have any ideas?
Thanks
Sean
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC test
Posted by sebb <se...@gmail.com>.
On 16/09/2008, Sean Tiley <se...@gmail.com> 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 Results Tree' listener but nothing shows up
> at all.
>
It should show up in the listener response data pane
If no entries appear in the listener, then the sample is still in progress.
Does the test run complete?
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC test
Posted by sebb <se...@gmail.com>.
On 16/09/2008, Sean Tiley <se...@gmail.com> 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
>
>
> On Tue, Sep 16, 2008 at 3:15 PM, Sean Tiley <se...@gmail.com> wrote:
> > I do appreciate all the input.
> >
> > I added listeners to all levels of the test plan and all remain blank
> >
> > Please see attached test plan (screen shots)
> >
> > Perhaps I am doing something so obviously incorrect that I can not see it ;-)
> >
> > Sean
> >
>
>
>
>
> --
>
> Sean Tiley
> sean.tiley@gmail.com
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC test
Posted by Sean Tiley <se...@gmail.com>.
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 <se...@gmail.com> wrote:
> I do appreciate all the input.
>
> I added listeners to all levels of the test plan and all remain blank
>
> Please see attached test plan (screen shots)
>
> Perhaps I am doing something so obviously incorrect that I can not see it ;-)
>
> Sean
>
--
Sean Tiley
sean.tiley@gmail.com
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC test
Posted by sebb <se...@gmail.com>.
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 <se...@gmail.com> wrote:
> Nothing at all, just blank
> 'Sampler result' tab has nothing on it
>
>
> Sean
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC test
Posted by Sean Tiley <se...@gmail.com>.
Nothing at all, just blank
'Sampler result' tab has nothing on it
Sean
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC test
Posted by sebb <se...@gmail.com>.
All looks OK - what does the Tree View Listener show?
On 16/09/2008, Sean Tiley <se...@gmail.com> 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 Locale to en_US
> 2008/09/16 14:15:08 INFO - jmeter.JMeter: Loading user properties
> from: C:\Sean\java\jakarta-jmeter-2.3.2\bin\user.properties
> 2008/09/16 14:15:08 INFO - jmeter.JMeter: Loading system properties
> from: C:\Sean\java\jakarta-jmeter-2.3.2\bin\system.properties
> 2008/09/16 14:15:08 INFO - jmeter.JMeter: Copyright (c) 1998-2008 The
> Apache Software Foundation
> 2008/09/16 14:15:08 INFO - jmeter.JMeter: Version 2.3.2 r665936
> 2008/09/16 14:15:08 INFO - jmeter.JMeter: java.version=1.6.0_05
> 2008/09/16 14:15:08 INFO - jmeter.JMeter: java.vm.name=Java
> HotSpot(TM) Client VM
> 2008/09/16 14:15:08 INFO - jmeter.JMeter: os.name=Windows XP
> 2008/09/16 14:15:08 INFO - jmeter.JMeter: os.arch=x86
> 2008/09/16 14:15:08 INFO - jmeter.JMeter: os.version=5.1
> 2008/09/16 14:15:08 INFO - jmeter.JMeter: file.encoding=Cp1252
> 2008/09/16 14:15:08 INFO - jmeter.JMeter: Default Locale=English
> (United States)
> 2008/09/16 14:15:08 INFO - jmeter.JMeter: JMeter Locale=English
> (United States)
> 2008/09/16 14:15:08 INFO - jmeter.JMeter:
> JMeterHome=C:\Sean\java\jakarta-jmeter-2.3.2
> 2008/09/16 14:15:08 INFO - jmeter.JMeter: user.dir
> =C:\Sean\java\jakarta-jmeter-2.3.2\bin
> 2008/09/16 14:15:08 INFO - jmeter.JMeter: PWD
> =C:\Sean\java\jakarta-jmeter-2.3.2\bin
> 2008/09/16 14:15:08 INFO - jmeter.JMeter: IP: 192.168.5.138 Name:
> AC4700 FullName: AC4700
> 2008/09/16 14:15:08 INFO - jmeter.JMeter: Loaded icon properties from
> org/apache/jmeter/images/icon.properties
> 2008/09/16 14:15:09 INFO - jmeter.engine.util.CompoundVariable: Note:
> Function class names must contain the string: '.functions.'
> 2008/09/16 14:15:09 INFO - jmeter.engine.util.CompoundVariable: Note:
> Function class names must not contain the string: '.gui.'
> 2008/09/16 14:15:10 INFO -
> jmeter.protocol.http.sampler.HTTPSamplerBase: Cannot find .className
> property for htmlParser, using default
> 2008/09/16 14:15:10 INFO -
> jmeter.protocol.http.sampler.HTTPSamplerBase: Parser for text/html is
> 2008/09/16 14:15:10 INFO -
> jmeter.protocol.http.sampler.HTTPSamplerBase: Parser for
> application/xhtml+xml is
> 2008/09/16 14:15:10 INFO -
> jmeter.protocol.http.sampler.HTTPSamplerBase: Parser for
> application/xml is
> 2008/09/16 14:15:10 INFO -
> jmeter.protocol.http.sampler.HTTPSamplerBase: Parser for text/xml is
> 2008/09/16 14:15:10 INFO -
> jmeter.protocol.http.sampler.HTTPSamplerBase: Parser for
> text/vnd.wap.wml is
> org.apache.jmeter.protocol.http.parser.RegexpHTMLParser
> 2008/09/16 14:15:10 INFO - jmeter.gui.util.MenuFactory: Skipping
> org.apache.jmeter.protocol.http.modifier.gui.ParamModifierGui
> 2008/09/16 14:15:10 INFO - jmeter.gui.util.MenuFactory: Skipping
> org.apache.jmeter.protocol.http.modifier.gui.UserParameterModifierGui
> 2008/09/16 14:15:10 INFO - jmeter.protocol.http.sampler.HTTPSampler:
> Maximum connection retries = 10
> 2008/09/16 14:15:10 WARN - jmeter.gui.util.MenuFactory: Missing jar?
> Could not create org.apache.jmeter.visualizers.MailerVisualizer.
> java.lang.NoClassDefFoundError: javax/mail/MessagingException
> 2008/09/16 14:15:10 INFO - jmeter.samplers.SampleResult: Note: Sample
> TimeStamps are START times
> 2008/09/16 14:15:10 INFO - jmeter.samplers.SampleResult:
> sampleresult.default.encoding is set to ISO-8859-1
> 2008/09/16 14:15:16 INFO - jmeter.services.FileServer: Default
> base=C:\Sean\java\jakarta-jmeter-2.3.2\bin
> 2008/09/16 14:15:16 INFO - jmeter.gui.action.Load: Loading file:
> C:\Sean\java\jakarta-jmeter-2.3.2\bin\JDBC Connection
> Configuration.jmx
> 2008/09/16 14:15:16 INFO - jmeter.services.FileServer: Set new
> base=C:\Sean\java\jakarta-jmeter-2.3.2\bin
> 2008/09/16 14:15:16 INFO - jmeter.save.SaveService: Testplan (JMX)
> version: 2.2. Testlog (JTL) version: 2.2
> 2008/09/16 14:15:16 INFO - jmeter.save.SaveService: Using SaveService
> properties file encoding UTF-8
> 2008/09/16 14:15:16 INFO - jmeter.save.SaveService: Using SaveService
> properties file version 661482
> 2008/09/16 14:15:16 INFO - jmeter.save.SaveService: Using SaveService
> properties version 2.1
> 2008/09/16 14:15:16 INFO - jmeter.save.SaveService: All converter
> versions present and correct
> 2008/09/16 14:15:16 INFO - jmeter.services.FileServer: Set new
> base=C:\Sean\java\jakarta-jmeter-2.3.2\bin
> 2008/09/16 14:15:23 INFO - jmeter.engine.StandardJMeterEngine:
> Listeners will be started after enabling running version
> 2008/09/16 14:15:23 INFO - jmeter.engine.StandardJMeterEngine: To
> revert to the earlier behaviour, define
> jmeterengine.startlistenerslater=false
> 2008/09/16 14:15:23 INFO - jmeter.engine.StandardJMeterEngine:
> Running the test!
> 2008/09/16 14:15:23 DEBUG -
> jmeter.protocol.jdbc.config.DataSourceElement: MaxPool: 1 Timeout:
> TrimInt: Auto-Commit: false
> 2008/09/16 14:15:23 DEBUG -
> jmeter.protocol.jdbc.config.DataSourceElement: KeepAlive: false Age:
> CheckQuery:
> 2008/09/16 14:15:23 DEBUG -
> jmeter.protocol.jdbc.config.DataSourceElement: Driver:
> oracle.jdbc.driver.OracleDriver DbUrl:
> jdbc:oracle:thin:@XXX.XXX.XXX.XXX:1521:SID User: sysweb
> 2008/09/16 14:15:23 DEBUG -
> jmeter.protocol.jdbc.config.DataSourceElement: Loading new driver:
> oracle.jdbc.driver.OracleDriver
> 2008/09/16 14:15:23 INFO - jmeter.gui.util.JMeterMenuBar:
> setRunning(true,*local*)
> 2008/09/16 14:15:24 INFO - jmeter.engine.StandardJMeterEngine:
> Starting 1 threads for group DBReset. Ramp up = 1.
> 2008/09/16 14:15:24 INFO - jmeter.engine.StandardJMeterEngine:
> Continue on error
> 2008/09/16 14:15:24 INFO - jmeter.threads.JMeterThread:
> jmeterthread.startearlier=true (see jmeter.properties)
> 2008/09/16 14:15:24 INFO - jmeter.threads.JMeterThread: Running
> PostProcessors in forward order
> 2008/09/16 14:15:24 DEBUG - jmeter.threads.TestCompiler: Subtracting
> node, stack size = 3
> 2008/09/16 14:15:24 DEBUG - jmeter.threads.TestCompiler: adding
> controller: org.apache.jmeter.threads.ThreadGroup@f1e762 to sampler
> config
> 2008/09/16 14:15:24 DEBUG - jmeter.threads.SamplePackage: configs is
> null: false
> 2008/09/16 14:15:24 DEBUG - jmeter.threads.TestCompiler: Subtracting
> node, stack size = 2
> 2008/09/16 14:15:24 DEBUG - jmeter.threads.TestCompiler: Subtracting
> node, stack size = 2
> 2008/09/16 14:15:24 DEBUG - jmeter.threads.TestCompiler: Subtracting
> node, stack size = 2
> 2008/09/16 14:15:24 DEBUG - jmeter.threads.TestCompiler: Subtracting
> node, stack size = 1
> 2008/09/16 14:15:24 INFO - jmeter.threads.JMeterThread: Thread
> DBReset 1-1 started
> 2008/09/16 14:15:24 INFO - jmeter.threads.JMeterThread: Thread
> DBReset 1-1 is done
> 2008/09/16 14:15:24 INFO - jmeter.engine.StandardJMeterEngine: Ending
> thread DBReset 1-1
> 2008/09/16 14:15:24 INFO - jmeter.engine.StandardJMeterEngine: Stopping test
> 2008/09/16 14:15:24 INFO - jmeter.engine.StandardJMeterEngine:
> Notifying test listeners of end of test
> 2008/09/16 14:15:24 INFO - jmeter.gui.util.JMeterMenuBar:
> setRunning(false,*local*)
> 2008/09/16 14:15:24 INFO - jmeter.engine.StandardJMeterEngine: Test has ended
>
>
>
>
> Sean
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC test
Posted by Sean Tiley <se...@gmail.com>.
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.3.2\bin\user.properties
2008/09/16 14:15:08 INFO - jmeter.JMeter: Loading system properties
from: C:\Sean\java\jakarta-jmeter-2.3.2\bin\system.properties
2008/09/16 14:15:08 INFO - jmeter.JMeter: Copyright (c) 1998-2008 The
Apache Software Foundation
2008/09/16 14:15:08 INFO - jmeter.JMeter: Version 2.3.2 r665936
2008/09/16 14:15:08 INFO - jmeter.JMeter: java.version=1.6.0_05
2008/09/16 14:15:08 INFO - jmeter.JMeter: java.vm.name=Java
HotSpot(TM) Client VM
2008/09/16 14:15:08 INFO - jmeter.JMeter: os.name=Windows XP
2008/09/16 14:15:08 INFO - jmeter.JMeter: os.arch=x86
2008/09/16 14:15:08 INFO - jmeter.JMeter: os.version=5.1
2008/09/16 14:15:08 INFO - jmeter.JMeter: file.encoding=Cp1252
2008/09/16 14:15:08 INFO - jmeter.JMeter: Default Locale=English
(United States)
2008/09/16 14:15:08 INFO - jmeter.JMeter: JMeter Locale=English
(United States)
2008/09/16 14:15:08 INFO - jmeter.JMeter:
JMeterHome=C:\Sean\java\jakarta-jmeter-2.3.2
2008/09/16 14:15:08 INFO - jmeter.JMeter: user.dir
=C:\Sean\java\jakarta-jmeter-2.3.2\bin
2008/09/16 14:15:08 INFO - jmeter.JMeter: PWD
=C:\Sean\java\jakarta-jmeter-2.3.2\bin
2008/09/16 14:15:08 INFO - jmeter.JMeter: IP: 192.168.5.138 Name:
AC4700 FullName: AC4700
2008/09/16 14:15:08 INFO - jmeter.JMeter: Loaded icon properties from
org/apache/jmeter/images/icon.properties
2008/09/16 14:15:09 INFO - jmeter.engine.util.CompoundVariable: Note:
Function class names must contain the string: '.functions.'
2008/09/16 14:15:09 INFO - jmeter.engine.util.CompoundVariable: Note:
Function class names must not contain the string: '.gui.'
2008/09/16 14:15:10 INFO -
jmeter.protocol.http.sampler.HTTPSamplerBase: Cannot find .className
property for htmlParser, using default
2008/09/16 14:15:10 INFO -
jmeter.protocol.http.sampler.HTTPSamplerBase: Parser for text/html is
2008/09/16 14:15:10 INFO -
jmeter.protocol.http.sampler.HTTPSamplerBase: Parser for
application/xhtml+xml is
2008/09/16 14:15:10 INFO -
jmeter.protocol.http.sampler.HTTPSamplerBase: Parser for
application/xml is
2008/09/16 14:15:10 INFO -
jmeter.protocol.http.sampler.HTTPSamplerBase: Parser for text/xml is
2008/09/16 14:15:10 INFO -
jmeter.protocol.http.sampler.HTTPSamplerBase: Parser for
text/vnd.wap.wml is
org.apache.jmeter.protocol.http.parser.RegexpHTMLParser
2008/09/16 14:15:10 INFO - jmeter.gui.util.MenuFactory: Skipping
org.apache.jmeter.protocol.http.modifier.gui.ParamModifierGui
2008/09/16 14:15:10 INFO - jmeter.gui.util.MenuFactory: Skipping
org.apache.jmeter.protocol.http.modifier.gui.UserParameterModifierGui
2008/09/16 14:15:10 INFO - jmeter.protocol.http.sampler.HTTPSampler:
Maximum connection retries = 10
2008/09/16 14:15:10 WARN - jmeter.gui.util.MenuFactory: Missing jar?
Could not create org.apache.jmeter.visualizers.MailerVisualizer.
java.lang.NoClassDefFoundError: javax/mail/MessagingException
2008/09/16 14:15:10 INFO - jmeter.samplers.SampleResult: Note: Sample
TimeStamps are START times
2008/09/16 14:15:10 INFO - jmeter.samplers.SampleResult:
sampleresult.default.encoding is set to ISO-8859-1
2008/09/16 14:15:16 INFO - jmeter.services.FileServer: Default
base=C:\Sean\java\jakarta-jmeter-2.3.2\bin
2008/09/16 14:15:16 INFO - jmeter.gui.action.Load: Loading file:
C:\Sean\java\jakarta-jmeter-2.3.2\bin\JDBC Connection
Configuration.jmx
2008/09/16 14:15:16 INFO - jmeter.services.FileServer: Set new
base=C:\Sean\java\jakarta-jmeter-2.3.2\bin
2008/09/16 14:15:16 INFO - jmeter.save.SaveService: Testplan (JMX)
version: 2.2. Testlog (JTL) version: 2.2
2008/09/16 14:15:16 INFO - jmeter.save.SaveService: Using SaveService
properties file encoding UTF-8
2008/09/16 14:15:16 INFO - jmeter.save.SaveService: Using SaveService
properties file version 661482
2008/09/16 14:15:16 INFO - jmeter.save.SaveService: Using SaveService
properties version 2.1
2008/09/16 14:15:16 INFO - jmeter.save.SaveService: All converter
versions present and correct
2008/09/16 14:15:16 INFO - jmeter.services.FileServer: Set new
base=C:\Sean\java\jakarta-jmeter-2.3.2\bin
2008/09/16 14:15:23 INFO - jmeter.engine.StandardJMeterEngine:
Listeners will be started after enabling running version
2008/09/16 14:15:23 INFO - jmeter.engine.StandardJMeterEngine: To
revert to the earlier behaviour, define
jmeterengine.startlistenerslater=false
2008/09/16 14:15:23 INFO - jmeter.engine.StandardJMeterEngine:
Running the test!
2008/09/16 14:15:23 DEBUG -
jmeter.protocol.jdbc.config.DataSourceElement: MaxPool: 1 Timeout:
TrimInt: Auto-Commit: false
2008/09/16 14:15:23 DEBUG -
jmeter.protocol.jdbc.config.DataSourceElement: KeepAlive: false Age:
CheckQuery:
2008/09/16 14:15:23 DEBUG -
jmeter.protocol.jdbc.config.DataSourceElement: Driver:
oracle.jdbc.driver.OracleDriver DbUrl:
jdbc:oracle:thin:@XXX.XXX.XXX.XXX:1521:SID User: sysweb
2008/09/16 14:15:23 DEBUG -
jmeter.protocol.jdbc.config.DataSourceElement: Loading new driver:
oracle.jdbc.driver.OracleDriver
2008/09/16 14:15:23 INFO - jmeter.gui.util.JMeterMenuBar:
setRunning(true,*local*)
2008/09/16 14:15:24 INFO - jmeter.engine.StandardJMeterEngine:
Starting 1 threads for group DBReset. Ramp up = 1.
2008/09/16 14:15:24 INFO - jmeter.engine.StandardJMeterEngine:
Continue on error
2008/09/16 14:15:24 INFO - jmeter.threads.JMeterThread:
jmeterthread.startearlier=true (see jmeter.properties)
2008/09/16 14:15:24 INFO - jmeter.threads.JMeterThread: Running
PostProcessors in forward order
2008/09/16 14:15:24 DEBUG - jmeter.threads.TestCompiler: Subtracting
node, stack size = 3
2008/09/16 14:15:24 DEBUG - jmeter.threads.TestCompiler: adding
controller: org.apache.jmeter.threads.ThreadGroup@f1e762 to sampler
config
2008/09/16 14:15:24 DEBUG - jmeter.threads.SamplePackage: configs is
null: false
2008/09/16 14:15:24 DEBUG - jmeter.threads.TestCompiler: Subtracting
node, stack size = 2
2008/09/16 14:15:24 DEBUG - jmeter.threads.TestCompiler: Subtracting
node, stack size = 2
2008/09/16 14:15:24 DEBUG - jmeter.threads.TestCompiler: Subtracting
node, stack size = 2
2008/09/16 14:15:24 DEBUG - jmeter.threads.TestCompiler: Subtracting
node, stack size = 1
2008/09/16 14:15:24 INFO - jmeter.threads.JMeterThread: Thread
DBReset 1-1 started
2008/09/16 14:15:24 INFO - jmeter.threads.JMeterThread: Thread
DBReset 1-1 is done
2008/09/16 14:15:24 INFO - jmeter.engine.StandardJMeterEngine: Ending
thread DBReset 1-1
2008/09/16 14:15:24 INFO - jmeter.engine.StandardJMeterEngine: Stopping test
2008/09/16 14:15:24 INFO - jmeter.engine.StandardJMeterEngine:
Notifying test listeners of end of test
2008/09/16 14:15:24 INFO - jmeter.gui.util.JMeterMenuBar:
setRunning(false,*local*)
2008/09/16 14:15:24 INFO - jmeter.engine.StandardJMeterEngine: Test has ended
Sean
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC test
Posted by sebb <se...@gmail.com>.
On 16/09/2008, Jose Castro <ok...@gmail.com> 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 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 this
> ${__logn('SUBSCRIBER' ${__V(inputVar_${counter}_g1)},OUT)}
>
or equivalently:
print('SUBSCRIBER' ${__V(inputVar_${counter}_g1)})
But the Debug Sampler in combination with the Tree View Listener is
probably easier.
>
>
>
>
>
> On Tue, Sep 16, 2008 at 2:01 PM, Sean Tiley <se...@gmail.com> 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 Results Tree' listener but nothing shows up
> > at all.
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC test
Posted by Jose Castro <ok...@gmail.com>.
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 this
${__logn('SUBSCRIBER' ${__V(inputVar_${counter}_g1)},OUT)}
On Tue, Sep 16, 2008 at 2:01 PM, Sean Tiley <se...@gmail.com> 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 Results Tree' listener but nothing shows up
> at all.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC test
Posted by Sean Tiley <se...@gmail.com>.
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.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC test
Posted by Jose Castro <ok...@gmail.com>.
Did you install the ojdbc14.jar on the lib directory??
On Tue, Sep 16, 2008 at 12:11 PM, Sean Tiley <se...@gmail.com> 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/build-db-test-plan.html).
> There are entries in the JMeter log stating my test is running with no
> errors but nothing seems to be happening when I execute the test (I
> run a check and my records have not been updated / deleted).
>
> Anyone have any ideas?
>
> Thanks
> Sean
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC test
Posted by sebb <se...@gmail.com>.
On 16/09/2008, Sean Tiley <se...@gmail.com> 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/build-db-test-plan.html).
> There are entries in the JMeter log stating my test is running with no
> errors but nothing seems to be happening when I execute the test (I
> run a check and my records have not been updated / deleted).
>
> Anyone have any ideas?
Does a simple SELECT work?
Do the samples complete, or do they hang?
As far as I know, the default should be Autocommit on, but if not, try
adding that to the test plan.
Try setting the Maximum number of connections to zero in the JDBC
config - this will force each JMeter thread to use its own connection,
which is usually what one wants.
> Thanks
> Sean
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org