Sequoia 3.0 beta 2 doesn't recognize mysql's insert ignore into
---------------------------------------------------------------
Key: SEQUOIA-1016
URL: https://forge.continuent.org/jira/browse/SEQUOIA-1016
Project: Sequoia
Type: Bug
Components: JDBC Driver
Versions: Sequoia 3.0 beta2
Environment: jboss 4.2 + mysql 5.45 + debian 4.0
Reporter: Hicham Bouabdallah
Sequoia mysql driver does not recognize mysql 5's INSERT IGNORE INTO syntax
Here's the exception:
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback;
uncategorized SQLException for SQL [ INSERT IGNORE INTO
class_section_grouping
(Uni_ID, Class_ID, Prof_Names) VALUES
(?, ?, ?)]; SQL state [null]; error code [0];
Message of cause: Unknown table '' in this INSERT statement: 'INSERT IGNORE
INTO class_section_grouping
(Uni_ID, Class_ID, Prof_Names) VALUES
(?, ?, ?)'; nested exception is
org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Message of
cause: Unknown table '' in this INSERT statement: 'INSERT IGNORE INTO
class_section_grouping
(Uni_ID, Class_ID, Prof_Names) VALUES
(?, ?, ?)'
Caused by:
org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Message of
cause: Unknown table '' in this INSERT statement: 'INSERT IGNORE INTO
class_section_grouping
(Uni_ID, Class_ID, Prof_Names) VALUES
(?, ?, ?)'
at
org.continuent.sequoia.driver.Connection.statementExecuteUpdate(Connection.java:2934)
at
org.continuent.sequoia.driver.Statement.executeUpdateWithSkeleton(Statement.java:574)
at
org.continuent.sequoia.driver.PreparedStatement.executeUpdate(PreparedStatement.java:183)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
at
org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:744)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:537)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:738)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:796)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:800)
at
com.cc.server.dao.impl.ClassDaoImpl.insertClassSectionGrouping(ClassDaoImpl.java:192)
at
com.cc.server.CCClassServiceImpl.runCreateProfessorQueries(CCClassServiceImpl.java:467)
at
com.cc.server.CCClassServiceImpl.access$200(CCClassServiceImpl.java:68)
at
com.cc.server.CCClassServiceImpl$5.doInTransaction(CCClassServiceImpl.java:805)
at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)
at
com.cc.server.CCClassServiceImpl.createClass(CCClassServiceImpl.java:798)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:528)
at
com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:265)
at
com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
com.cc.server.controller.ServletWrappingController.handleRequestInternal(ServletWrappingController.java:38)
at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:857)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:792)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:475)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:440)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.cc.server.arch.filters.ResponseHeaderFilter.doFilter(ResponseHeaderFilter.java:32)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.cc.server.arch.filters.ResponseHeaderFilter.doFilter(ResponseHeaderFilter.java:32)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:619)
Caused by:
org.continuent.sequoia.common.exceptions.driver.protocol.BackendDriverException:
Unknown table '' in this INSERT statement: 'INSERT IGNORE INTO
class_section_grouping
(Uni_ID, Class_ID, Prof_Names) VALUES
(?, ?, ?)'
SerializableStackTrace of each cause:
org.continuent.sequoia.common.exceptions.driver.protocol.BackendDriverException:
Unknown table '' in this INSERT statement: 'INSERT IGNORE INTO
class_section_grouping
(Uni_ID, Class_ID, Prof_Names) VALUES
(?, ?, ?)'
at
org.continuent.sequoia.controller.requests.InsertRequest.parse(InsertRequest.java:232)
at
org.continuent.sequoia.controller.cache.parsing.ParsingCache.getParsingFromCacheAndParseIfMissing(ParsingCache.java:298)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.getParsingFromCacheOrParse(RequestManager.java:366)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.scheduleExecWriteRequest(RequestManager.java:804)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.scheduleExecWriteRequest(DistributedRequestManager.java:1464)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate.executeScheduledRequest(DistributedStatementExecuteUpdate.java:84)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157)
at
org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335)
at
org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:102)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
