On 07/04/2008, heidiaspell <[EMAIL PROTECTED]> wrote: > > I worked out what the problem was. Sadly it wasn't a real bug, just an > oversight on my part. > > I'm maintaining tests created by someone else, and I missed that there was > an assertion created at the level directly under the Thread Group. This > assertion was checking the Response Code for every item in the test, but was > failing to JDBC Requests since the Response Code = null.
Yes, I noticed that the RC and RM are not set when I was looking for the problem. Although JDBC does not have HTTP Response codes, these items should probably be set for the success case - after all, they are set for the failure cases. I'll see about adding that. > Thanks for all your help sebb. > Glad it's finally sorted. > > > > sebb-2-2 wrote: > > > > Can you send me the JMX file privately? (please don't post to the list). > > > > Plus any log files and the JTL file? > > > > You may wish to replace any sensitive data first, but please leave the > > JMX otherwise intact. > > > > On 06/04/2008, heidiaspell <[EMAIL PROTECTED]> wrote: > >> > >> I tried with an Update Statement too, with the same result. > >> > >> > >> > >> > >> sebb-2-2 wrote: > >> > > >> > I've had a look at the JDBC code, and I cannot see any reason why the > >> > status should be set to failed if the sample succeeds. > >> > > >> > Do you get the same result for other types of SQL requests? > >> > > >> > On 06/04/2008, heidiaspell <[EMAIL PROTECTED]> wrote: > >> >> > >> >> JDBC Request shows the following on the Sampler Result tab: > >> >> > >> >> Thread Name: Thread Group 1-1 > >> >> Sample Start: 2008-04-07 08:45:30 NZST > >> >> Load time: 0 > >> >> Latency: 0 > >> >> Size in bytes: 4 > >> >> Sample Count: 1 > >> >> Error Count: 1 > >> >> Response code: > >> >> Response message: > >> >> > >> >> Response headers: > >> >> [EMAIL PROTECTED] > >> >> > >> >> Note: I am being correctly returned Response Data from the query. > >> >> > >> >> > >> >> > >> >> sebb-2-2 wrote: > >> >> > > >> >> > What does the Sampler Result tab show for the Response Code and > >> >> > Response Message? > >> >> > > >> >> > > >> >> > On 06/04/2008, heidiaspell <[EMAIL PROTECTED]> wrote: > >> >> >> > >> >> >> As previously mentioned, there are no errors detailed in > >> jmeter.log. > >> >> >> > >> >> >> 2008/04/07 08:44:56 INFO - jmeter.engine.StandardJMeterEngine: > >> >> Running > >> >> >> the > >> >> >> test! > >> >> >> 2008/04/07 08:44:56 INFO - jmeter.gui.util.JMeterMenuBar: > >> >> >> setRunning(true,*local*) > >> >> >> 2008/04/07 08:44:56 INFO - jmeter.engine.StandardJMeterEngine: > >> >> Starting > >> >> >> 1 > >> >> >> threads for group Thread Group. Ramp up = 1. > >> >> >> 2008/04/07 08:44:56 INFO - jmeter.engine.StandardJMeterEngine: > >> Test > >> >> >> will > >> >> >> stop on error > >> >> >> 2008/04/07 08:44:56 INFO - jmeter.threads.JMeterThread: Thread > >> >> Thread > >> >> >> Group > >> >> >> 1-1 started > >> >> >> 2008/04/07 08:45:30 INFO - jmeter.threads.JMeterThread: Stop > >> Test > >> >> >> detected > >> >> >> by thread Thread Group 1-1 > >> >> >> 2008/04/07 08:45:30 INFO - jmeter.threads.JMeterThread: > >> Stopping > >> >> Thread > >> >> >> Group 1-1 > >> >> >> 2008/04/07 08:45:30 INFO - jmeter.threads.JMeterThread: Thread > >> >> Thread > >> >> >> Group > >> >> >> 1-1 is done > >> >> >> 2008/04/07 08:45:30 INFO - jmeter.engine.StandardJMeterEngine: > >> >> Ending > >> >> >> thread Thread Group 1-1 > >> >> >> 2008/04/07 08:45:30 INFO - jmeter.engine.StandardJMeterEngine: > >> >> Stopping > >> >> >> test > >> >> >> 2008/04/07 08:45:30 INFO - jmeter.engine.StandardJMeterEngine: > >> >> >> Notifying > >> >> >> test listeners of end of test > >> >> >> 2008/04/07 08:45:30 INFO - jmeter.gui.util.JMeterMenuBar: > >> >> >> setRunning(false,*local*) > >> >> >> 2008/04/07 08:45:30 INFO - jmeter.engine.StandardJMeterEngine: > >> Test > >> >> has > >> >> >> ended > >> >> >> > >> >> >> > >> >> >> > >> >> >> sebb-2-2 wrote: > >> >> >> > > >> >> >> > Check jmeter.log for any errors. > >> >> >> > > >> >> >> > On 06/04/2008, heidiaspell <[EMAIL PROTECTED]> wrote: > >> >> >> >> > >> >> >> >> I'm using JMeter 2.3.1 > >> >> >> >> > >> >> >> >> I am not using an Assertion. Here is the structure of my > >> test: > >> >> >> >> > >> >> >> >> - Loop Controller > >> >> >> >> -- Simple Controller > >> >> >> >> --- JDBC Request > >> >> >> >> ---- Regular Expression Extractor > >> >> >> >> > >> >> >> >> My JDBC Request has a Query Type of "Select Statement". > >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> sebb-2-2 wrote: > >> >> >> >> > > >> >> >> >> > Are you using an Assertion? That can set the status to > >> >> failure. > >> >> >> >> > > >> >> >> >> > Which version of JMeter? > >> >> >> >> > > >> >> >> >> > On 03/04/2008, heidiaspell <[EMAIL PROTECTED]> wrote: > >> >> >> >> >> > >> >> >> >> >> I'm using a JDBC Request to perform a simple Select > >> >> statement on > >> >> >> a > >> >> >> >> SQL > >> >> >> >> >> Server > >> >> >> >> >> db. > >> >> >> >> >> > >> >> >> >> >> The Results Tree Response Data tab shows that the > >> results > >> >> were > >> >> >> >> returned > >> >> >> >> >> correctly, but the Sampler Result tab still shows Error > >> >> Count: > >> >> >> 1. > >> >> >> >> >> > >> >> >> >> >> The Summary Report shows 100% failure for my JDBC > >> Request. > >> >> >> >> >> > >> >> >> >> >> There are no errors in the jmeter.log. > >> >> >> >> >> > >> >> >> >> >> Anyone have any ideas? I'm keen to get my tests running > >> >> with 0% > >> >> >> >> errors. > >> >> >> >> >> > >> >> >> >> >> -- > >> >> >> >> >> View this message in context: > >> >> >> >> >> > >> >> >> >> > >> >> >> > >> >> > >> > http://www.nabble.com/JDBC-Request-returns-results-but-still-shows-Error-Count%3A-1-tp16473795p16473795.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] > >> >> >> >> > > >> >> >> >> > > >> >> >> >> > > >> >> >> >> > >> >> >> >> > >> >> >> >> -- > >> >> >> >> View this message in context: > >> >> >> >> > >> >> >> > >> >> > >> > http://www.nabble.com/JDBC-Request-returns-results-but-still-shows-Error-Count%3A-1-tp16473795p16528663.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] > >> >> >> > > >> >> >> > > >> >> >> > > >> >> >> > >> >> >> -- > >> >> >> > >> >> >> View this message in context: > >> >> >> > >> >> > >> > http://www.nabble.com/JDBC-Request-returns-results-but-still-shows-Error-Count%3A-1-tp16473795p16529594.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] > >> >> > > >> >> > > >> >> > > >> >> > >> >> -- > >> >> > >> >> View this message in context: > >> >> > >> > http://www.nabble.com/JDBC-Request-returns-results-but-still-shows-Error-Count%3A-1-tp16473795p16529796.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] > >> > > >> > > >> > > >> > >> -- > >> > >> View this message in context: > >> > http://www.nabble.com/JDBC-Request-returns-results-but-still-shows-Error-Count%3A-1-tp16473795p16530368.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] > > > > > > > > -- > > View this message in context: > http://www.nabble.com/JDBC-Request-returns-results-but-still-shows-Error-Count%3A-1-tp16473795p16531888.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]
