I am trying to use the following query from the .Net client: *select _key,OrderId, OrderName, OrderDateTime, OrderValue, OrderAddress from OrderEntity Where REGEXP_LIKE(OrderAddress,?)*
Where for the placeholder ?, I supply the valid Regular expression, but following is exception generated: *Caused by: org.h2.jdbc.JdbcSQLException: Function "REGEXP_LIKE" not found; SQL statement: select _key,OrderId, OrderName, OrderDateTime, OrderValue, OrderAddress from OrderEntity Where REGEXP_LIKE(OrderAddress,?)* I can use the Like operator effectively, as follows, but that's not enough I need to do complex regex mapping *select OrderId, OrderName, OrderDateTime, OrderValue, OrderAddress from OrderEntity Where OrderAddress like '%' || ?* This also seems to be the case for other H2 database functions available at the following link http://www.h2database.com/html/functions.html -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-use-H2-database-functions-in-the-Sql-query-using-Net-APIs-tp10939.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
