RE: Ignite cache TTL and SQL query

Hi Denis, Thanks for your reply. I am asking about SQL query in Ignite. And I set PostgreSQL for Ignite to store data on disk. Now I know this question is still unresolved. Thanks. From: Denis Mekhanikov [mailto:dmekhani...@gmail.com] Sent: Tuesday, February 27, 2018 10:22 PM To: user@ignite.a

Re: SortedEvictionPolicy doesn't work as expected

No, It's not like that. You can access any entry from any node, but access time will be different. If an entry is stored on a different node, Ignite will make a network request to that node and return it to you. If the entry is available locally, then the access time will be lower. And if you conf

Re: Apache Ignite & unixODBC and truncating text

Yes, Here is my libignite-odvc.so. Command "ldd /usr/local/lib/libignite-odbc.so" show: linux-vdso.so.1 (0x7fff18aad000) libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x7f96a60f7000) libignite-binary-2.5.0.26265.so.0 => not found libodbcinst.so.2 => /usr/

Re: Is there any implementating way to use eclipselink, jpql (em.createQuery ) with ignite?

and change the query to use CacheTestObject, CacheTestObject cacheTestObject = (CacheTestObject)em.createQuery("SELECT v FROM CacheTestObject v WHERE ").getSingleResult(); -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Is there any implementating way to use eclipselink, jpql (em.createQuery ) with ignite?

Found a solution for that, modifying entity class to add @Table annotation works, @Entity @Table(name = "CACHETEST.CACHETEST") public class CacheTestObject implements Serializable { -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Is there any implementating way to use eclipselink, jpql (em.createQuery ) with ignite?

I'm trying out some basic jpql to the given github project, int i = em.createQuery(" SELECT c FROM CACHETEST.CACHETEST c ").getMaxResults(); but getting below exception, Exception in thread "main" java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager:

Thread got interrupted while trying to acquire table lock & Got interrupted while waiting for future to complete

I am getting the below mentioned exception when I use the below snippet to read records in cache and update. How to avoid interruption? The atomicity mode has to be transactional. I read the below links related to this. https://apacheignite.readme.io/docs/thread-pools https://apacheignite.readm

Re: Is there any implementating way to use eclipselink, jpql (em.createQuery ) with ignite?

Thank you ezhuravlev. It's working -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: SortedEvictionPolicy doesn't work as expected

So, that means even if I have a local cache with SortedEvictionPolicy configured and OnHeap enabled, it's still impossible to get the entries from a distributed partition cache, because the source cache is not centralized. And finally, the solution is to set a standalone SortedMap via RemoteEventL

Re: SortedEvictionPolicy doesn't work as expected

Marco, If you access some records, that are stored in the off-heap memory, then you have to wait, while Ignite is deserializing the data and copying it to Java heap. But if the needed entry is already available in Java heap, Ignite doesn't have to perform these steps to return the result, it can j

Re: SortedEvictionPolicy doesn't work as expected

Hi Denis, Thank you for the response, I appreciate it. Yes, I agree with you, it could be done by various solutions, 'REST', 'Event Listener' or any standalone instance. According to the new design you mentioned, ignite stop the support of '/setMemoryMode(CacheMemoryMode.ONHEAP_TIERED)/' use Off-

Re: How to configure a cluster as a persistent, replicated SQL database

Hey Denis, I think that we are making progress... I am now connecting to the database successfully, but when I submit a query, I get the following error: My config contains the following: /...

Re: How to configure a cluster as a persistent, replicated SQL database

Jose, You can use an XML file, that you use to start server nodes, as ignite-jdbc.xml in the connection string. The client node will be started automatically by the JDBC driver. Denis ср, 28 февр. 2018 г. в 19:32, joseheitor : > Thanks, Denis - this makes a lot of sense... > > Can you provide a

Re: How to configure a cluster as a persistent, replicated SQL database

Thanks, Denis - this makes a lot of sense... Can you provide a sample ignite-jdbc.xml config file for reference? And any details about the config parameters for such a config file...? Also, must a 'Client' mode node be explicitly started prior to making a connection? Or does this happen in the ba

Re: How to configure a cluster as a persistent, replicated SQL database

Jose, >As usual, my JDBC connection points to the local node (where I am activating >the cluster on), but does not connect to the cluster port (11211) only to >the default 10800 port. 11211 is a connector port, which serves a different purpose. By default JDBC connections are accepted on port 108

Re: Apache Ignite & unixODBC and truncating text

The results for me for the code you provided: array(14) { ["ID"]=> string(1) "0" [0]=> string(1) "0" ["USERKEY"]=> string(73) "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do elit, sed" [1]=> string(73) "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed d

Re: Apache Ignite & unixODBC and truncating text

I'm try to execute fallowing code: setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = 'CREATE TABLE IF NOT EXISTS test_md5 (id int PRIMARY KEY, userkey LONGVARCHAR, server LONGVARCHAR, tsession LONGVARCHAR, tpost LONGVARCHAR, tget LONGVARCHAR, adddate i

Re: How to configure a cluster as a persistent, replicated SQL database

Hi Denis, I have now launched the 3 nodes on different boxes, and listed their addresses in each config. The nodes seem to be aware of each other, as I notice the topology updating when I bring additional nodes online/offline. As usual, my JDBC connection points to the local node (where I am act

Re: Apache Ignite & unixODBC and truncating text

hat before I had truncated string and now I have NULL when I > try to add more longer string. > > My Ignite version is: Ignite ver. > 2.5.0-SNAPSHOT#20180228-sha1:6641267df826e74213c9921e1d0c3490f09aae45 > > When I added string I have fallowing console logs: > > [28-02-2018

Re: Apache Ignite & unixODBC and truncating text

Hello, So, I was testing today fix of this bug and well... I have similar error. Different is that before I had truncated string and now I have NULL when I try to add more longer string. My Ignite version is: Ignite ver. 2.5.0-SNAPSHOT#20180228-sha1:6641267df826e74213c9921e1d0c3490f09aae45 When

Re: OutOfMemoryError

Hi Juan, Sorry for the late response. 1. At first glance, I could not find anything suspicious in cache configuration you provided. I don't still quite understand the reason for using XX:MaxDirectMemorySize flag. Ignite does not require it. Could you please clarify this moment? Is it a requiremen

Re: Spark 'close' API call hangs within ignite service grid

I don't see anything suspicious in the log. Can you submit a project with a reproducer to GitHub or attach to this thread? Denis ср, 28 февр. 2018 г. в 8:52, akshaym : > Hi, I have updated my post. In short when I call spark.close() inside > ignite > service it hangs and call never returns. > >

Re: Is there any implementating way to use eclipselink, jpql (em.createQuery ) with ignite?

Hi, Here is the project on github with using eclipselink with Ignite: https://github.com/ezhuravl/ignite-eclipselink-example Evgenii 2018-02-28 13:43 GMT+03:00 attpasu1 : > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >

Is there any implementating way to use eclipselink, jpql (em.createQuery ) with ignite?

-- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: SortedEvictionPolicy doesn't work as expected

Marco, There is no way to perform "get" operations on heap entries solely, as far as I know. Looks like you are trying to miss-use a Java heap cache. What you need can be achieved by using some tree data structure like Java TreeSet. Every time you insert something into cache, you can update this

Re: How to configure a cluster as a persistent, replicated SQL database

Jose, Actually, there is no such node, that is responsible for all data, stored in the cluster. The data is distributed across all nodes instead, so each node is responsible for some particular piece. Cache data is split into partitions (1024 for a partitioned cache and 512 for replicated by defau