Re: ArrayIndexOutOfBoundsException in JDBC Response

Bijaya Ray wrote:
> Hi Team,
>
> I am using Jmeter5.6 to create JDBC Request for Oracle Database Testing .
> It is a simple Select statement. The request is passing properly but
> response is showing as below
>
>
>
>
> Response Code : 000
> Response Message :  *java.lang.ArrayIndexOutOfBoundsException : Index 7 Out
> of bounds for length 2*
>
>
> *Select Statement - Select Column_name from Table_name*
> *Oracle DB - Oracle 8i*
> Java Version - OpenJDK Runtime Environment Corretto-17.0.7.7.1
>
> Please help in finding the issue.
>
> Thanks in advance
> Bijaya
>
We cannot help you without seeing jmeter.log file with JMeter debug 
logging enabled <https://www.blazemeter.com/blog/jmeter-logging> at 
least for JDBC prototol. It can be done by adding the next line to 
/log4j2.xml/ file:

     <Logger name="org.apache.jmeter.protocol.jdbc" level="debug" />


Most probably you're using the wrong driver version 
<https://stackoverflow.com/questions/47966597/how-to-connect-java-with-oracle-8i-database-on-local-network>. 
If you have access to Oracle instance take the driver from its jdbc/lib 
folder.