Bug #62410 ArrayIndexOutOfBoundsException
Submitted: 12 Sep 2011 10:31 Modified: 13 Sep 2011 8:34
Reporter: omkar sunil Email Updates:
Status: Unsupported Impact on me:
None 
Category:Connector / J Severity:S2 (Serious)
Version:5.0.8 OS:Any
Assigned to: CPU Architecture:Any

[12 Sep 2011 10:31] omkar sunil
Description:
I'm currently running mysql-connector-3.1.12 and  when I switched my connector to
5.0.8, most of the time queries worked but on some times I got an error in this
connector itself.

I am trying to execute  select query as bellow:

query:  String queryforGroups = "select title, acdenabled, extendedgroup, grouptype from special where code = ? and siteid = ?";//modified for BLA

java.sql.SQLException: Error during query: Unexpected Exception: java.lang.ArrayIndexOutOfBoundsException message given: null

 

Nested Stack Trace:

 

 

** BEGIN NESTED EXCEPTION **

 

java.lang.ArrayIndexOutOfBoundsException

 

STACKTRACE:

 

java.lang.ArrayIndexOutOfBoundsException

 

 

** END NESTED EXCEPTION **

 

 

- Servlet.service() for servlet jsp threw exception

java.lang.ArrayIndexOutOfBoundsException: 252 >= 252

        at java.util.Vector.elementAt(Vector.java:432)

        at org.apache.jsp.AdminSaaS.FreePhones_jsp._jspService(FreePhones_jsp.java:1105)

        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)

        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

        at java.lang.Thread.run(Thread.java:595)

 

How to repeat:
Use the above test program
[12 Sep 2011 13:13] Valeriy Kravchuk
Please, send the entire code fragment that executes this query. Note also that latest driver version is 5.1.17.
[13 Sep 2011 4:55] omkar sunil
I submitted the file which am executing,
Please go through it and send solution as soon as possible

Thank you
[13 Sep 2011 8:34] Tonci Grgin
Omkar, c/J 5.0.8 is long deprecated. Please do two things:
  o If you want to stick with 5.0 branch, check documentation for new properties/changed properties between 3.x and 5.0 branches. Modify your code accordingly.
  o If you upgrade to 5.1.17 and the code still fails, check documentation for new properties/changed properties between 5.0 and 5.1 branches and modify your code accordingly. If it fails still, reopen the bug report.
[13 Sep 2011 12:15] Mark Matthews
The JDBC driver is present nowhere in this stack trace. This is a application logic bug of some sort, it seems to have nothing to do with JDBC or MySQL at all.