performance of jdbc mode

dear ignite gurus, I have 2 questions about ignite jdbc: 1. why ignite creates two jdbc driver: jdbc thin vs. jdbc client node 2. I tried the jdbc client node driver lots of times on loading data from Oracle. it is about 6k+ rows. and the sql statement - "select xxx/count (*)" takes more ms

encounter issue on ignite 2.0

dear experts, I got the following error when start up my ignite 2.0 with exported cluster project: Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE INDEX PRIMARY[*] ON ""CartentriesCache_62_20_v1"".CARTENTRIES (""PK"" ASC, ""_KEY"" ASC) "; expected "identifier"; SQL s

Re: insert/update/delete issue in Version 1.8

Hi Denis, thank you. it works. I manually... added these line... something like " Set keyFlds = new HashSet<>(); keyFlds.add("pk"); qryEntity.setKeyFields(keyFlds); " after that , no more exception there. I am wondering... so I reviewed the "model" section of web console. it generates everythin

insert/update/delete issue in Version 1.8

dear experts: I got exception - "Caused by: java.lang.IllegalStateException: Ownership flag not set for binary property. Have you set 'keyFields' property of QueryEntity in programmatic or XML configuration? " when my code is following link of "https://apacheignite.readme.io/docs/jdbc-driver";. p

monitoring issue -Connection to Ignite Node is not established

dear experts: I am using ignite 1.8 with agent 1.7.4 after start the agent with default properties, I can import local db schema things into webconsole. but... the "monitoring clusters" function doesn't work. like below: in command line: [21:50:56,754][INFO ][EventThread][RestHandler] Failed co

Re: sample code for customised Partition logic

Hi Val, the reason is that "assignPartitions()" returns same "List>" usually even I start two ignite nodes. last Friday, I refactor it as below:[ @Override public List> assignPartitions(final AffinityFunctionContext affCtx) { final List nodes = affCtx.curr

sample code for customised Partition logic

Dear All, I can not find sample code for how customise partition... and I could almost finish it by myself. however, the most wired thing is it work occasionally !!?? most of time it doesn't work my code is:[ public class UCSRendezvousAffinityFunction extends RendezvousAffinityFunction {

how to verify the cached elements in each of partitions

Hi Experts, i implemented the customised partition thing like below: [ public class MattRendezvousAffinityFunction extends RendezvousAffinityFunction { .. public int partition(final Object key){ . //return 0 or 1 because I launch two nodes } } ] I feel I already

Re: beloved ignite vs. xxx: what is the actual status

Hi dsetrakyan , Thank you so much. I have told it to my colleagues. Now I would like to know the difference between GridGain prod and ignite... commerce vs. free, right? and the performance are different as well ? or same as each other? thanks. -- View this message in context: http://apache-i

beloved ignite vs. xxx: what is the actual status

Dear Experts, I am testing ignite functions for some weeks. although there are a number of bugs to be fix, I can successfully run it over DB, hiding some table from the cache by sql interaction with ignite. this is really cool. Now May I get some professional performance statistics, for example: r

Re: trouble about Underscore and Boolean

Hi Alexey, how is this issue going? could you share some updates for me? thanks~ -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/trouble-about-Underscore-and-Boolean-tp4840p4850.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: trouble about Underscore and Boolean

thanks your help. please refer to the following table schema:(you see...tinyint(1) columns are treated as Boolean :-( ) -- MySQL dump 10.13 Distrib 5.6.25, for osx10.8 (x86_64) -- -- Host: localhostDatabase: h5700ignite -- -- -- Server versi

trouble about Underscore and Boolean

dear experts, I meet troubles that very boring : trouble 1: I noticed that ignite generates fields without underscore... i.e. remove it if my table column : p_baseprice -> pBaseprice trouble2: ignite treats int(1) as Boolean how to indicate it as just integer??? please confirm if ignite is d

Re: How to start and use ignite in Tomcat

Hello experts~~~ my goal is to use ignite(in standalone server style) from tomcat webapp. And I am trying to start ignite client in web app owned logic(programming it, not by ServletContextListenerStartup), does it work? in my project, I want to hide one table (table in mysql DB) by putting

How to start and use ignite in Tomcat

Dear all, i searched a number of topics here. but still don't know how to start and use ignite (in client mode) from Tomcat you know, I launched the standalone ignite as server node. my code in tomcat web app like this:" this.ignite = Ignition.start(ClientConfigurationFactory.createConfigur

Re: ignite not support expression: EXISTS?

dear experts, still no response for this question. So I guess ignite currently doesn't support the "EXISTS". do we have any plan or jira# to track it so that we could implement it in a later version? thanks ~~ -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/igni

Re: ignite not support expression: EXISTS?

I would like to append more details now I realised there are two ways to query cache data: 1. by SqlFieldsQuery related approach 2. by "org.apache.ignite.IgniteJdbcDriver", which could give us standard ResultSet, it is really cool. so that we could treat ignite as a real in-memory DB, please

ignite not support expression: EXISTS?

dear experts, I knew ignite supports ANSI 99 SQL. but seemed not support expression: EXISTS... really? Our company sw uses this keyword lots of times. My testing sql is:" select * from products as a where exists(select * from productslp as b where a.pk=b.itempk and a.pcode='100124'); " and ignite

question about how to monitor ignite

I am using ignite to "select" lots of DB records into cache. after that, I want to follow the "To start Console Management & Monitoring run ignitevisorcmd.{sh|bat}". however, not get correct idea how to use it. the reason is that I ran ignite test from eclipse... and not xml Configuration File. so

Re: org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

super cool So before ver1.6, let me test more things about "SELECT". -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/org-apache-ignite-IgniteCheckedException-Failed-to-register-query-type-TypeDescriptor-tp3447p3579.html Sent from the Apache Ignite Users mailing

Re: org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

thank you.. it is very helpful.. and the web console is cool~ after this issue, May I ask one more question about how to write to cache with sql string. I read the "https://apacheignite.readme.io/v1.5/docs/persistent-store";. however, there is no clear code how to run "update or delete "