Setting up Ignite node inside JBOSS 6 container

2015-08-16 Thread aosmakoff
Extending our existing web application to have access to an Ignite cache/compute grid, we need to set up a node withing this application and deploy it to JBOSS6.# container. The server box does not have Ignite installed separately and does not have IGNITE_HOME defined. In this case the call to /Ign

Re: AWS Integration

2015-08-16 Thread aosmakoff
Hi Guys. I can confirm now that your suggested approach did work well and we now have a grid running in AWS using S3 as IP facilitator. The only obstacle we had was with S3Finder supplied with Ignite. It assumes the access to the root of the file structure in S3. This is not always the case (not in

Re: ExecutorService clarification

2015-08-16 Thread hueb1
Hi Val, I ran a test where I set two nodes on two EC2s to have thread pool size of 1. I then used the ExcecutorService to kick off about 100 jobs. I could see the results being printed on the two nodes. I then fired up a new node on a new EC2 and saw it join the cluster. I was expecting to see

Re: ExecutorService clarification

2015-08-16 Thread hueb1
Hi Val, I ran a test where I set two nodes on two EC2s to have thread pool size of 1. I then used the ExcecutorService to kick off about 100 jobs. I could see the results being printed on the two nodes. I then fired up a new node on a new EC2 and saw it join the cluster. I was expecting to see

OFFSET clause in SQL query

2015-08-16 Thread alex.glau
Hi, Do you support OFFSET clause in SQL query? I tried query with WHERE criteria and LIMIT that worked fine but after I added OFFSET the result is empty. I got execution plan like the following: [SELECT SHIPMENT.NAME AS __C0, SHIPMENT.STATUS AS __C1, SEGMENT.STARTSITENAME AS __C2 FROM

Re: Performance of join SQL queries

2015-08-16 Thread alex.glau
Sorry for bombing you with emails but I discovered one more thing that may help to understand the problem I posted two mails before: I returned to group index including 'status' and 'startDate' and found that queries with conditions like followed works fine (I run that in H2 Console): select coun

Re: Performance of join SQL queries

2015-08-16 Thread alex.glau
Sergi, 1) One additional information to my previous mail: It looks like the problem is in criteria startDate > ?2. I add another field to group index and executed query that includes to equal criteria (status=?1 and startSiteName=?2) and it worked fine. 2) I wanted to execute queries in H2 Conso

Re: Performance of join SQL queries

2015-08-16 Thread alex.glau
Hi Sergi, Unfortunately I am still fighting with group index. 1) After i corrected group index annotations it is built correctly (I see it in H2 Console) 2) The execution looks correct [SELECT COUNT(*) AS __C0 FROM "ShipmentCache".CACHEDSHIPMENT /* "ShipmentCache"."group_shipment": STATU