You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Glenn Caccia <ga...@yahoo.com> on 2014/02/03 23:06:57 UTC
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
Re: JDBC request and DB links
Posted by sebb <se...@gmail.com>.
OK, thanks for letting us know.
On 4 February 2014 00:00, Glenn Caccia <ga...@yahoo.com> wrote:
>
>
> Sorry, my bad on this one. Just found the issue. I was testing the query in JMeter in one environment and didn't notice that I was testing the query in the query execution tool in a different environment. Once I pointed the query execution tool to the same environment, discovered that there was an issue with the configuration of the DB link in that environment.
>
>
> ________________________________
> From: Glenn Caccia <ga...@yahoo.com>
> To: JMeter User Group <us...@jmeter.apache.org>
> Sent: Monday, February 3, 2014 2:06 PM
> Subject: 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
Re: JDBC request and DB links
Posted by Glenn Caccia <ga...@yahoo.com>.
Sorry, my bad on this one. Just found the issue. I was testing the query in JMeter in one environment and didn't notice that I was testing the query in the query execution tool in a different environment. Once I pointed the query execution tool to the same environment, discovered that there was an issue with the configuration of the DB link in that environment.
________________________________
From: Glenn Caccia <ga...@yahoo.com>
To: JMeter User Group <us...@jmeter.apache.org>
Sent: Monday, February 3, 2014 2:06 PM
Subject: 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
Re: AW: JDBC request and DB links
Posted by Glenn Caccia <ga...@yahoo.com>.
Never noticed any memory problems. In this case the issue was on my end. DB Link was not configured properly in the environment I was using.
________________________________
From: René Jehle <Re...@intersys.ch>
To: JMeter Users List <us...@jmeter.apache.org>; Glenn Caccia <ga...@yahoo.com>
Sent: Wednesday, February 5, 2014 12:35 AM
Subject: AW: JDBC request and DB links
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
Re: JDBC request and DB links
Posted by Deepak Shetty <sh...@gmail.com>.
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 <se...@gmail.com> wrote:
> On 5 February 2014 23:09, Deepak Shetty <sh...@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 <Re...@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
>
>
Re: JDBC request and DB links
Posted by sebb <se...@gmail.com>.
On 5 February 2014 23:09, Deepak Shetty <sh...@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 <Re...@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
Re: JDBC request and DB links
Posted by Deepak Shetty <sh...@gmail.com>.
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"
On Wed, Feb 5, 2014 at 12:35 AM, René Jehle <Re...@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
>
>
AW: JDBC request and DB links
Posted by René Jehle <Re...@intersys.ch>.
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