You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by aidy lewis <ai...@googlemail.com> on 2009/03/15 21:04:30 UTC
response data from sql queries in JDBC request
Hi,
I have a number of SQL queries in a JDBC request. However the Response
Data only returns the first SQL query.
Is this correct? Is it possible for all SQL queries to be returned?
Aidy
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: response data from sql queries in JDBC request
Posted by aidy lewis <ai...@googlemail.com>.
Hi Sebb,
This is quite interesting: I looked up 'SQL Injection Attacks' on Wikipedia
http://en.wikipedia.org/wiki/SQL_injection
Where we are told:
"While most SQL Server implementations allow multiple statements to be
executed with one call, some SQL APIs such as php's mysql_query do not
allow this for security reasons."
Aidy
On 16/03/2009, sebb <se...@gmail.com> wrote:
> It's not possible currently to have more than one SQL statement per
> JDBC sampler request.
>
> It looks like support for multiple statements in a single request is
> database dependent.
> It may well be disabled by default as a security measure (makes SQL
> injection attacks more difficult).
>
>
>
> On 16/03/2009, aidy lewis <ai...@googlemail.com> wrote:
> > Sebb,
> >
> > I have many sql statements per use-case. Can I just make sure that it
> > is not possible to have multiple select statements in the JDBC select
> > query request or that it is bad practice?
> >
> > Thanks
> >
> > Aidy
> >
> > 2009/3/15 sebb <se...@gmail.com>:
> >
> > > I am saying that 1 SQL query per request *will* work.
> > >
> > > On 15/03/2009, aidy lewis <ai...@googlemail.com> wrote:
> > >> Hi Sebb,
> > >>
> > >>
> > >> Are you saying I should have 1 SQL query per JDBC request?
> > >>
> > >> Is it not poosible to have mutliple queries within one JDBC request?
> > >>
> > >> Thanks
> > >>
> > >>
> > >> Aidy
> > >>
> > >>
> > >> On 15/03/2009, sebb <se...@gmail.com> wrote:
> > >> > Why not just use several requests?
> > >> >
> > >> >
> > >> >
> > >> > On 15/03/2009, aidy lewis <ai...@googlemail.com> wrote:
> > >> > > Hi,
> > >> > >
> > >> > > I have a number of SQL queries in a JDBC request. However the Response
> > >> > > Data only returns the first SQL query.
> > >> > >
> > >> > > Is this correct? Is it possible for all SQL queries to be returned?
> > >> > >
> > >> > > Aidy
> > >> > >
> > >> >
> > >> > > ---------------------------------------------------------------------
> > >> > > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > >> > > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> > >> > >
> > >> > >
> > >> >
> > >> > ---------------------------------------------------------------------
> > >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > >> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> > >> >
> > >> >
> > >>
> > >> ---------------------------------------------------------------------
> > >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> > >>
> > >>
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> > >
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: response data from sql queries in JDBC request
Posted by aidy lewis <ai...@googlemail.com>.
Hi Sebb,
On 16/03/2009, sebb <se...@gmail.com> wrote:
> It's not possible currently to have more than one SQL statement per
> JDBC sampler request.
>
> It looks like support for multiple statements in a single request is
> database dependent.
> It may well be disabled by default as a security measure (makes SQL
> injection attacks more difficult).
>
I put a DB trace on the request and I seems that all of the statements
have been executed against the db. Using SQL Server 2005.
Thanks
Aidy
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: response data from sql queries in JDBC request
Posted by sebb <se...@gmail.com>.
It's not possible currently to have more than one SQL statement per
JDBC sampler request.
It looks like support for multiple statements in a single request is
database dependent.
It may well be disabled by default as a security measure (makes SQL
injection attacks more difficult).
On 16/03/2009, aidy lewis <ai...@googlemail.com> wrote:
> Sebb,
>
> I have many sql statements per use-case. Can I just make sure that it
> is not possible to have multiple select statements in the JDBC select
> query request or that it is bad practice?
>
> Thanks
>
> Aidy
>
> 2009/3/15 sebb <se...@gmail.com>:
>
> > I am saying that 1 SQL query per request *will* work.
> >
> > On 15/03/2009, aidy lewis <ai...@googlemail.com> wrote:
> >> Hi Sebb,
> >>
> >>
> >> Are you saying I should have 1 SQL query per JDBC request?
> >>
> >> Is it not poosible to have mutliple queries within one JDBC request?
> >>
> >> Thanks
> >>
> >>
> >> Aidy
> >>
> >>
> >> On 15/03/2009, sebb <se...@gmail.com> wrote:
> >> > Why not just use several requests?
> >> >
> >> >
> >> >
> >> > On 15/03/2009, aidy lewis <ai...@googlemail.com> wrote:
> >> > > Hi,
> >> > >
> >> > > I have a number of SQL queries in a JDBC request. However the Response
> >> > > Data only returns the first SQL query.
> >> > >
> >> > > Is this correct? Is it possible for all SQL queries to be returned?
> >> > >
> >> > > Aidy
> >> > >
> >> >
> >> > > ---------------------------------------------------------------------
> >> > > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> > > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> > >
> >> > >
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >
> >> >
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >>
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: response data from sql queries in JDBC request
Posted by aidy lewis <ai...@googlemail.com>.
Sebb,
I have many sql statements per use-case. Can I just make sure that it
is not possible to have multiple select statements in the JDBC select
query request or that it is bad practice?
Thanks
Aidy
2009/3/15 sebb <se...@gmail.com>:
> I am saying that 1 SQL query per request *will* work.
>
> On 15/03/2009, aidy lewis <ai...@googlemail.com> wrote:
>> Hi Sebb,
>>
>>
>> Are you saying I should have 1 SQL query per JDBC request?
>>
>> Is it not poosible to have mutliple queries within one JDBC request?
>>
>> Thanks
>>
>>
>> Aidy
>>
>>
>> On 15/03/2009, sebb <se...@gmail.com> wrote:
>> > Why not just use several requests?
>> >
>> >
>> >
>> > On 15/03/2009, aidy lewis <ai...@googlemail.com> wrote:
>> > > Hi,
>> > >
>> > > I have a number of SQL queries in a JDBC request. However the Response
>> > > Data only returns the first SQL query.
>> > >
>> > > Is this correct? Is it possible for all SQL queries to be returned?
>> > >
>> > > Aidy
>> > >
>> >
>> > > ---------------------------------------------------------------------
>> > > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> > > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> > >
>> > >
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >
>> >
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: response data from sql queries in JDBC request
Posted by sebb <se...@gmail.com>.
I am saying that 1 SQL query per request *will* work.
On 15/03/2009, aidy lewis <ai...@googlemail.com> wrote:
> Hi Sebb,
>
>
> Are you saying I should have 1 SQL query per JDBC request?
>
> Is it not poosible to have mutliple queries within one JDBC request?
>
> Thanks
>
>
> Aidy
>
>
> On 15/03/2009, sebb <se...@gmail.com> wrote:
> > Why not just use several requests?
> >
> >
> >
> > On 15/03/2009, aidy lewis <ai...@googlemail.com> wrote:
> > > Hi,
> > >
> > > I have a number of SQL queries in a JDBC request. However the Response
> > > Data only returns the first SQL query.
> > >
> > > Is this correct? Is it possible for all SQL queries to be returned?
> > >
> > > Aidy
> > >
> >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> > >
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: response data from sql queries in JDBC request
Posted by aidy lewis <ai...@googlemail.com>.
Hi Sebb,
Are you saying I should have 1 SQL query per JDBC request?
Is it not poosible to have mutliple queries within one JDBC request?
Thanks
Aidy
On 15/03/2009, sebb <se...@gmail.com> wrote:
> Why not just use several requests?
>
>
>
> On 15/03/2009, aidy lewis <ai...@googlemail.com> wrote:
> > Hi,
> >
> > I have a number of SQL queries in a JDBC request. However the Response
> > Data only returns the first SQL query.
> >
> > Is this correct? Is it possible for all SQL queries to be returned?
> >
> > Aidy
> >
>
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: response data from sql queries in JDBC request
Posted by sebb <se...@gmail.com>.
Why not just use several requests?
On 15/03/2009, aidy lewis <ai...@googlemail.com> wrote:
> Hi,
>
> I have a number of SQL queries in a JDBC request. However the Response
> Data only returns the first SQL query.
>
> Is this correct? Is it possible for all SQL queries to be returned?
>
> Aidy
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org