I got the View Results Tree Listener to show the query and it's results but I had to turn on 'Save as XML'. That should make it easier to figure out what's going on in the future.
Thanks, Kathy Mitchell [EMAIL PROTECTED] 682-223-5334 -----Original Message----- From: sebb [mailto:[EMAIL PROTECTED] Sent: Thursday, November 29, 2007 10:01 AM To: JMeter Users List Subject: Re: Debugging jdbc requests On 29/11/2007, Kathy Mitchell <[EMAIL PROTECTED]> wrote: > Does anyone know an good way to debug jdbc requests? I spent a couple > of hours yesterday chasing an sql error that looked like a connection > problem in the jmeter log but was really a problem with the syntax of a > jdbc request. What was the log message? If it's misleading, perhaps it can be fixed. > I had 2 jdbc requests (in separate threads). The second > request had a problem. Even thought the first request was correct is > still did seem to run (it's output file was empty). what are you saying here? did it run or not? > When I fixed the > second request everything worked fine. I tried setting > log_level.jmeter.protocol.jdbc=DEBUG in jmeter.properties but that did > not seem to help. Is there any way to see the actual sql being sent? The View Results Tree Listener should show the query in the Request panel. > Thanks, > > Kathy > --------------------------------------------------------------------- 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]
