Hi Damien,
REPLACE INTO is another MySQL specific extension that is not part of the
SQL standard.
You should be able to work around that by modifying the regular
expression in SequoiaRequestRegExp as follows:
private static final String INSERT_REQUEST_PATTERN_STRING =
"^(insert|replace).*";
Rebuild the jars (with 'ant jar') and you should be all set.
Keep us posted with your progress,
Emmanuel
> On magento there is a search field that return me nothing even if I am
> sure an item exists ...
>
> I get this error on the sequoia side (I searched the word 'MARTINIQUE'):
> The request does not use any procedures as I can read it.
>
> [15:57:11] ERROR
> [org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler] - Error
> processing query: REPLACE INTO `catalogsearch_result` (SELECT '5',
> `product_id`, MATCH (`data_index`) AGAINST ('MARTINIQUE' IN BOOLEAN MODE)
> FROM `catalogsearch_fulltext` WHERE ((`data_index` LIKE '%MARTINIQUE%'))
> AND `store_id`='1')
> org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
> Message of cause: RETURN_GENERATED_KEYS is not supported for stored
> procedures
> at
> org.continuent.sequoia.driver.Connection.statementExecuteUpdateWithKeys(Connection.java:3111)
> at
> org.continuent.sequoia.driver.Statement.executeUpdateWithSkeleton(Statement.java:583)
> at
> org.continuent.sequoia.driver.Statement.executeUpdate(Statement.java:557)
> at org.continuent.sequoia.driver.Statement.execute(Statement.java:1123)
> at org.continuent.sequoia.driver.Statement.execute(Statement.java:459)
> at
> org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler.processQuery(MySQLProtocolHandler.java:455)
> at
> org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler.processCommand(MySQLProtocolHandler.java:230)
> at
> org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler.processClientPacket(MySQLProtocolHandler.java:186)
> at
> org.continuent.myosotis.protocol.mysql.MySQLConnectionHandler.run(MySQLConnectionHandler.java:85)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
> at java.lang.Thread.run(Thread.java:595)
> Caused by:
> org.continuent.sequoia.common.exceptions.driver.protocol.ControllerCoreException:
> RETURN_GENERATED_KEYS is not supported for stored procedures
> SerializableStackTrace of each cause:
> org.continuent.sequoia.common.exceptions.driver.protocol.ControllerCoreException:
> RETURN_GENERATED_KEYS is not supported for stored procedures
> at
> org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackTrace(SequoiaException.java:103)
> at java.lang.Throwable.<init>(Throwable.java:196)
> at java.lang.Exception.<init>(Exception.java:41)
> at
> org.continuent.sequoia.common.exceptions.SequoiaException.<init>(SequoiaException.java:57)
> at
> org.continuent.sequoia.common.exceptions.BadJDBCApiUsageException.<init>(BadJDBCApiUsageException.java:54)
> at
> org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.statementExecuteUpdateWithKeys(VirtualDatabaseWorkerThread.java:2378)
> at
> org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.java:457)
>
>
>
>
> Again, according to you, is it reasonable to get magento working with a
> sequoia cluster yet ?
>
> Cheers,
>
>
--
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
