Bug #27065 Incorrect arguments to mysql_stmt_execute
Submitted: 13 Mar 2007 5:08 Modified: 31 Mar 2014 12:30
Reporter: Joseph Kulandai Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / J Severity:S2 (Serious)
Version:mysql-connector-java-5.0.4 OS:Windows (Win XP)
Assigned to: Alexander Soklakov CPU Architecture:Any

[13 Mar 2007 5:08] Joseph Kulandai
Description:
ENVIRONMENT:

MySQL Server version: 5.0.15-nt
MySQL Connector/J driver in use: mysql-connector-java-5.0.4-bin.jar
Jave Version: 1.5.0_06-b05
OS: WinXP + SP2
Server: JBoss-4.0.3
Connection Pool: Apache DBCP
-------------------------------------------
CODE:

	pstm = con.prepareStatement("insert into acc_astmaster values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
				pstm.setInt(1, npe.getAstgrpcode());
				pstm.setInt(2, npe.getAstid());
				pstm.setString(3, npe.getAstdesc());
...
...
			pstm.executeUpdate();
-------------------------------------------
ERROR MESSAGE RECEIVED FROM APPLICATION SERVER'S ERROR LOG

java.sql.SQLException: Incorrect arguments to mysql_stmt_execute
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:227)
at com.scholar.finance.Acc_AstMasterDB.insert(Acc_AstMasterDB.java:68)
at org.apache.jsp.jsp.finance._12_005f3a2p1_jsp._jspService(org.apache.jsp.jsp.finance._12_005f3a2p1_jsp:417)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
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:810)
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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
at com.scholar.common.Controller.doPost(Controller.java:189)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
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.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
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:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Unknown Source)
-------------------------------------------
PROBLEM DESCRIPTION:
I am inserting to a table with 25 fields, server throws the above give exception.

When I used the MySQL Connector/J driver version mysql-connector-java-3.0.17, I DONT get this error and it works.

--------------------------------------------
Please refer also: http://bugs.mysql.com/bug.php?id=16894

How to repeat:
100% Reproducible in the environment given.
[3 Apr 2007 8:07] Tonci Grgin
Hi Joseph and thanks for your report.

> MySQL Server version: 5.0.15-nt
> MySQL Connector/J driver in use: mysql-connector-java-5.0.4-bin.jar
> Jave Version: 1.5.0_06-b05
> OS: WinXP + SP2
> Server: JBoss-4.0.3
> Connection Pool: Apache DBCP
-------------------------------------------
Can you please:
 - Boild down test case so that it doesn't use JBoss?
 - Attach relevant part of general query log from the server from the time you start your application until error is thrown?

I want to be sure what's sent to server and that there's no error in JBoss/Apache part of your config (over which I have no control).
[3 May 2007 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[4 May 2007 5:53] Tonci Grgin
Joseph, feedback is still needed.
[4 Jun 2007 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[31 Mar 2014 12:30] Alexander Soklakov
I close this report as "Can't repeat" because there is no feedback for a long time and codebase is too old. Please, feel free to reopen it if the problem still exists in current driver.