You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by sebb <se...@gmail.com> on 2009/05/14 12:42:18 UTC
Re: Response message: java.sql.SQLException: ORA-01008: not all
variables bound
On 14/05/2009, drubix <an...@gmail.com> wrote:
>
> Hi,
>
> When trying to use parameters with a JDBC sampler I get the folllowing error
> message:
>
> Response message: java.sql.SQLException: ORA-01008: not all variables bound
>
> As far as I know, I'm using the sampler correctly. I have a '?' in place of
> the argument I wish to parametrize and I have a single parameter in the
> "Parameter Values" list and a single type (NUMBER; also tried INTEGER) in
> the "Parameter Types" list. I've tried both a user defined variables (i.e.
> ${argument}) and a static parameter (i.e. 2).
>
> Am I using this sampler correctly? Does anyone know why the variables aren't
> being bound to the request?
Are you sure there aren't any other '?' in the query?
Are you using prepared statement?
Might be worth trying the same query in a non-prepared statement to
double-check it - BTW you can use JMeter variable references in that,
e.g.:
Select booktitle from library where isbn = ${is}
> Thanks,
>
> Drew
>
> --
> View this message in context: http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23534203.html
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> 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 message: java.sql.SQLException: ORA-01008: not all
variables bound
Posted by drubix <an...@gmail.com>.
Oops... never mind. I was being inconsistent with my casing :blush:
===============
drubix wrote:
>
> I'm just using a regular SELECT statement now with the variable inline as
> ${num}. When checking the View Results Tree, the variable ${num} is not
> being resolved (i.e. is being left as ${num}). I've got a debug listener
> just before the sampler is run which shows that the variable is definitely
> set.
>
> I gave up on the other method as putting the variable inline seems
> simpler. I don't know why the variables aren't resolving though. I tried
> a little test in another jmx which did the same thing (put a variable
> inline in a SELECT statement) and it worked perfectly...
>
>
> sebb-2-2 wrote:
>>
>> In that case the regex has not been run, which means either the
>> sampler has not run or it created a null response.
>>
>> If the sampler has been attempted, then there must be something in
>> either the log file, or the Listener (assuming it is in scope) or
>> possibly the console window.
>>
>> On 15/05/2009, drubix <an...@gmail.com> wrote:
>>>
>>> That's what I meant before by when I checked the debug sampler the
>>> default
>>> hadn't been set. Can't find anything in the logs regarding this issue
>>> either.
>>>
>>>
>>>
>>> sebb-2-2 wrote:
>>> >
>>> > On 15/05/2009, drubix <an...@gmail.com> wrote:
>>> >>
>>> >> Sorry, I forgot to mention that I'm using a regex extractor to set
>>> the
>>> >> variable. The regex extractor is a child of the request. The
>>> variables
>>> >> are
>>> >> being set for requests that don't use parameters but not for those
>>> that
>>> >> do.
>>> >
>>> > Make sure you are using a default value (at least until everything
>>> > works) so you can tell if the regex is being processed or not.
>>> >
>>> >>
>>> >>
>>> >> sebb-2-2 wrote:
>>> >> >
>>> >> > On 15/05/2009, drubix <an...@gmail.com> wrote:
>>> >> >>
>>> >> >> Hi Sebb,
>>> >> >>
>>> >> >> I'd been using regular SELECT statements and just tried the
>>> prepared
>>> >> >> SELECT
>>> >> >> statement. When the prepared SELECT statement was run, I got
>>> an
>>> >> error
>>> >> >> message regarding the type "NUMBER" not existing. After
>>> changing
>>> >> the
>>> >> >> data
>>> >> >> type to "INTEGER" it appears that the statement is running fine
>>> (as
>>> >> I'm
>>> >> >> not
>>> >> >> getting an error) but the request isn't showing up the the View
>>> >> Results
>>> >> >> Tree
>>> >> >> listener.
>>> >> >
>>> >> > Check jmeter.log as there should be an entry in the listener.
>>> >> >
>>> >> >> I added a debug sampler to check if the variables were being
>>> set
>>> >> >> but they weren't (not even the default).
>>> >> >
>>> >> > The JDBC sampler does not set variables in 2.3.2.
>>> >> >
>>> >> >> Any clue?
>>> >> >>
>>> >> >> Thanks,
>>> >> >>
>>> >> >> Drew
>>> >> >>
>>> >> >>
>>> >> >>
>>> >> >> sebb-2-2 wrote:
>>> >> >> >
>>> >> >> > On 14/05/2009, drubix <an...@gmail.com> wrote:
>>> >> >> >>
>>> >> >> >> Hi,
>>> >> >> >>
>>> >> >> >> When trying to use parameters with a JDBC sampler I get the
>>> >> >> folllowing
>>> >> >> >> error
>>> >> >> >> message:
>>> >> >> >>
>>> >> >> >> Response message: java.sql.SQLException: ORA-01008: not all
>>> >> >> variables
>>> >> >> >> bound
>>> >> >> >>
>>> >> >> >> As far as I know, I'm using the sampler correctly. I have
>>> a '?'
>>> >> in
>>> >> >> >> place of
>>> >> >> >> the argument I wish to parametrize and I have a single
>>> parameter
>>> >> in
>>> >> >> the
>>> >> >> >> "Parameter Values" list and a single type (NUMBER; also
>>> tried
>>> >> >> INTEGER)
>>> >> >> >> in
>>> >> >> >> the "Parameter Types" list. I've tried both a user defined
>>> >> variables
>>> >> >> >> (i.e.
>>> >> >> >> ${argument}) and a static parameter (i.e. 2).
>>> >> >> >>
>>> >> >> >> Am I using this sampler correctly? Does anyone know why the
>>> >> >> variables
>>> >> >> >> aren't
>>> >> >> >> being bound to the request?
>>> >> >> >
>>> >> >> > Are you sure there aren't any other '?' in the query?
>>> >> >> > Are you using prepared statement?
>>> >> >> >
>>> >> >> > Might be worth trying the same query in a non-prepared
>>> statement
>>> >> to
>>> >> >> > double-check it - BTW you can use JMeter variable references
>>> in
>>> >> that,
>>> >> >> > e.g.:
>>> >> >> >
>>> >> >> > Select booktitle from library where isbn = ${is}
>>> >> >> >
>>> >> >> >> Thanks,
>>> >> >> >>
>>> >> >> >> Drew
>>> >> >> >>
>>> >> >> >> --
>>> >> >> >> View this message in context:
>>> >> >> >>
>>> >> >>
>>> >>
>>> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23534203.html
>>> >> >> >> Sent from the JMeter - User mailing list archive at
>>> Nabble.com.
>>> >> >> >>
>>> >> >> >>
>>> >> >> >>
>>> >> >>
>>> ---------------------------------------------------------------------
>>> >> >> >> 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
>>> >> >> >
>>> >> >> >
>>> >> >> >
>>> >> >>
>>> >> >>
>>> >> >> --
>>> >> >> View this message in context:
>>> >> >>
>>> >>
>>> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551421.html
>>> >> >>
>>> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>>> >> >>
>>> >> >>
>>> >> >>
>>> >>
>>> ---------------------------------------------------------------------
>>> >> >> 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
>>> >> >
>>> >> >
>>> >> >
>>> >>
>>> >> --
>>> >>
>>> >> View this message in context:
>>> >>
>>> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551763.html
>>> >>
>>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>>> >>
>>> >>
>>> >>
>>> ---------------------------------------------------------------------
>>> >> 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
>>> >
>>> >
>>> >
>>>
>>> --
>>>
>>> View this message in context:
>>> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551858.html
>>>
>>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>>
>>>
>>> ---------------------------------------------------------------------
>>> 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
>>
>>
>>
>
>
--
View this message in context: http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23552191.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Response message: java.sql.SQLException: ORA-01008: not all
variables bound
Posted by drubix <an...@gmail.com>.
I'm just using a regular SELECT statement now with the variable inline as
${num}. When checking the View Results Tree, the variable ${num} is not
being resolved (i.e. is being left as ${num}). I've got a debug listener
just before the sampler is run which shows that the variable is definitely
set.
I gave up on the other method as putting the variable inline seems simpler.
I don't know why the variables aren't resolving though. I tried a little
test in another jmx which did the same thing (put a variable inline in a
SELECT statement) and it worked perfectly...
sebb-2-2 wrote:
>
> In that case the regex has not been run, which means either the
> sampler has not run or it created a null response.
>
> If the sampler has been attempted, then there must be something in
> either the log file, or the Listener (assuming it is in scope) or
> possibly the console window.
>
> On 15/05/2009, drubix <an...@gmail.com> wrote:
>>
>> That's what I meant before by when I checked the debug sampler the
>> default
>> hadn't been set. Can't find anything in the logs regarding this issue
>> either.
>>
>>
>>
>> sebb-2-2 wrote:
>> >
>> > On 15/05/2009, drubix <an...@gmail.com> wrote:
>> >>
>> >> Sorry, I forgot to mention that I'm using a regex extractor to set
>> the
>> >> variable. The regex extractor is a child of the request. The
>> variables
>> >> are
>> >> being set for requests that don't use parameters but not for those
>> that
>> >> do.
>> >
>> > Make sure you are using a default value (at least until everything
>> > works) so you can tell if the regex is being processed or not.
>> >
>> >>
>> >>
>> >> sebb-2-2 wrote:
>> >> >
>> >> > On 15/05/2009, drubix <an...@gmail.com> wrote:
>> >> >>
>> >> >> Hi Sebb,
>> >> >>
>> >> >> I'd been using regular SELECT statements and just tried the
>> prepared
>> >> >> SELECT
>> >> >> statement. When the prepared SELECT statement was run, I got an
>> >> error
>> >> >> message regarding the type "NUMBER" not existing. After
>> changing
>> >> the
>> >> >> data
>> >> >> type to "INTEGER" it appears that the statement is running fine
>> (as
>> >> I'm
>> >> >> not
>> >> >> getting an error) but the request isn't showing up the the View
>> >> Results
>> >> >> Tree
>> >> >> listener.
>> >> >
>> >> > Check jmeter.log as there should be an entry in the listener.
>> >> >
>> >> >> I added a debug sampler to check if the variables were being set
>> >> >> but they weren't (not even the default).
>> >> >
>> >> > The JDBC sampler does not set variables in 2.3.2.
>> >> >
>> >> >> Any clue?
>> >> >>
>> >> >> Thanks,
>> >> >>
>> >> >> Drew
>> >> >>
>> >> >>
>> >> >>
>> >> >> sebb-2-2 wrote:
>> >> >> >
>> >> >> > On 14/05/2009, drubix <an...@gmail.com> wrote:
>> >> >> >>
>> >> >> >> Hi,
>> >> >> >>
>> >> >> >> When trying to use parameters with a JDBC sampler I get the
>> >> >> folllowing
>> >> >> >> error
>> >> >> >> message:
>> >> >> >>
>> >> >> >> Response message: java.sql.SQLException: ORA-01008: not all
>> >> >> variables
>> >> >> >> bound
>> >> >> >>
>> >> >> >> As far as I know, I'm using the sampler correctly. I have a
>> '?'
>> >> in
>> >> >> >> place of
>> >> >> >> the argument I wish to parametrize and I have a single
>> parameter
>> >> in
>> >> >> the
>> >> >> >> "Parameter Values" list and a single type (NUMBER; also
>> tried
>> >> >> INTEGER)
>> >> >> >> in
>> >> >> >> the "Parameter Types" list. I've tried both a user defined
>> >> variables
>> >> >> >> (i.e.
>> >> >> >> ${argument}) and a static parameter (i.e. 2).
>> >> >> >>
>> >> >> >> Am I using this sampler correctly? Does anyone know why the
>> >> >> variables
>> >> >> >> aren't
>> >> >> >> being bound to the request?
>> >> >> >
>> >> >> > Are you sure there aren't any other '?' in the query?
>> >> >> > Are you using prepared statement?
>> >> >> >
>> >> >> > Might be worth trying the same query in a non-prepared
>> statement
>> >> to
>> >> >> > double-check it - BTW you can use JMeter variable references
>> in
>> >> that,
>> >> >> > e.g.:
>> >> >> >
>> >> >> > Select booktitle from library where isbn = ${is}
>> >> >> >
>> >> >> >> Thanks,
>> >> >> >>
>> >> >> >> Drew
>> >> >> >>
>> >> >> >> --
>> >> >> >> View this message in context:
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23534203.html
>> >> >> >> Sent from the JMeter - User mailing list archive at
>> Nabble.com.
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> 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
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551421.html
>> >> >>
>> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> 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
>> >> >
>> >> >
>> >> >
>> >>
>> >> --
>> >>
>> >> View this message in context:
>> >>
>> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551763.html
>> >>
>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >>
>> ---------------------------------------------------------------------
>> >> 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
>> >
>> >
>> >
>>
>> --
>>
>> View this message in context:
>> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551858.html
>>
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> 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
>
>
>
--
View this message in context: http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23552145.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Response message: java.sql.SQLException: ORA-01008: not all
variables bound
Posted by sebb <se...@gmail.com>.
In that case the regex has not been run, which means either the
sampler has not run or it created a null response.
If the sampler has been attempted, then there must be something in
either the log file, or the Listener (assuming it is in scope) or
possibly the console window.
On 15/05/2009, drubix <an...@gmail.com> wrote:
>
> That's what I meant before by when I checked the debug sampler the default
> hadn't been set. Can't find anything in the logs regarding this issue
> either.
>
>
>
> sebb-2-2 wrote:
> >
> > On 15/05/2009, drubix <an...@gmail.com> wrote:
> >>
> >> Sorry, I forgot to mention that I'm using a regex extractor to set the
> >> variable. The regex extractor is a child of the request. The variables
> >> are
> >> being set for requests that don't use parameters but not for those that
> >> do.
> >
> > Make sure you are using a default value (at least until everything
> > works) so you can tell if the regex is being processed or not.
> >
> >>
> >>
> >> sebb-2-2 wrote:
> >> >
> >> > On 15/05/2009, drubix <an...@gmail.com> wrote:
> >> >>
> >> >> Hi Sebb,
> >> >>
> >> >> I'd been using regular SELECT statements and just tried the prepared
> >> >> SELECT
> >> >> statement. When the prepared SELECT statement was run, I got an
> >> error
> >> >> message regarding the type "NUMBER" not existing. After changing
> >> the
> >> >> data
> >> >> type to "INTEGER" it appears that the statement is running fine (as
> >> I'm
> >> >> not
> >> >> getting an error) but the request isn't showing up the the View
> >> Results
> >> >> Tree
> >> >> listener.
> >> >
> >> > Check jmeter.log as there should be an entry in the listener.
> >> >
> >> >> I added a debug sampler to check if the variables were being set
> >> >> but they weren't (not even the default).
> >> >
> >> > The JDBC sampler does not set variables in 2.3.2.
> >> >
> >> >> Any clue?
> >> >>
> >> >> Thanks,
> >> >>
> >> >> Drew
> >> >>
> >> >>
> >> >>
> >> >> sebb-2-2 wrote:
> >> >> >
> >> >> > On 14/05/2009, drubix <an...@gmail.com> wrote:
> >> >> >>
> >> >> >> Hi,
> >> >> >>
> >> >> >> When trying to use parameters with a JDBC sampler I get the
> >> >> folllowing
> >> >> >> error
> >> >> >> message:
> >> >> >>
> >> >> >> Response message: java.sql.SQLException: ORA-01008: not all
> >> >> variables
> >> >> >> bound
> >> >> >>
> >> >> >> As far as I know, I'm using the sampler correctly. I have a '?'
> >> in
> >> >> >> place of
> >> >> >> the argument I wish to parametrize and I have a single parameter
> >> in
> >> >> the
> >> >> >> "Parameter Values" list and a single type (NUMBER; also tried
> >> >> INTEGER)
> >> >> >> in
> >> >> >> the "Parameter Types" list. I've tried both a user defined
> >> variables
> >> >> >> (i.e.
> >> >> >> ${argument}) and a static parameter (i.e. 2).
> >> >> >>
> >> >> >> Am I using this sampler correctly? Does anyone know why the
> >> >> variables
> >> >> >> aren't
> >> >> >> being bound to the request?
> >> >> >
> >> >> > Are you sure there aren't any other '?' in the query?
> >> >> > Are you using prepared statement?
> >> >> >
> >> >> > Might be worth trying the same query in a non-prepared statement
> >> to
> >> >> > double-check it - BTW you can use JMeter variable references in
> >> that,
> >> >> > e.g.:
> >> >> >
> >> >> > Select booktitle from library where isbn = ${is}
> >> >> >
> >> >> >> Thanks,
> >> >> >>
> >> >> >> Drew
> >> >> >>
> >> >> >> --
> >> >> >> View this message in context:
> >> >> >>
> >> >>
> >> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23534203.html
> >> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> 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
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >> --
> >> >> View this message in context:
> >> >>
> >> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551421.html
> >> >>
> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >>
> >> >>
> >> >>
> >> ---------------------------------------------------------------------
> >> >> 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
> >> >
> >> >
> >> >
> >>
> >> --
> >>
> >> View this message in context:
> >> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551763.html
> >>
> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> 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
> >
> >
> >
>
> --
>
> View this message in context: http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551858.html
>
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> 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 message: java.sql.SQLException: ORA-01008: not all
variables bound
Posted by drubix <an...@gmail.com>.
That's what I meant before by when I checked the debug sampler the default
hadn't been set. Can't find anything in the logs regarding this issue
either.
sebb-2-2 wrote:
>
> On 15/05/2009, drubix <an...@gmail.com> wrote:
>>
>> Sorry, I forgot to mention that I'm using a regex extractor to set the
>> variable. The regex extractor is a child of the request. The variables
>> are
>> being set for requests that don't use parameters but not for those that
>> do.
>
> Make sure you are using a default value (at least until everything
> works) so you can tell if the regex is being processed or not.
>
>>
>>
>> sebb-2-2 wrote:
>> >
>> > On 15/05/2009, drubix <an...@gmail.com> wrote:
>> >>
>> >> Hi Sebb,
>> >>
>> >> I'd been using regular SELECT statements and just tried the prepared
>> >> SELECT
>> >> statement. When the prepared SELECT statement was run, I got an
>> error
>> >> message regarding the type "NUMBER" not existing. After changing
>> the
>> >> data
>> >> type to "INTEGER" it appears that the statement is running fine (as
>> I'm
>> >> not
>> >> getting an error) but the request isn't showing up the the View
>> Results
>> >> Tree
>> >> listener.
>> >
>> > Check jmeter.log as there should be an entry in the listener.
>> >
>> >> I added a debug sampler to check if the variables were being set
>> >> but they weren't (not even the default).
>> >
>> > The JDBC sampler does not set variables in 2.3.2.
>> >
>> >> Any clue?
>> >>
>> >> Thanks,
>> >>
>> >> Drew
>> >>
>> >>
>> >>
>> >> sebb-2-2 wrote:
>> >> >
>> >> > On 14/05/2009, drubix <an...@gmail.com> wrote:
>> >> >>
>> >> >> Hi,
>> >> >>
>> >> >> When trying to use parameters with a JDBC sampler I get the
>> >> folllowing
>> >> >> error
>> >> >> message:
>> >> >>
>> >> >> Response message: java.sql.SQLException: ORA-01008: not all
>> >> variables
>> >> >> bound
>> >> >>
>> >> >> As far as I know, I'm using the sampler correctly. I have a '?'
>> in
>> >> >> place of
>> >> >> the argument I wish to parametrize and I have a single parameter
>> in
>> >> the
>> >> >> "Parameter Values" list and a single type (NUMBER; also tried
>> >> INTEGER)
>> >> >> in
>> >> >> the "Parameter Types" list. I've tried both a user defined
>> variables
>> >> >> (i.e.
>> >> >> ${argument}) and a static parameter (i.e. 2).
>> >> >>
>> >> >> Am I using this sampler correctly? Does anyone know why the
>> >> variables
>> >> >> aren't
>> >> >> being bound to the request?
>> >> >
>> >> > Are you sure there aren't any other '?' in the query?
>> >> > Are you using prepared statement?
>> >> >
>> >> > Might be worth trying the same query in a non-prepared statement
>> to
>> >> > double-check it - BTW you can use JMeter variable references in
>> that,
>> >> > e.g.:
>> >> >
>> >> > Select booktitle from library where isbn = ${is}
>> >> >
>> >> >> Thanks,
>> >> >>
>> >> >> Drew
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23534203.html
>> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> 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
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551421.html
>> >>
>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >>
>> ---------------------------------------------------------------------
>> >> 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
>> >
>> >
>> >
>>
>> --
>>
>> View this message in context:
>> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551763.html
>>
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> 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
>
>
>
--
View this message in context: http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551858.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Response message: java.sql.SQLException: ORA-01008: not all
variables bound
Posted by sebb <se...@gmail.com>.
On 15/05/2009, drubix <an...@gmail.com> wrote:
>
> Sorry, I forgot to mention that I'm using a regex extractor to set the
> variable. The regex extractor is a child of the request. The variables are
> being set for requests that don't use parameters but not for those that do.
Make sure you are using a default value (at least until everything
works) so you can tell if the regex is being processed or not.
>
>
> sebb-2-2 wrote:
> >
> > On 15/05/2009, drubix <an...@gmail.com> wrote:
> >>
> >> Hi Sebb,
> >>
> >> I'd been using regular SELECT statements and just tried the prepared
> >> SELECT
> >> statement. When the prepared SELECT statement was run, I got an error
> >> message regarding the type "NUMBER" not existing. After changing the
> >> data
> >> type to "INTEGER" it appears that the statement is running fine (as I'm
> >> not
> >> getting an error) but the request isn't showing up the the View Results
> >> Tree
> >> listener.
> >
> > Check jmeter.log as there should be an entry in the listener.
> >
> >> I added a debug sampler to check if the variables were being set
> >> but they weren't (not even the default).
> >
> > The JDBC sampler does not set variables in 2.3.2.
> >
> >> Any clue?
> >>
> >> Thanks,
> >>
> >> Drew
> >>
> >>
> >>
> >> sebb-2-2 wrote:
> >> >
> >> > On 14/05/2009, drubix <an...@gmail.com> wrote:
> >> >>
> >> >> Hi,
> >> >>
> >> >> When trying to use parameters with a JDBC sampler I get the
> >> folllowing
> >> >> error
> >> >> message:
> >> >>
> >> >> Response message: java.sql.SQLException: ORA-01008: not all
> >> variables
> >> >> bound
> >> >>
> >> >> As far as I know, I'm using the sampler correctly. I have a '?' in
> >> >> place of
> >> >> the argument I wish to parametrize and I have a single parameter in
> >> the
> >> >> "Parameter Values" list and a single type (NUMBER; also tried
> >> INTEGER)
> >> >> in
> >> >> the "Parameter Types" list. I've tried both a user defined variables
> >> >> (i.e.
> >> >> ${argument}) and a static parameter (i.e. 2).
> >> >>
> >> >> Am I using this sampler correctly? Does anyone know why the
> >> variables
> >> >> aren't
> >> >> being bound to the request?
> >> >
> >> > Are you sure there aren't any other '?' in the query?
> >> > Are you using prepared statement?
> >> >
> >> > Might be worth trying the same query in a non-prepared statement to
> >> > double-check it - BTW you can use JMeter variable references in that,
> >> > e.g.:
> >> >
> >> > Select booktitle from library where isbn = ${is}
> >> >
> >> >> Thanks,
> >> >>
> >> >> Drew
> >> >>
> >> >> --
> >> >> View this message in context:
> >> >>
> >> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23534203.html
> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >>
> >> >>
> >> >>
> >> ---------------------------------------------------------------------
> >> >> 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
> >> >
> >> >
> >> >
> >>
> >>
> >> --
> >> View this message in context:
> >> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551421.html
> >>
> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> 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
> >
> >
> >
>
> --
>
> View this message in context: http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551763.html
>
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> 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 message: java.sql.SQLException: ORA-01008: not all
variables bound
Posted by drubix <an...@gmail.com>.
Sorry, I forgot to mention that I'm using a regex extractor to set the
variable. The regex extractor is a child of the request. The variables are
being set for requests that don't use parameters but not for those that do.
sebb-2-2 wrote:
>
> On 15/05/2009, drubix <an...@gmail.com> wrote:
>>
>> Hi Sebb,
>>
>> I'd been using regular SELECT statements and just tried the prepared
>> SELECT
>> statement. When the prepared SELECT statement was run, I got an error
>> message regarding the type "NUMBER" not existing. After changing the
>> data
>> type to "INTEGER" it appears that the statement is running fine (as I'm
>> not
>> getting an error) but the request isn't showing up the the View Results
>> Tree
>> listener.
>
> Check jmeter.log as there should be an entry in the listener.
>
>> I added a debug sampler to check if the variables were being set
>> but they weren't (not even the default).
>
> The JDBC sampler does not set variables in 2.3.2.
>
>> Any clue?
>>
>> Thanks,
>>
>> Drew
>>
>>
>>
>> sebb-2-2 wrote:
>> >
>> > On 14/05/2009, drubix <an...@gmail.com> wrote:
>> >>
>> >> Hi,
>> >>
>> >> When trying to use parameters with a JDBC sampler I get the
>> folllowing
>> >> error
>> >> message:
>> >>
>> >> Response message: java.sql.SQLException: ORA-01008: not all
>> variables
>> >> bound
>> >>
>> >> As far as I know, I'm using the sampler correctly. I have a '?' in
>> >> place of
>> >> the argument I wish to parametrize and I have a single parameter in
>> the
>> >> "Parameter Values" list and a single type (NUMBER; also tried
>> INTEGER)
>> >> in
>> >> the "Parameter Types" list. I've tried both a user defined variables
>> >> (i.e.
>> >> ${argument}) and a static parameter (i.e. 2).
>> >>
>> >> Am I using this sampler correctly? Does anyone know why the
>> variables
>> >> aren't
>> >> being bound to the request?
>> >
>> > Are you sure there aren't any other '?' in the query?
>> > Are you using prepared statement?
>> >
>> > Might be worth trying the same query in a non-prepared statement to
>> > double-check it - BTW you can use JMeter variable references in that,
>> > e.g.:
>> >
>> > Select booktitle from library where isbn = ${is}
>> >
>> >> Thanks,
>> >>
>> >> Drew
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23534203.html
>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >>
>> ---------------------------------------------------------------------
>> >> 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
>> >
>> >
>> >
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551421.html
>>
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> 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
>
>
>
--
View this message in context: http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551763.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Response message: java.sql.SQLException: ORA-01008: not all
variables bound
Posted by sebb <se...@gmail.com>.
On 15/05/2009, drubix <an...@gmail.com> wrote:
>
> Hi Sebb,
>
> I'd been using regular SELECT statements and just tried the prepared SELECT
> statement. When the prepared SELECT statement was run, I got an error
> message regarding the type "NUMBER" not existing. After changing the data
> type to "INTEGER" it appears that the statement is running fine (as I'm not
> getting an error) but the request isn't showing up the the View Results Tree
> listener.
Check jmeter.log as there should be an entry in the listener.
> I added a debug sampler to check if the variables were being set
> but they weren't (not even the default).
The JDBC sampler does not set variables in 2.3.2.
> Any clue?
>
> Thanks,
>
> Drew
>
>
>
> sebb-2-2 wrote:
> >
> > On 14/05/2009, drubix <an...@gmail.com> wrote:
> >>
> >> Hi,
> >>
> >> When trying to use parameters with a JDBC sampler I get the folllowing
> >> error
> >> message:
> >>
> >> Response message: java.sql.SQLException: ORA-01008: not all variables
> >> bound
> >>
> >> As far as I know, I'm using the sampler correctly. I have a '?' in
> >> place of
> >> the argument I wish to parametrize and I have a single parameter in the
> >> "Parameter Values" list and a single type (NUMBER; also tried INTEGER)
> >> in
> >> the "Parameter Types" list. I've tried both a user defined variables
> >> (i.e.
> >> ${argument}) and a static parameter (i.e. 2).
> >>
> >> Am I using this sampler correctly? Does anyone know why the variables
> >> aren't
> >> being bound to the request?
> >
> > Are you sure there aren't any other '?' in the query?
> > Are you using prepared statement?
> >
> > Might be worth trying the same query in a non-prepared statement to
> > double-check it - BTW you can use JMeter variable references in that,
> > e.g.:
> >
> > Select booktitle from library where isbn = ${is}
> >
> >> Thanks,
> >>
> >> Drew
> >>
> >> --
> >> View this message in context:
> >> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23534203.html
> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> 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
> >
> >
> >
>
>
> --
> View this message in context: http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551421.html
>
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> 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 message: java.sql.SQLException: ORA-01008: not all
variables bound
Posted by drubix <an...@gmail.com>.
Hi Sebb,
I'd been using regular SELECT statements and just tried the prepared SELECT
statement. When the prepared SELECT statement was run, I got an error
message regarding the type "NUMBER" not existing. After changing the data
type to "INTEGER" it appears that the statement is running fine (as I'm not
getting an error) but the request isn't showing up the the View Results Tree
listener. I added a debug sampler to check if the variables were being set
but they weren't (not even the default).
Any clue?
Thanks,
Drew
sebb-2-2 wrote:
>
> On 14/05/2009, drubix <an...@gmail.com> wrote:
>>
>> Hi,
>>
>> When trying to use parameters with a JDBC sampler I get the folllowing
>> error
>> message:
>>
>> Response message: java.sql.SQLException: ORA-01008: not all variables
>> bound
>>
>> As far as I know, I'm using the sampler correctly. I have a '?' in
>> place of
>> the argument I wish to parametrize and I have a single parameter in the
>> "Parameter Values" list and a single type (NUMBER; also tried INTEGER)
>> in
>> the "Parameter Types" list. I've tried both a user defined variables
>> (i.e.
>> ${argument}) and a static parameter (i.e. 2).
>>
>> Am I using this sampler correctly? Does anyone know why the variables
>> aren't
>> being bound to the request?
>
> Are you sure there aren't any other '?' in the query?
> Are you using prepared statement?
>
> Might be worth trying the same query in a non-prepared statement to
> double-check it - BTW you can use JMeter variable references in that,
> e.g.:
>
> Select booktitle from library where isbn = ${is}
>
>> Thanks,
>>
>> Drew
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23534203.html
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> 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
>
>
>
--
View this message in context: http://www.nabble.com/Response-message%3A-java.sql.SQLException%3A-ORA-01008%3A-not-all-variables-bound-tp23534203p23551421.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org