[Ds-java-dev] [jira] Resolved: (DS-446) SQL insert tries to enter multiple entries hence it fails

[sumedha rubasinghe (JIRA)]

     [ https://wso2.org/jira/browse/DS-446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

sumedha rubasinghe resolved DS-446.
-----------------------------------

    Resolution: Fixed

> SQL insert tries to enter multiple entries hence it fails
> ---------------------------------------------------------
>
>                 Key: DS-446
>                 URL: https://wso2.org/jira/browse/DS-446
>             Project: WSO2 Data Services
>          Issue Type: Bug
>          Components: core
>         Environment: MySQL5
>            Reporter: Charitha Kankanamge
>            Assignee: sumedha rubasinghe
>            Priority: Blocker
>
> SQL Insert through data services fail due to the addition of duplicate entries. 
> [2008-09-15 11:25:11,156] ERROR -  [dataservice2] Exception occurred while trying to execute the SQL statement : insert into customers values('22', 'Chamara11', 'Panadura11').Messa
> ge from the server is :  {org.apache.axis2.engine.AxisEngine}
> org.apache.axis2.AxisFault: [dataservice2] Exception occurred while trying to execute the SQL statement : insert into customers values('22', 'Chamara11', 'Panadura11').Message from
>  the server is :
>         at org.wso2.dataservices.DBUtils.getSelectResult(DBUtils.java:845)
>         at org.wso2.dataservices.DBUtils.getRDBMSResult(DBUtils.java:187)
>         at org.wso2.dataservices.DBUtils.processSQLQuery(DBUtils.java:111)
>         at org.wso2.dataservices.DBUtils.invoke(DBUtils.java:919)
>         at org.wso2.dataservices.DBMessageReceiver.invokeBusinessLogic(DBMessageReceiver.java:41)
>         at org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBusinessLogic(AbstractInOutSyncMessageReceiver.java:42)
>         at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:100)
>         at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176)
>         at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
>         at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:133)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>         at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
>         at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
>         at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:67)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>         at org.wso2.carbon.bridge.BridgeServlet.service(BridgeServlet.java:116)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
>         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
>         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
>         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
>         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
>         at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
>         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
>         at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
>         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
>         at java.lang.Thread.run(Thread.java:595)
> Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '22' for key 1
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
>         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:1160)
>         at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685)
>         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1400)
>         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1314)
>         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1299)
>         at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
>         at org.wso2.dataservices.DBUtils.getSelectResult(DBUtils.java:684) 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://wso2.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira