Re: ignite.net custom sql functions

2019-02-28 Thread wt
That works - super happy with the result you are always so helpful thank you Ilya -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: ignite.net custom sql functions

2019-02-28 Thread Ilya Kasnacheev
Hello! It does not seem that you define any tables for this cache, but 0: jdbc:ignite:thin://localhost> SELECT "wayne".square(4); ++ | "wayne".SQUARE(4)| ++ | 16 | +--

Re: ignite.net custom sql functions

2019-02-28 Thread wt
I don't know why i didn't think of that - superb thanks Ilya. Are you certain the function needs to be in libs\home - It can't seem to find the function and i would have expected to at least see something in the log about loading it. ENV setup system variable IGNITE_HOME = c:\Ignite_2.7 test f

Re: ignite.net custom sql functions

2019-02-28 Thread Ilya Kasnacheev
Hello! I think you can refer to functions as "schemaName".function() This means you can create a single cache with known schema and all the functions, always refer to it. Regards, -- Ilya Kasnacheev чт, 28 февр. 2019 г. в 11:29, wt : > one question regarding this configuration. I noticed it i

Re: ignite.net custom sql functions

2019-02-28 Thread wt
I have just realized an issue with this process. I have built my own version of the web console that generates caches for tables in databases. This is an automated process in the UI so i do not know what additional caches will be created beforehand. This leaves me with the dilemma of this custom fu

Re: ignite.net custom sql functions

2019-02-28 Thread wt
one question regarding this configuration. I noticed it is cache specific and to me that implies every cache will need to have this configuration section set. Is there perhaps a way to configure this globally once instead of replicating it for every cache? -- Sent from: http://apache-ignite-user

Re: ignite.net custom sql functions

2019-02-28 Thread wt
Thank you both for your assistance here, it is greatly appreciated - Ignite Rocks -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: ignite.net custom sql functions

2019-02-27 Thread Ilya Kasnacheev
Hello! > I have found several examples in java code for registering the custom function but nothing showing how to do it in the xml config file. // Preparing a cache configuration.CacheConfiguration cfg = new CacheConfiguration(); // Registering the class that contains custom SQL functions.cfg.se

Re: ignite.net custom sql functions

2019-02-27 Thread Pavel Tupitsyn
Hi Wayne, You can write a service in Java that registers custom SQL function. Then call that service from .NET. Classpath is provided in IgniteConfiguration.JvmClasspath. See https://ptupitsyn.github.io/Ignite-Plugin/ to get some idea on how to combine Java-based Ignite stuff with Ignite.NET. Let

Re: ignite.net custom sql functions

2019-02-27 Thread wt
Thanks Ilya So i need a little guidance here if you don't mind i am just throwing together a quick test as a precursor to a new project. I have a .net ignite service wrapper var cfg = new IgniteConfiguration() { SpringConfigUrl = "/ignitecfg.xml",

Re: ignite.net custom sql functions

2019-02-27 Thread Ilya Kasnacheev
Hello! They are not supported yet. However, you can still configure your caches to use Java custom functions and use them even if the rest of your project is .Net. I assume that functions are usually self-contained. Regards, -- Ilya Kasnacheev ср, 27 февр. 2019 г. в 12:13, wt : > good day >

ignite.net custom sql functions

2019-02-27 Thread wt
good day I can't seem to find anything on the .net api for custom sql functions. Can anyone tell me if it is possible in .net as it is here in Java https://apacheignite-sql.readme.io/docs/custom-sql-functions Thanks Wayne -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/