jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oliver Erlewein <>
Subject Re: Issues with JDBC connection to DB2
Date Mon, 07 Dec 2015 22:06:59 GMT
Hi Deepak,

Looks like it is working as it should. Was an actual application issue. Now
all fixed. It just looked like the Connector was misbehaving.

On 8 Dec 2015 08:27, "Deepak Shetty" <> wrote:

> Assuming you have validated the queries and variables(whitespaces etc) and
> checked JMeter.log
> a. If you reduce the threads to 1 - do you still see the same issue in the
> second iteration ? If not then try setting max number of connections to 0
> (so that connections aren't shared between threads)
> b. If you still see the same issue with b1 thread- try giving a delay in
> your script and using Idle Cleanup Interval(lesser than delay) so that your
> old connection is closed and you get a new connection and see if you still
> have the problem or not ? Do you still see the same behavior if you use a
> loop instead of a thread group iteration?
> Another thing to try is use something like P6SPY to  see what queries are
> being fired according to driver and what the DB is returning..I dont have a
> DB2 instance to test against unfortunately. In SQL server , the profiler
> for instance can show you all queries being fired against the DB - I dont
> know if there is an equivalent in DB2 - but atleast you can see whether
> JMeter is sending the query or not..
> On Sun, Dec 6, 2015 at 1:57 PM, Oliver Erlewein <>
> wrote:
>> Hi all,
>> I am trying to get some data from the DB2 and am using
>> com.IBM.db2os390.sqlj.JDBC.DB2SQLJDriver .
>> The thing is that the first iteration works wonderfully for every thread.
>> Just a very small and simple SQL to get an ID back. Thing is from the
>> second iteration it only returns null.
>> It's like its not closing that 1st request. I tried lots of config stuff
>> but nothing helps.
>> Anyone seen this before?
>> Cheers Oliver

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message