Hello, 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 -- Damien > > Hello, > > It seams that myosotis/sequoia can't support the MySQL statment "START > TRANSACTION" as documented in > http://dev.mysql.com/doc/refman/5.0/en/commit.html and support only > "BEGIN" as begining of a transaction (always in my 2.10.10 sequoia > version). > > But php extention mysqli use this statement in the > mysqli_autocommit(false); function/method used in the magento project (php > e-business plateform). > > Cheers, > > -- > Damien Hardy > _______________________________________________ > Sequoia mailing list > Sequoia@lists.forge.continuent.org > http://forge.continuent.org/mailman/listinfo/sequoia > > _______________________________________________ Sequoia mailing list Sequoia@lists.forge.continuent.org http://forge.continuent.org/mailman/listinfo/sequoia
