Hi Damien, You have to update the regular expression for BEGIN in the org.continuent.sequoia.driver.SequoiaJDBCRegExp class. Replace: private static final String BEGIN_PATTERN_STRING = "^begin.*"; with private static final String BEGIN_PATTERN_STRING = "^(begin|start\\s+transaction).*";
That should properly convert 'start transaction' to a setAutoCommit(false) in the driver. Note that if you are using Myosotis, this should be done by Myosotis. If it does not work, please post a message on the Myosotis mailing list. Hope this helps, Emmanuel > To be more precise here is the error I obtain with the sql client within > the sequoia console : > > jdbc:sequoia://.../magento?alwaysGetGeneratedKeys=true&preferredController=roundRobin > (magento) > START TRANSACTION; > An error occured while executing SQL query > (org.continuent.sequoia.common.exceptions.driver.DriverSQLException: > Message of cause: Request START TRANSACTION;/ failed on backend db1 (Error > while building Sequoia ResultSet (ResultSet is from UPDATE. No Data.))) > > Whereas It work as expected with "BEGIN" : > > jdbc:sequoia://.../magento?alwaysGetGeneratedKeys=true&preferredController=roundRobin > (magento) > begin > Transaction started > > No idea about this problem ? > > Is it reasonable to aim to make magento working over sequoia with a mysql > cluster ? > > Thanks. > > Best regards > > -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: m...@frogthinker.org Skype: emmanuel_cecchet _______________________________________________ Sequoia mailing list Sequoia@lists.forge.continuent.org http://forge.continuent.org/mailman/listinfo/sequoia
