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

List:       jmeter-user
Subject:    Re: JDBC request and DB links
From:       Deepak Shetty <shettyd () gmail ! com>
Date:       2014-02-05 23:17:03
Message-ID: CAKUYAYfphKSK=ixxy8t_YyiCQ2tntCP8u=yVhhtMCDy9xh1hZA () mail ! gmail ! com
[Download RAW message or body]


In this case though even if you dont have listeners , it still builds the
string to setup as the result..


On Wed, Feb 5, 2014 at 3:14 PM, sebb <sebbaz@gmail.com> wrote:

> 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
>
>


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