[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jmeter-user
Subject:    RE: Debugging jdbc requests
From:       "Kathy Mitchell" <KMitchell () coremetrics ! com>
Date:       2007-11-29 17:21:38
Message-ID: 1A1531E6D16EBB46BF479B6169D3D6DF01756DB9 () INFMAIL ! core ! coremetrics ! com
[Download RAW message or body]


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
kmitchell@coremetrics.com
682-223-5334 

-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com] 
Sent: Thursday, November 29, 2007 10:01 AM
To: JMeter Users List
Subject: Re: Debugging jdbc requests

On 29/11/2007, Kathy Mitchell <KMitchell@coremetrics.com> 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: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org


[prev in list] [next in list] [prev in thread] [next in thread]