Another point - I reverted to my original ojdbc14.jar - and it works fine too. No need to update to latest version.
Chris ________________________________ From: sebb <seb...@gmail.com> To: JMeter Users List <jmeter-user@jakarta.apache.org> Sent: Tuesday, September 22, 2009 5:08:25 PM Subject: Re: Problems with Oracle & JDBC query On 22/09/2009, Chris Hall <chrishall...@yahoo.com> wrote: > moving the Request as a Sibling and not a child solved the problem. So simple > when you know how :) It's not supposed to be possible to add Samplers to Config elements - one cannot do so for most (any?) of the others. Not sure why JDBC Config allows this; it's a bug... > The responses are appearing in both listeners now btw. > > Thanks Sebb > > > > > ________________________________ > From: sebb <seb...@gmail.com> > To: JMeter Users List <jmeter-user@jakarta.apache.org> > > Sent: Tuesday, September 22, 2009 4:55:17 PM > > Subject: Re: Problems with Oracle & JDBC query > > 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 > > > --------------------------------------------------------------------- To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org
