ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergi Vladykin <sergi.vlady...@gmail.com>
Subject Re: How to use H2 database functions in the Sql query using .Net APIs
Date Tue, 28 Feb 2017 12:29:38 GMT
Sorry, right now Ignite uses an older H2 version. I hope we will be able to
upgrade it soon, but for now you can go with user defined functions [1].

[1]
https://ignite.apache.org/releases/1.8.0/javadoc/org/apache/ignite/cache/query/annotations/QuerySqlFunction.html

Sergi

2017-02-28 15:13 GMT+03:00 mrinalkamboj <mrinal.technology@gmail.com>:

> 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.
>

Mime
View raw message