jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sebb <seb...@gmail.com>
Subject Re: JDBC Request causes java.sql.SQLException: ORA-00900: invalid SQL statement
Date Mon, 26 May 2014 02:13:16 GMT
On 25 May 2014 18:19,  <ohaya@cox.net> wrote:
> Hi,
>
> I am trying to use Jmeter 2.11 to load test against Oracle database.
>
> I can use a SELECT query in the JDBC Request and that works fine, but when I try the
following:
>
> exec DBMS_SESSION.set_identifier('frank')
>
> I get:
>
> Response message: java.sql.SQLException: ORA-00900: invalid SQL statement
>
> However, if I run that EXEC command using sqlplus, it works fine.
>
> Does Jmeter not allow using the EXEC command in a JDBC request?

An EXEC command is not a Select statement; it is not in fact standard SQL.

However, according to

http://docs.oracle.com/cd/E11882_01/java.112/e16548/getsta.htm#JJDBC28075

the Oracle JDBC driver supports them using the syntax

{call DBMS_SESSION.set_identifier('frank')}

This needs to be invoked in JMeter using the Callable Statement option.

> I tried putting this in a BEGIN...END:
>
> BEGIN
> exec DBMS_SESSION.set_identifier('frank');
> select * from employees;
> END;
>
> but then I got:
>
> Response message: java.sql.SQLException: ORA-06550: line 2, column 6:
> PLS-00103: Encountered the symbol "DBMS_SESSION" when expecting one of the following:
>
>    := . ( @ % ;
> The symbol ":=" was substituted for "DBMS_SESSION" to continue.
>
> Is there a way that this can be done with Jmeter?
>
>
> ---------------------------------------------------------------------
> 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


Mime
View raw message