Depending on your server, you can usually configure the db server to
output all sql being excecuted to a log... This can be done in MySql
for instance... Others should have that...
I do know that there is a logging jdbc driver that kind of does
exactly the same... have not used it though... this article may help
http://java.sys-con.com/read/204723.htm
thanks!
On Nov 29, 2007, at 9:54 AM, Kathy Mitchell 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. 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). 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?
Thanks,
Kathy
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
