You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@jmeter.apache.org by kyle Hailey <ky...@gmail.com> on 2016/11/11 18:59:16 UTC

Variable Name must not be null

running into an error

            java.lang.IllegalArgumentException: Variable Name must not be
null

for simple statement like

     delete from authors where id in (  select id from authors limit 1 )

Any thoughts? I've googled around and not found much.
I have it set up as an "Query Type :  Update Statement"
Not sure if that's right. Haven't found much info on query type.

This query works fine in psql

Thanks
Kyle

Re: Variable Name must not be null

Posted by kyle Hailey <ky...@gmail.com>.

awesome - fixed !
wow, yeah, that particular block was missing the connection variable.
Thanks so much!!

- Kyle

(had dropped that block originally because of issues and when re-added
forgot that field)





On Fri, Nov 11, 2016 at 11:45 AM, Ivan Rancati <iv...@gmail.com>
wrote:

> Not sure, but quick to check:
> in the JDBC Sampler and JDBC Connection Configuration, under "Variable name
> bound to pool", is perhaps "Variable Name" empty?
>
> best regards
> Ivan
>
> On Fri, Nov 11, 2016 at 7:59 PM, kyle Hailey <ky...@gmail.com> wrote:
>
> > running into an error
> >
> >             java.lang.IllegalArgumentException: Variable Name must not
> be
> > null
> >
> > for simple statement like
> >
> >      delete from authors where id in (  select id from authors limit 1 )
> >
> > Any thoughts? I've googled around and not found much.
> > I have it set up as an "Query Type :  Update Statement"
> > Not sure if that's right. Haven't found much info on query type.
> >
> > This query works fine in psql
> >
> > Thanks
> > Kyle
> >
>

Re: Variable Name must not be null

Posted by Ivan Rancati <iv...@gmail.com>.

Not sure, but quick to check:
in the JDBC Sampler and JDBC Connection Configuration, under "Variable name
bound to pool", is perhaps "Variable Name" empty?

best regards
Ivan

On Fri, Nov 11, 2016 at 7:59 PM, kyle Hailey <ky...@gmail.com> wrote:

> running into an error
>
>             java.lang.IllegalArgumentException: Variable Name must not be
> null
>
> for simple statement like
>
>      delete from authors where id in (  select id from authors limit 1 )
>
> Any thoughts? I've googled around and not found much.
> I have it set up as an "Query Type :  Update Statement"
> Not sure if that's right. Haven't found much info on query type.
>
> This query works fine in psql
>
> Thanks
> Kyle
>