On 22/09/2009, Chris Hall <chrishall...@yahoo.com> wrote: > > My test is as follows now: > > Plan > - View Results Tree > - Aggregate Report > - Thread Group > - Java Request > - JDBC Configuration > - JDBC Request
Try making the JDBC Request a sibling of the Config - rather than a child. > - Java Request > Do the Java requests appear in both Listeners? > > 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 <seb...@gmail.com> > To: JMeter Users List <jmeter-user@jakarta.apache.org> > Sent: Tuesday, September 22, 2009 4:21:45 PM > > Subject: Re: Problems with Oracle & JDBC query > > On 22/09/2009, Chris Hall <chrishall...@yahoo.com> 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 <seb...@gmail.com> > > To: JMeter Users List <jmeter-user@jakarta.apache.org> > > > > 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 <chrishall...@yahoo.com> 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 <seb...@gmail.com> > > > To: JMeter Users List > <jmeter-user@jakarta.apache.org> > > > Sent: Tuesday, September 22, 2009 3:27:21 PM > > > Subject: Re: Problems with Oracle & JDBC query > > > > > > > > > On 22/09/2009, Chris Hall <chrishall...@yahoo.com> 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: > jmeter-user-unsubscr...@jakarta.apache.org > > > > For additional commands, e-mail: > jmeter-user-h...@jakarta.apache.org > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: > jmeter-user-unsubscr...@jakarta.apache.org > > > For additional commands, e-mail: > jmeter-user-h...@jakarta.apache.org > > > > > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: > jmeter-user-unsubscr...@jakarta.apache.org > > For additional commands, e-mail: > jmeter-user-h...@jakarta.apache.org > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > jmeter-user-unsubscr...@jakarta.apache.org > For additional commands, e-mail: > jmeter-user-h...@jakarta.apache.org > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > jmeter-user-unsubscr...@jakarta.apache.org > For additional commands, e-mail: > jmeter-user-h...@jakarta.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org
