My test is as follows now:
Plan
- View Results Tree
- Aggregate Report
- Thread Group
- Java Request
- JDBC Configuration
- JDBC Request
- Java Request
2009/09/22 16:44:38 INFO - jmeter.engine.StandardJMeterEngine: Running the
test!
>2009/09/22 16:44:39 INFO - jmeter.gui.util.JMeterMenuBar:
>setRunning(true,*local*)
>2009/09/22 16:44:43 INFO - jmeter.engine.StandardJMeterEngine: Starting 1
>threads for group Thread Group. Ramp up = 1.
>2009/09/22 16:44:43 INFO - jmeter.engine.StandardJMeterEngine: Continue on
>error
>2009/09/22 16:44:43 INFO - jmeter.threads.JMeterThread: Thread Thread Group
>1-1 started
>2009/09/22 16:44:43 INFO - jmeter.threads.JMeterThread: Thread Thread Group
>1-1 is done
>2009/09/22 16:44:43 INFO - jmeter.engine.StandardJMeterEngine: Ending thread
>Thread Group 1-1
>2009/09/22 16:44:43 INFO - jmeter.engine.StandardJMeterEngine: Stopping test
>2009/09/22 16:44:43 INFO - jmeter.engine.StandardJMeterEngine: Notifying test
>listeners of end of test
>2009/09/22 16:44:43 INFO - jmeter.gui.util.JMeterMenuBar:
>setRunning(false,*local*)
>2009/09/22 16:44:43 INFO - jmeter.engine.StandardJMeterEngine: Test has ended
________________________________
From: sebb <[email protected]>
To: JMeter Users List <[email protected]>
Sent: Tuesday, September 22, 2009 4:21:45 PM
Subject: Re: Problems with Oracle & JDBC query
On 22/09/2009, Chris Hall <[email protected]> wrote:
> Hi Sebb,
> ok - I disabled debug in log4j, lowered the thread count to 1 and added the
> new java samplers before & after.
> Neither appear in my results tree - but both do in my Aggregate Report
> Listener.
That will depend where you put the listeners; I suggest you put them
at top-level in the thread group (or even directly under the test
plan).
> The same problem exists - with no errors thrown in the console.
> My jmeter.log now looks like so for the test run:
>
> 2009/09/22 15:59:51 INFO - jmeter.gui.util.JMeterMenuBar:
> setRunning(true,*local*)
> >2009/09/22 15:59:51 INFO - jmeter.engine.StandardJMeterEngine: Starting 1
> threads for group Thread Group. Ramp up = 1.
> >2009/09/22 15:59:51 INFO - jmeter.engine.StandardJMeterEngine: Continue on
> error
> >2009/09/22 15:59:51 INFO - jmeter.threads.JMeterThread:
> jmeterthread.startearlier=true (see jmeter.properties)
> >2009/09/22 15:59:51 INFO - jmeter.threads.JMeterThread: Running
> PostProcessors in forward order
> >2009/09/22 15:59:51 INFO - jmeter.threads.JMeterThread: Thread Thread
> Group 1-1 started
> >2009/09/22 15:59:51 INFO - jmeter.threads.JMeterThread: Thread Thread
> Group 1-1 is done
> >2009/09/22 15:59:51 INFO - jmeter.engine.StandardJMeterEngine: Ending
> thread Thread Group 1-1
> >2009/09/22 15:59:51 INFO - jmeter.engine.StandardJMeterEngine: Stopping
> test
> >2009/09/22 15:59:51 INFO - jmeter.engine.StandardJMeterEngine: Notifying
> test listeners of end of test
> >2009/09/22 15:59:51 INFO - jmeter.gui.util.JMeterMenuBar:
> setRunning(false,*local*)
> >2009/09/22 15:59:51 INFO - jmeter.engine.StandardJMeterEngine: Test has
> ended
OK, so no errors reported, but the test lasts less than a second,
which suggests the JDBC sampler may not have been run.
> Chris
>
>
>
> ________________________________
> From: sebb <[email protected]>
> To: JMeter Users List <[email protected]>
>
> Sent: Tuesday, September 22, 2009 3:51:44 PM
>
> Subject: Re: Problems with Oracle & JDBC query
>
> Try adding Java samplers before and after the JDBC sampler and make
> sure they show up in the listener.
>
> Check the console window for any errors - sometimes JMeter is unable
> to capture all errors.
>
> Unless you know the code well, I would switch off debug logging - it
> makes the log file harder to read. If you want to use debug, just
> enable it for the JDBC sampler (you can do this from the Help menu)
>
> Start with 1 thread; I suggest you use a max pool of 0 to disable
> connection pooling.
>
> On 22/09/2009, Chris Hall <[email protected]> wrote:
> > I already have one in place - nothing is being displayed there either.
> >
> > I can see the "green light" go - run for a second or so - then complete.
> >
> >
> >
> > ________________________________
> > From: sebb <[email protected]>
> > To: JMeter Users List <[email protected]>
> > Sent: Tuesday, September 22, 2009 3:27:21 PM
> > Subject: Re: Problems with Oracle & JDBC query
> >
> >
> > On 22/09/2009, Chris Hall <[email protected]> wrote:
> > >
> > > 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 setup my test-plan as follows:
> > >
> > > Thread Group
> > > - JDBC Connection Configuration
> > > -JDBC Request
> >
> > Add a View Results Tree Listener
> >
> > > My Configuration is like so:
> > > Database URL: jdbc:oracle:thin:@127.0.0.1:1521:xe
> > > JDBC Driver Class: oracle.jdbc.driver.OracleDriver
> > > UserName: myUser
> > > Password: myPassword
> > >
> > > I've attached the jmeter.log which I hope might help...
> > > http://www.nabble.com/file/p25530752/jmeterJDBC.log jmeterJDBC.log
> > >
> > > Thanks all,
> > > Chris
> > >
> > >
> > > --
> > > View this message in context:
> http://www.nabble.com/Problems-with-Oracle---JDBC-query-tp25530752p25530752.html
> > > Sent from the JMeter - User mailing list archive at Nabble.com.
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: [email protected]
> > > For additional commands, e-mail: [email protected]
> > >
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [email protected]
> > For additional commands, e-mail: [email protected]
> >
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
