On 5 February 2014 23:09, Deepak Shetty <[email protected]> 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 <[email protected]> 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:[email protected]] >> 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: [email protected] >> For additional commands, e-mail: [email protected] >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
