Re: ignite.net config (applying spring and .net config)

2018-08-30 Thread wt
by the way i am doing all this in Java -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: .net entity based configuration / datetime field error

2018-09-03 Thread wt
not sure if it helps but the odbc driver doesnt play nice with date fields and deals with them in binary format class org.apache.ignite.binary.BinaryInvalidTypeException your error looks to be related - have you tried the jdbc driver as a test? -- Sent from:

error starting Ignite -Failed to activate node components

2018-09-03 Thread wt
Ignition.start("C:igniteexamplesconfigpersistentstoreexample-persistent-store.xml"); "C:\Program Files\Java\jdk1.8.0_151\bin\java" "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.3\lib\idea_rt.jar=51729:C:\Program Files\JetBrains\IntelliJ IDEA

error after activating cluster - Failed to wait for completion of partition map exchange

2018-09-03 Thread wt
a Single node cluster starts fine. If i set it to active i get the following error popup (log file) [2018-09-03 13:54:45,187][INFO ][main][IgniteKernal%POC5] >>>__ >>> / _/ ___/ |/ / _/_ __/ __/ >>> _/ // (7 7// / / / / _/ >>>

Re: ignite .net programatically access cluster config (not working)

2018-09-26 Thread wt
I don't but looking to query what data regions exist on the cluster. Is there a way to do this from the client? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

ignite .net index group definition

2018-09-26 Thread wt
Hi In java a the index groups are defined in a way that makes sense e.g. @QuerySqlField(orderedGroups={@QuerySqlField.Group( name = "age_salary_idx", order = 0, descending = true)}) in .net however it looks like this [QuerySqlField(IsIndexed =true, IndexGroups = new[] {"someIndexGroup"})]

Re: ignite .net index group definition

2018-09-26 Thread wt
anyone? i have tried applying it like this but it just creates 2 indexes [QuerySqlField(IsIndexed = true, IndexGroups = new[] { "name=aa,order=1" })] My understanding is under the hood it is essentially btree index and these index structures require an ordinal column configuration to build

Re: ignite .net programatically access cluster config (not working)

2018-09-27 Thread wt
i am building a management tool that creates and manages caches and for this i wanted to be able to dynamically detect the data regions on the cluster -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

determine when client is connected

2018-09-26 Thread wt
the Isactive method only checks if the grid is active. is there a way to check when the client has connected to resume processing? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: .net decimal being stored as Other in ignite.

2018-09-20 Thread wt
thanks, just another FYI , the values in that column cut off anything after the decimal point while it is other so 3.456 becomes 3 for now we are storing as a string and casting to decimal when we query -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite Web Agent

2018-09-27 Thread wt
just an fyi - the data loader for the web agent is very slow. I was getting 10 rows per second throughput and nobody on here could really provide any assistance so we opted to write our own version of the tool that uses the data streamer which is loading 15k rows per second with persisted storage

ignite .net programatically access cluster config (not working)

2018-09-25 Thread wt
hi I have a single node cluster started with the following config when i launch a client and do Iignite.GetCluster().Configuration here is the screenshot of the config the client gets - the data storage config is null 2018-09-25_18-22-15.png

webconsole generated project - cache load performance

2018-09-14 Thread wt
Hi Is there a way to make the loading run faster for a project that has been generated by the web console. I am loading 4 million records and it is taking 30+ minutes -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

multiple tables in same cache - is it possible

2018-09-14 Thread wt
i have read that the preferred way is to have a cache per table. Is it however possible to have multiple tables in a single cache to make the administration of that cache simpler. what are the sort of problems that would surface if this were to be done? thanks -- Sent from:

Re: webconsole generated project - cache load performance

2018-09-15 Thread wt
I think I know what I need to do. I need to override the loadcache method and implement my own based on the example on the site. I think if I use generics I could parse in any class and it will handle the load. What's your thoughts on that? -- Sent from:

rmdbs integration readthrough - Ownership flag not set for binary property. Have you set 'keyFields' property of QueryEntity in programmatic or XML configuration?

2018-09-15 Thread wt
i have setup rmdbs integration with read-through if i query an empty cache it should read-through from the underlying system but that isn't happening i get the following error [16:43:35,351][SEVERE][client-connector-#56%StoxxDataLake%][JdbcRequestHandler] Failed to get parameters metadata

Re: webconsole generated project - cache load performance

2018-09-15 Thread wt
hi Initially this will be a single node demo but will be deployed as a 10 node cluster. I am running 2.6 and it is loading data from SQL server. There are 2 issues i am finding at the moment 1) it takes an hour to load but only loads 2.5k out of 4.6 million records (this seems serious) 2) it

.net decimal being stored as Other in ignite.

2018-09-18 Thread wt
i have the following class [QuerySqlField] public int vd { get; set; } [QuerySqlField] public long sharesinindex { get; set; } [QuerySqlField] public string name { get; set; } [QuerySqlField] public string isin { get; set; }

Re: .net decimal being stored as Other in ignite.

2018-09-19 Thread wt
anybody have any clue as to how Ignite is not mapping .Net decimal to Java.math.Bigdecimal? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

RE: key value cache - value size limits or concerns

2019-03-29 Thread wt
Hi SCott access will be driven by data loads on the other end. I am looking at odbc and rest access which will be used to load data into SQL server here is a base of how it will look class data { timespan loaddate string item string value } class alldata { list records } then when we

quick Q- date type in cache is converted to ticks. is this based on time since from 1970?

2019-03-29 Thread wt
-- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

key value cache - value size limits or concerns

2019-03-29 Thread wt
Is the following design appropriate or does it need reworking i want to build a key value store where the key is a company and the value is a list of data that will grow over time. The value data can contain thousands of items and these can change over time. My question is having a value for a

Can ODBC driver be used to query a key value cache?

2019-03-29 Thread wt
I have had a rather late change to a project that makes a db engine i am using not adequate. I wanted to see if Users can access data in a key value cache with the odbc driver or if i have to write a tool that uses the api or use rest -- Sent from:

Re: Can ODBC driver be used to query a key value cache?

2019-03-29 Thread wt
Thanks for the quick response Ilya. This is exactly what i am looking for -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Can Custom SQL functions get loaded after server start?

2019-02-28 Thread wt
The problem is it will work in java using the api but all my code is in .Net and unfortunately the .net api doesn't have any of the capability in it. I guess we could have a separate java app that does this. I tried to fudge it by compiling the same class with an additional function but it looks

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/

Can Custom SQL functions get loaded after server start?

2019-02-28 Thread wt
I am looking to build a capability to add new functions in without restarting the service. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

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

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

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

where can i find 2.7 nightly release build

2019-03-19 Thread wt
i need to access the odbc driver and have had problems building on windows at work. Thanks in advanced -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: where can i find 2.7 nightly release build

2019-03-19 Thread wt
Thanks Igor -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

ODBC Specified attribute is not supported

2019-03-19 Thread wt
Is there a reason the following error is returned by the odbc driver OLE DB provider "MSDASQL" for linked server "IGNITE" returned message "Specified attribute is not supported." I am trying to query the odbc driver from SQL server with 2.7. I can see the table, the query returns empty columns

<    1   2