jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sebb <seb...@gmail.com>
Subject Re: JDBC request and DB links
Date Wed, 05 Feb 2014 23:14:02 GMT
On 5 February 2014 23:09, Deepak Shetty <shettyd@gmail.com> wrote:
> Hi
> it depends on what your SP is returning - the older JDBC drivers that I
> remember maintained the results in memory , and Jmeter too does that to
> show the result as its response - I do not know of any "leak"
>

Yes, some JMeter Listeners need to store the full response.
For example Tree View.

> On Wed, Feb 5, 2014 at 12:35 AM, René Jehle <Rene.Jehle@intersys.ch> wrote:
>
>> Hi Glenn,
>>
>> did you never got memory problems with your JDBC-Requests ?
>>
>> I call stored procedures on a Oracle DB and after 20 Min. J-Meter is out
>> of memory.
>>
>> With the DB-connection I had a problem first, I had to use the correct
>> JDBC-Driver class:  oracle.jdbc.OracleDriver  in the JDBC Connection
>> Configuration
>> Now the DB-connections works fine.
>>
>> Regards René
>>
>> -----Ursprüngliche Nachricht-----
>> Von: Glenn Caccia [mailto:gacaccia@yahoo.com]
>> Gesendet: Montag, 3. Februar 2014 23:07
>> An: JMeter User Group
>> Betreff: JDBC request and DB links
>>
>> I have a JMeter test script (2.10) that uses a JDBC Connection
>> Configuration element along with a JDBC Request element.  It's been working
>> fine.  The JDBC Connection Configuration element is connecting to an Oracle
>> database.  The JDBC Request element is set for a select statement.  Today I
>> tried to enhance the select statement to use an Oracle DB Link.  After
>> this, I get nothing back from the query and no errors.  The enhanced query
>> works fine in a query execution tool, so I know that much is fine.  I know
>> that the connection information in JMeter is correct as the query without
>> the DB Link reference works fine.  Oracle uses the @ symbol to indicate DB
>> links.  By any chance is this a problem for JMeter?  For example, my
>> original query looked something like...
>>
>> select table1.field1 as myfield
>> from table1
>> join table2
>> on table1.id = table2.fid
>> where t2.filterfield = 'filtervalue'
>>
>>
>> whereas the new query looks something like...
>>
>> select t1.field1 as myfield, t3.field1 as myotherfield from table1 t1 join
>> table2 t2 on t1.id = t2.fid join table3@dblinkname t3
>>
>> on t2.id = t3.fid
>>
>> where t2.filterfield = 'filtervalue'
>>
>>
>>
>>
>> Any thoughts?
>>
>> Thanks,
>>
>> Glenn
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
>> For additional commands, e-mail: user-help@jmeter.apache.org
>>
>>

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


Mime
View raw message