Re: TC access

2016-06-27 Thread Alexey Kuznetsov
Hmmm,...

Seems NO. I searched over web site and wiki and not found anything.
We could ask Anton as the most experienced person to add appropriate page
to wiki.

On Tue, Jun 28, 2016 at 12:02 PM, Dmitriy Setrakyan  wrote:

> Alexey, is this documented?
>
>
>
> On Jun 27, 2016, at 9:33 PM, Alexey Kuznetsov 
> wrote:
>
> Alexandre,
>
> If you need to test your PR with existing tests just:
>  1. Go to http://ci.ignite.apache.org
>  2. Register if needed /  Loging.
>  3. Select appropriate test / all tests and run them with specifying
> number of your PR.
>
> If you are going to add new tests you need admin privileges for that.
> I think Anton can help with this.
>
>
> On Tue, Jun 28, 2016 at 2:04 AM, Alexandre Boudnik <
> alexander.boud...@gmail.com> wrote:
>
>> I don't need access to TC console, I need to have my pull requests tested.
>> Take care,
>> Alexandre "Sasha" Boudnik
>>
>> call me via Google Voice:
>> 1(405) BUDNIKA
>> 1(405) 283-6452
>>
>>
>>
>> On Mon, Jun 27, 2016 at 2:07 PM, Dmitriy Setrakyan
>>  wrote:
>> > I just realized that I don’t have a link either. Anton, do you mind
>> adding
>> > the link to TC to the community dropdown on the website?
>> >
>> > On Mon, Jun 27, 2016 at 10:28 AM, Alexandre Boudnik
>> >  wrote:
>> >>
>> >> Hello,
>> >>
>> >> In order to use Ignite's TeamCity, could you provide myself with
>> access to
>> >> it?
>> >>
>> >> Take care,
>> >> Alexandre "Sasha" Boudnik
>> >>
>> >> call me via Google Voice:
>> >> 1(405) BUDNIKA
>> >> 1(405) 283-6452
>> >
>> >
>>
>
>
>
> --
> Alexey Kuznetsov
> GridGain Systems
> www.gridgain.com
>
>


-- 
Alexey Kuznetsov
GridGain Systems
www.gridgain.com


Re: TC access

2016-06-27 Thread Dmitriy Setrakyan
Alexey, is this documented?



> On Jun 27, 2016, at 9:33 PM, Alexey Kuznetsov  wrote:
> 
> Alexandre,
> 
> If you need to test your PR with existing tests just:
>  1. Go to http://ci.ignite.apache.org
>  2. Register if needed /  Loging.
>  3. Select appropriate test / all tests and run them with specifying number 
> of your PR.
> 
> If you are going to add new tests you need admin privileges for that.
> I think Anton can help with this.
> 
> 
>> On Tue, Jun 28, 2016 at 2:04 AM, Alexandre Boudnik 
>>  wrote:
>> I don't need access to TC console, I need to have my pull requests tested.
>> Take care,
>> Alexandre "Sasha" Boudnik
>> 
>> call me via Google Voice:
>> 1(405) BUDNIKA
>> 1(405) 283-6452
>> 
>> 
>> 
>> On Mon, Jun 27, 2016 at 2:07 PM, Dmitriy Setrakyan
>>  wrote:
>> > I just realized that I don’t have a link either. Anton, do you mind adding
>> > the link to TC to the community dropdown on the website?
>> >
>> > On Mon, Jun 27, 2016 at 10:28 AM, Alexandre Boudnik
>> >  wrote:
>> >>
>> >> Hello,
>> >>
>> >> In order to use Ignite's TeamCity, could you provide myself with access to
>> >> it?
>> >>
>> >> Take care,
>> >> Alexandre "Sasha" Boudnik
>> >>
>> >> call me via Google Voice:
>> >> 1(405) BUDNIKA
>> >> 1(405) 283-6452
>> >
>> >
> 
> 
> 
> -- 
> Alexey Kuznetsov
> GridGain Systems
> www.gridgain.com


Re: Re: argument type mismatch of oracle TIMESTAMP field when call loadCache

2016-06-27 Thread hu...@neusoft.com
hi, Alexey

First, thanks your reply.

My oracle version is 12.1.0.1.0, the ddl script is the following:

CREATE TABLE "UIGNITE"."KC21" 
   ( "AKB020" VARCHAR2(20) NOT NULL ENABLE, 
"AKC190" VARCHAR2(24) NOT NULL ENABLE, 
"AAC001" NUMBER(20,0) NOT NULL ENABLE, 
"AAZ500" VARCHAR2(50), 
"AKA130" VARCHAR2(3) NOT NULL ENABLE, 
"AAB001" NUMBER(20,0), 
"AKA101" VARCHAR2(3), 
"BKC192" TIMESTAMP (6), 
"AKC193" VARCHAR2(50), 
"BKC231" VARCHAR2(300), 
"BKC194" TIMESTAMP (6), 
"AKC195" VARCHAR2(3), 
"AKC196" VARCHAR2(50), 
"BKC232" VARCHAR2(300), 
"BKC317" VARCHAR2(3), 
"AKA151" FLOAT(126), 
"AKC021" VARCHAR2(3), 
"BKC021" VARCHAR2(3), 
"BKC197" VARCHAR2(3), 
"BKC120" VARCHAR2(3), 
"BKC128" VARCHAR2(3), 
"BKC126" VARCHAR2(3), 
"BAE073" VARCHAR2(16), 
"AKE013" VARCHAR2(3), 
"BKC023" VARCHAR2(3), 
"AAA027" VARCHAR2(6), 
"BKC378" VARCHAR2(50), 
"BKC379" VARCHAR2(50), 
"BKC380" VARCHAR2(50), 
"BKC381" VARCHAR2(50), 
"AAB034" VARCHAR2(16), 
"BAC888" VARCHAR2(16), 
"AAB301" VARCHAR2(16), 
"BKC390" VARCHAR2(20), 
"BKC500" VARCHAR2(30), 
"BKA130" VARCHAR2(3), 
"AKB021" VARCHAR2(200), 
"BKF050" VARCHAR2(20), 
"AKC273" VARCHAR2(50), 
"AKF002" VARCHAR2(100), 
"AMC020" TIMESTAMP (6), 
"AKE021" VARCHAR2(20), 
"AKE020" VARCHAR2(20), 
"BKC191" VARCHAR2(20), 
"BKC190" VARCHAR2(20), 
"AAE017" VARCHAR2(50), 
"AAE032" TIMESTAMP (6), 
"AAC999" VARCHAR2(16), 
"AAE135" VARCHAR2(20), 
"AAC003" VARCHAR2(50), 
"AAC004" VARCHAR2(3), 
"BAE450" NUMBER(20,0), 
"AAB999" VARCHAR2(16), 
"AAB004" VARCHAR2(500), 
"AAB019" VARCHAR2(3), 
"AAB020" VARCHAR2(3), 
"BKC233" VARCHAR2(2048), 
"BAE013" VARCHAR2(100), 
"BKC319" VARCHAR2(3), 
"AAE013" VARCHAR2(200), 
"BKC050" VARCHAR2(3), 
"BKC051" VARCHAR2(3), 
"BKC052" VARCHAR2(200), 
"BKC053" VARCHAR2(200), 
"BKC054" VARCHAR2(200), 
"BAZ001" NUMBER(20,0), 
"BAZ002" NUMBER(20,0), 
"BZE011" VARCHAR2(50), 
"BZE036" TIMESTAMP (6), 
"AAE011" VARCHAR2(50), 
"AAE036" TIMESTAMP (6), 
"AAE100" VARCHAR2(3), 
"BKC055" VARCHAR2(3), 
"BKC056" VARCHAR2(3), 
"BKC057" VARCHAR2(3), 
"BKC058" VARCHAR2(3), 
"BKB010" VARCHAR2(3), 
"BKB011" VARCHAR2(3), 
"BKC059" VARCHAR2(50), 
"BKC060" FLOAT(126), 
"BKC280" VARCHAR2(50), 
"BKC281" VARCHAR2(50), 
"BKC282" VARCHAR2(50), 
"BKC283" VARCHAR2(50), 
"BKC284" VARCHAR2(50), 
"BKE160" VARCHAR2(3), 
"BKE161" VARCHAR2(50), 
"BKE162" TIMESTAMP (6), 
"BKC401" VARCHAR2(3), 
"BKC285" VARCHAR2(300), 
"BKC286" VARCHAR2(300), 
"BKC287" VARCHAR2(100), 
"BKC288" VARCHAR2(200), 
"BKC289" VARCHAR2(50), 
"BKC290" VARCHAR2(50), 
"BKC291" FLOAT(126), 
"BKC292" FLOAT(126), 
"BAB024" VARCHAR2(200), 
"AAE009" VARCHAR2(200), 
"AAE010" VARCHAR2(200), 
 CONSTRAINT "pk_kc21" PRIMARY KEY ("AKB020", "AKC190")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "IGNITE"  ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "IGNITE" 



胡永亮
 
bob
 
From: Alexey Kuznetsov
Date: 2016-06-28 10:50
To: user@ignite.apache.org
Subject: Re: argument type mismatch of oracle TIMESTAMP field when call 
loadCache
Hi, Bob!

Could post here a sample table script that help us to reproduce the problem?
Something like "create table test ()".

Also, just in case please specify your Oracle version.

Thanks!

-- 
Alexey Kuznetsov


Re: TC access

2016-06-27 Thread Alexey Kuznetsov
Alexandre,

If you need to test your PR with existing tests just:
 1. Go to http://ci.ignite.apache.org
 2. Register if needed /  Loging.
 3. Select appropriate test / all tests and run them with specifying number
of your PR.

If you are going to add new tests you need admin privileges for that.
I think Anton can help with this.


On Tue, Jun 28, 2016 at 2:04 AM, Alexandre Boudnik <
alexander.boud...@gmail.com> wrote:

> I don't need access to TC console, I need to have my pull requests tested.
> Take care,
> Alexandre "Sasha" Boudnik
>
> call me via Google Voice:
> 1(405) BUDNIKA
> 1(405) 283-6452
>
>
>
> On Mon, Jun 27, 2016 at 2:07 PM, Dmitriy Setrakyan
>  wrote:
> > I just realized that I don’t have a link either. Anton, do you mind
> adding
> > the link to TC to the community dropdown on the website?
> >
> > On Mon, Jun 27, 2016 at 10:28 AM, Alexandre Boudnik
> >  wrote:
> >>
> >> Hello,
> >>
> >> In order to use Ignite's TeamCity, could you provide myself with access
> to
> >> it?
> >>
> >> Take care,
> >> Alexandre "Sasha" Boudnik
> >>
> >> call me via Google Voice:
> >> 1(405) BUDNIKA
> >> 1(405) 283-6452
> >
> >
>



-- 
Alexey Kuznetsov
GridGain Systems
www.gridgain.com


ignite group indexing not work problem

2016-06-27 Thread Zhengqingzheng
Hi there,
My  ignite in-memory sql query is very slow. Anyone can help me to figure out 
what was wrong?

I am using group indexing to speed up in-memory sql queries. I notice that my 
sql query took 2274ms (data set size: 10Million, return result:1).

My query is executed as:
String qryStr = "select * from UniqueField where oid= ? and fnum= ? and num= ?";

String oId="a343";
int fNum = 3;
BigDecimal num = new BigDecimal("51002982136");

IgniteCache cache = 
igniteMetaUtils.getIgniteCache(IgniteMetaCacheType.UNIQUE_INDEX);  // to get 
selected cache ,which has been created in some other place

SqlQuery qry = new SqlQuery(UniqueField.class, qryStr);
qry.setArgs(objId,fieldNum, numVal);
long start = System.currentTimeMillis();
List result= cache.query(qry).getAll();
long end = System.currentTimeMillis();
System.out.println("Time used in query :"+ (end-start)+"ms");

And the result shows: Time used in query :2274ms

I have set group indexes, and the model is defined as:
import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;

import org.apache.ignite.cache.query.annotations.QuerySqlField;

public class UniqueField implements Serializable
{

@QuerySqlField
private String orgId;

@QuerySqlField(
orderedGroups={
@QuerySqlField.Group(
name="oId_fNum_ msg ", order=1, descending = true),
@QuerySqlField.Group(
name="oId_fNum_ num ", order=1, descending = true),
@QuerySqlField.Group(
name="oId_fNum_ date ", order=1, descending = true)

})
private String oId;

@QuerySqlField(index=true)
private String gId;

 @QuerySqlField(
orderedGroups={
@QuerySqlField.Group(
name="oId_fNum_ msg ", order=2, descending = true),
@QuerySqlField.Group(
name="oId_fNum_ num ", order=2, descending = true),
@QuerySqlField.Group(
name="oId_fNum_ date ", order=2, descending = true)

})
private int fNum;

@QuerySqlField(index=true, @QuerySqlField.Group(
name="oId_fNum_ msg ", order=3, descending = true)})
private String msg;

@QuerySqlField(index=true, @QuerySqlField.Group(
name="oId_fNum_ num ", order=3, descending = true)})
private BigDecimal num;

@QuerySqlField(index=true, @QuerySqlField.Group(
name="oId_fNum_ date ", order=3, descending = true)})
private Date date;

public UniqueField(){};

public UniqueField(
String orgId,
String oId,
String gId,
int fNum,
String msg,
BigDecimal num,
Date date
){
this.orgId=orgId;
this.oId=oId;
this.gId = gId;
this.fNum = fNum;
this.msg = msg;
this.num = num;
this.date = date;
}

public String getOrgId()
{
return orgId;
}

public void setOrgId(String orgId)
{
this.orgId = orgId;
}

public String getOId()
{
return oId;
}

public void setOId(String oId)
{
this.oId = oId;
}

public String getGid()
{
return gId;
}

public void setGuid(String gId)
{
this.gId = gId;
}

public int getFNum()
{
return fNum;
}

public void setFNum(int fNum)
{
this.fNum = fNum;
}

public String getMsg()
{
return msg;
}

public void setMsg(String msg)
{
this.msg = msg;
}

public BigDecimal getNum()
{
return num;
}

public void setNum(BigDecimal num)
{
this.num = num;
}

public Date getDate()
{
return date;
}

public void setDate(Date date)
{
this.date = date;
}

}






Re: argument type mismatch of oracle TIMESTAMP field when call loadCache

2016-06-27 Thread Alexey Kuznetsov
Hi, Bob!

Could post here a sample table script that help us to reproduce the problem?
Something like "create table test ()".

Also, just in case please specify your Oracle version.

Thanks!

-- 
Alexey Kuznetsov


Re: Creating cache with CacheLoaderFactory on client node brings exception org.apache.ignite.IgniteCheckedException: Failed to find class with given class loader for unmarshalling (make sure same ver

2016-06-27 Thread bintisepaha
Are our nodes running the same JDK version?



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Creating-cache-with-CacheLoaderFactory-on-client-node-brings-exception-org-apache-ignite-IgniteCheck-tp5915p5938.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.


Re: Calling serviceDescriptiors after service deployment throws exception

2016-06-27 Thread vkulichenko
Hi,

This happens because you save Ignite instance in the service and it then
can't be deserialized in the user thread. Generally, I would recommend to
avoid serialization of Ignite, IgniteCache and similar objects. To do this
you can inject Ignite into the service like this:

class MyService implements Service {
@IgniteInstanceResource
private transient Ignite ignite;

...
}

Ignite instance will be injected automatically on the node where the service
is deployed.

-Val



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Calling-serviceDescriptiors-after-service-deployment-throws-exception-tp5903p5937.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.


Ignite work directory usage?

2016-06-27 Thread bintisepaha
Hi, 

Could someone explain the use of work directory? How does it work for client
and server?
Do they need to have access to the same directory?

There is not much documentation on it.

Thanks,
Binti




--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Ignite-work-directory-usage-tp5936.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.


argument type mismatch of oracle TIMESTAMP field when call loadCache

2016-06-27 Thread hu...@neusoft.com
hi,

When I loaded the data from oracle through cache.loadData.
The exception which is  argument type mismatch of oracle TIMESTAMP happened.

The detail: 
I produced the schema through the tool schema-import-tool.
A pojo object is Kc21, and it has a property Bkc192, its type is 
java.sql.Timestamp
The setter is the following:
public void x.x.x.x.Kc21.setBkc192(java.sql.Timestamp)

When I debuging the code, I found:
In the following method, there is a problem.

protected Object getColumnValue(ResultSet rs, int colIdx, Class type) 
throws SQLException {
//the parameter type is class java.sql.Timestamp
...
Object val = rs.getObject(colIdx);
And the val reading from oracle ResultSet is TIMESTAMP

So the val's type TIMESTAMP is different from java.sql.Timestamp and get 
the exception "argument type mismatch".

The whole method is the following, there is not handling about the type 
java.sql.Timestamp
protected Object getColumnValue(ResultSet rs, int colIdx, Class type) 
throws SQLException {
Object val = rs.getObject(colIdx);

if (val == null)
return null;

if (type == int.class)
return rs.getInt(colIdx);

if (type == long.class)
return rs.getLong(colIdx);

if (type == double.class)
return rs.getDouble(colIdx);

if (type == boolean.class || type == Boolean.class)
return rs.getBoolean(colIdx);

if (type == byte.class)
return rs.getByte(colIdx);

if (type == short.class)
return rs.getShort(colIdx);

if (type == float.class)
return rs.getFloat(colIdx);

if (type == Integer.class || type == Long.class || type == Double.class 
||
type == Byte.class || type == Short.class ||  type == Float.class) {
Number num = (Number)val;

if (type == Integer.class)
return num.intValue();
else if (type == Long.class)
return num.longValue();
else if (type == Double.class)
return num.doubleValue();
else if (type == Byte.class)
return num.byteValue();
else if (type == Short.class)
return num.shortValue();
else if (type == Float.class)
return num.floatValue();
}

if (type == UUID.class) {
if (val instanceof UUID)
return val;

if (val instanceof byte[]) {
ByteBuffer bb = ByteBuffer.wrap((byte[])val);

long most = bb.getLong();
long least = bb.getLong();

return new UUID(most, least);
}

if (val instanceof String)
return UUID.fromString((String)val);
}

// Workaround for known issue with Oracle JDBC driver 
https://community.oracle.com/thread/2355464?tstart=0
if (type == java.sql.Date.class && val instanceof java.util.Date)
return new java.sql.Date(((java.util.Date)val).getTime());

return val;
}

Thank you for any reply.



胡永亮
 
Bob


Re: TC access

2016-06-27 Thread Alexandre Boudnik
I don't need access to TC console, I need to have my pull requests tested.
Take care,
Alexandre "Sasha" Boudnik

call me via Google Voice:
1(405) BUDNIKA
1(405) 283-6452



On Mon, Jun 27, 2016 at 2:07 PM, Dmitriy Setrakyan
 wrote:
> I just realized that I don’t have a link either. Anton, do you mind adding
> the link to TC to the community dropdown on the website?
>
> On Mon, Jun 27, 2016 at 10:28 AM, Alexandre Boudnik
>  wrote:
>>
>> Hello,
>>
>> In order to use Ignite's TeamCity, could you provide myself with access to
>> it?
>>
>> Take care,
>> Alexandre "Sasha" Boudnik
>>
>> call me via Google Voice:
>> 1(405) BUDNIKA
>> 1(405) 283-6452
>
>


Re: TC access

2016-06-27 Thread Dmitriy Setrakyan
I just realized that I don’t have a link either. Anton, do you mind adding
the link to TC to the community dropdown on the website?

On Mon, Jun 27, 2016 at 10:28 AM, Alexandre Boudnik <
alexander.boud...@gmail.com> wrote:

> Hello,
>
> In order to use Ignite's TeamCity, could you provide myself with access to
> it?
>
> Take care,
> Alexandre "Sasha" Boudnik
>
> call me via Google Voice:
> 1(405) BUDNIKA
> 1(405) 283-6452
>


TC access

2016-06-27 Thread Alexandre Boudnik
Hello,

In order to use Ignite's TeamCity, could you provide myself with access to it?

Take care,
Alexandre "Sasha" Boudnik

call me via Google Voice:
1(405) BUDNIKA
1(405) 283-6452


Re: Performance issue on Ignite ODBC API

2016-06-27 Thread Agneeswaran
Hi Igor,

Thanks for the information. Will try to implement as suggested.

Will reach out to you if we have any queries.

With regards,
Agneeswaran



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Performance-issue-on-Ignite-ODBC-API-tp5908p5927.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.


Re: How to use rest api to put an object into cache?

2016-06-27 Thread Alexey Kuznetsov
Hi Kevin.

>> 1.   Does Rest API only support String as key and value? When I try
to use Integer as key, and gives null result.
See: https://issues.apache.org/jira/browse/IGNITE-3345

>> 2.   Assume I have a key object and value object, If I want to store
this object in server side cache, Do I have to store them as json format
string, and parse it on client side?
>> In this case, How can I set read/write through to enable database
interaction?

See: https://issues.apache.org/jira/browse/IGNITE-962

It seems both your questions is not implemented yet.

IGNITE-3345 - could be easily implemented IMHO. Do you interested to
contribute?


-- 
Alexey Kuznetsov
GridGain Systems
www.gridgain.com


Re: Strange collocated distributed set behavior

2016-06-27 Thread AndreyVel
It is magic, now DistributedSetDemo for new node shows size() == 0.

Since there is no backup configured for the set it’s a normal situation when
the set is empty 
after all the nodes that held its data had left the topology. Please note,
that the set as a data structure 
is not removed in such a case, to remove the set completely set.close()
method has to be used.
However I could reproduce the issue with wrong cache size when the second
node is started. 

Here is the ticket: https://issues.apache.org/jira/browse/IGNITE-3373
Hope that someone from the community will fix it soon.





--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Strange-collocated-distributed-set-behavior-tp5643p5925.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.


Re: System.exit() not exiting cleanly (locked on IgnitionEx$IgniteNamedInstance)

2016-06-27 Thread bintisepaha
bearrito, in 1.6 we saw streamer hung on flush() or close() and would never
return. We do not see that issue in 1.5.0.final.

Igniters, could you please look at the earlier attached log files and thread
dumps to help with the original issue.

Thanks,
Binti



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/System-exit-not-exiting-cleanly-locked-on-IgnitionEx-IgniteNamedInstance-tp5814p5924.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.


Re: Ignite.Net not successfully connecting

2016-06-27 Thread Pavel Tupitsyn
> Pavel, tried the following and still the same:
You have to clean NuGet caches (nuget locals all -clear in command line)
and reinstall the package. It'll work.

> How do I work out the second option? i.e. the following
Not sure I understand the question.
Basically, you download the binary package, unzip it and reference
Apache.Ignite.Core.dll from there.

> Also, when can we expect a release with the fix?
I am not aware of any timelines for 1.7.
There were discussions about shortening the release cycle, so maybe in a
couple of months.

Pavel.

On Mon, Jun 27, 2016 at 3:39 PM, baburaj.james 
wrote:

> Also, when can we expect a release with the fix?
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Ignite-Net-not-successfully-connecting-tp5912p5922.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>


Re: Ignite.Net not successfully connecting

2016-06-27 Thread baburaj.james
Pavel, tried the following and still the same:

* Use unofficial .NET feed: 
  Install-Package Apache.Ignite -Source
https://www.myget.org/f/apache-ignite-staging

How do I work out the second option? i.e. the following 

* Run .NET from the binary distribution:
  http://ignite.apache.org/download.cgi#binaries



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Ignite-Net-not-successfully-connecting-tp5912p5920.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.


Re: Problem with installing ODBC Driver

2016-06-27 Thread Igor Sapego
Also, please properly subscribe to the user list (this way we will not have
to manually approve your emails). All you need to do is send an email to “
user-subscr...@ignite.apache.org” and follow simple instructions in the
reply.

Best Regards,
Igor

On Mon, Jun 27, 2016 at 3:06 PM, Igor Sapego  wrote:

> Hello,
>
> Currently, our ODBC driver do not support creating of the system DSN. This
> feature is something we are going to add in future, though only for
> Windows.
>
> Best Regards,
> Igor
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Problem-with-installing-ODBC-Driver-tp5914p5917.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>


Re: Performance issue on Ignite ODBC API

2016-06-27 Thread Igor Sapego
Agneeswaran,

Here you can find details on how to use SQL queries from Java at [1].
Also, do you really have 7 string columns? Try using the matching types,
this way you can avoid type cast overhead.

[1] - https://apacheignite.readme.io/docs/sql-queries

Best Regards,
Igor

On Mon, Jun 27, 2016 at 1:44 PM, Agneeswaran <
agneeswaran.ponnuraman...@nielsen.com> wrote:

> Hi Igor,
>
> Yes, it takes more than 15 minutes for ~70 thousand rows.
> We are running on C++ with Linux. We never tried with java API.
>
> Could you please pass us some links to use Java API.
>
> Thanks in advance,
>
> With regards,
> Agneeswaran
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Performance-issue-on-Ignite-ODBC-API-tp5908p5911.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>


Re: Problem with installing ODBC Driver

2016-06-27 Thread Igor Sapego
Hello,

Currently, our ODBC driver do not support creating of the system DSN. This
feature is something we are going to add in future, though only for Windows.

Best Regards,
Igor



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Problem-with-installing-ODBC-Driver-tp5914p5917.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.


subscration

2016-06-27 Thread Razmik Mkrtchyan



Creating cache with CacheLoaderFactory on client node brings exception org.apache.ignite.IgniteCheckedException: Failed to find class with given class loader for unmarshalling (make sure same version

2016-06-27 Thread daniel07
Hi,
I saw other questions related org.apache.ignite.IgniteCheckedException:
Failed to find class with given class loader for unmarshalling (make sure
same versions of all classes are available on all nodes or enable
peer-class-loading) exception,but not find my answer.

I have one remote server node,and from local client node I discover that
server node.
Now from client node I want to create cache-
p.s.  added for 2
configurations
my code is following 

private final CacheConfiguration> cacheConfiguration =
SpringContextHolder.applicationContext
.getBean("cacheConfigurationTemplate", 
CacheConfiguration.class);

ignite.createCache((CacheConfiguration>)new
CacheConfiguration<>(cacheConfiguration).setName(CACHE_NAME)
.setReadThrough(true)
.setCacheLoaderFactory(new 
EntityIdLoaderFactory())

.setExpiryPolicyFactory(EternalExpiryPolicy.factoryOf(



public  class EntityIdLoaderFactory
implements Factory {

private static final long serialVersionUID = 7512841233166239706L;

@Override
public EntityIdLoader create() {
return new EntityIdLoader(
() ->
SpringContextHolder.applicationContext.getBean("persistenceService",
PersistenceService.class),
() -> 
SpringContextHolder.applicationContext.getBean("kbEngine",
KbEngine.class));
}

}




public class EntityIdLoader implements
CacheLoader> {

@Nonnull
private final Supplier persistenceService;
@Nonnull
private final Supplier kbEngine;

public EntityIdLoader(@Nonnull Supplier
persistenceService, @Nonnull Supplier kbEngine) {
this.kbEngine = Preconditions.checkNotNull(kbEngine);
this.persistenceService =
Preconditions.checkNotNull(persistenceService);
}


}


during  creating cache ,on remote node brings exception

class org.apache.ignite.IgniteCheckedException: Failed to find class with
given class loader for unmarshalling (make sure same versions of all classes
are available on all nodes or enable peer-class-loading):
java.net.URLClassLoader@738defde   at
org.apache.ignite.marshaller.jdk.JdkMarshaller.unmarshal(JdkMarshaller.java:108)
at
org.apache.ignite.spi.discovery.tcp.messages.TcpDiscoveryCustomEventMessage.message(TcpDiscoveryCustomEventMessage.java:80)
at
org.apache.ignite.spi.discovery.tcp.ServerImpl$RingMessageWorker.notifyDiscoveryListener(ServerImpl.java:4894)
  
at
org.apache.ignite.spi.discovery.tcp.ServerImpl$RingMessageWorker.processCustomMessage(ServerImpl.java:4750)
at
org.apache.ignite.spi.discovery.tcp.ServerImpl$RingMessageWorker.processMessage(ServerImpl.java:2121)
at
org.apache.ignite.spi.discovery.tcp.ServerImpl$RingMessageWorker.body(ServerImpl.java:2208)07)
at
org.apache.ignite.spi.IgniteSpiThread.run(IgniteSpiThread.java:62)
Caused by: java.lang.ClassNotFoundException:
com.synisys.idm.apollo.internal.service.caching.loaders.EntityIdLoaderFactory   
  
at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
at java.security.AccessController.doPrivileged(Native Method)
at java.lang.ClassLoader.loadClass(ClassLoader.java:425):354)
at java.lang.Class.forName0(Native Method)ader.java:358)
at
org.apache.ignite.internal.util.IgniteUtils.forName(IgniteUtils.java:8250)
at
org.apache.ignite.marshaller.jdk.JdkMarshallerObjectInputStream.resolveClass(JdkMarshallerObjectInputStream.java:54)
at
java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1517)12)
at
java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1350)a:1771)
at
java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1915)90)
at
java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1350)a:1798)
at
java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1915)90)
at
java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1350)a:1798)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:370)
at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source)
at
java.lang.reflect.Method.invoke(Method.java:606)DelegatingMethodAccessorImpl.java:43)
at
java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1893)7)
at
java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1350)a:1798)
at
java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1915)90)
at
java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1350)a:1798)
at
java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1915)90)
at

Re: Ignite.Net not successfully connecting

2016-06-27 Thread Pavel Tupitsyn
Hi, this is a known issue (NuGet package has a difference in Java version
number).
It will be fixed in the next release.

For 1.6, your options are:

* Use unofficial .NET feed:
  Install-Package Apache.Ignite -Source
https://www.myget.org/f/apache-ignite-staging

* Run .NET from the binary distribution:
  http://ignite.apache.org/download.cgi#binaries


On Mon, Jun 27, 2016 at 2:14 PM, baburaj.james 
wrote:

> I have an Ignite node running on a separate machine. The node was started
> using bin/ignite.sh command.
>
> On my local machine (Windows), I have a C# console application that use
> Ignite Nuget package to connect to the remote node.
>
> Following is the code:
>
> var igniteConfiguration = new IgniteConfiguration();
> igniteConfiguration.ClientMode = true;
> igniteConfiguration.DiscoverySpi = new TcpDiscoverySpi
> {
> IpFinder = new TcpDiscoveryStaticIpFinder
> {
> Endpoints = new List { ":47500" }
> }
> };
>
> IIgnite ignite = Ignition.Start(igniteConfiguration);
>
> But this throws an exception on the Start method as below:
>
> Caused by: class org.apache.ignite.spi.IgniteSpiException: Local node and
> remote
>  node have different version numbers (node will not join, Ignite does not
> suppor
> t rolling updates, so versions must be exactly the same)
> [locBuildVer=1.6.0,
> rmt
> BuildVer=1.6.0-SNAPSHOT, locNodeAddrs=[/0:0:0:0:0:0:0:
> 1%lo, /, /127.0.0.1], rmtNodeAddrs=[/0:0:0:0:0:0:0:1, /,
> xxx/127.0.0.1, /, /],
>  locNodeId=84c9d371-f76c-49c8-a71f-5f974c94ee8f,
> rmtNodeId=4b174081-7009-4f37-ae
> c7-713bc88659b9]
> at
> org.apache.ignite.spi.discovery.tcp.TcpDiscoverySpi.checkFailedError(
> TcpDiscoverySpi.java:1644)
> at
> org.apache.ignite.spi.discovery.tcp.ClientImpl$MessageWorker.body(Cli
> entImpl.java:1461)
> at
> org.apache.ignite.spi.IgniteSpiThread.run(IgniteSpiThread.java:62)
>
> [16:54:13] Ignite node stopped OK [uptime=00:00:06:575]
>
>
> (note: some private/public ips have been changed to )
>
> It is complaining that some build version is mismatching (only that server
> has a SNAPSHOT to the version string).
>
> Can anybody help in identified the issue?
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Ignite-Net-not-successfully-connecting-tp5912.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>


Ignite.Net not successfully connecting

2016-06-27 Thread baburaj.james
I have an Ignite node running on a separate machine. The node was started
using bin/ignite.sh command.

On my local machine (Windows), I have a C# console application that use
Ignite Nuget package to connect to the remote node.

Following is the code:

var igniteConfiguration = new IgniteConfiguration();
igniteConfiguration.ClientMode = true;
igniteConfiguration.DiscoverySpi = new TcpDiscoverySpi
{
IpFinder = new TcpDiscoveryStaticIpFinder
{
Endpoints = new List { ":47500" }
}
};

IIgnite ignite = Ignition.Start(igniteConfiguration);

But this throws an exception on the Start method as below:

Caused by: class org.apache.ignite.spi.IgniteSpiException: Local node and
remote
 node have different version numbers (node will not join, Ignite does not
suppor
t rolling updates, so versions must be exactly the same) [locBuildVer=1.6.0,
rmt
BuildVer=1.6.0-SNAPSHOT, locNodeAddrs=[/0:0:0:0:0:0:0:
1%lo, /, /127.0.0.1], rmtNodeAddrs=[/0:0:0:0:0:0:0:1, /,
xxx/127.0.0.1, /, /],
 locNodeId=84c9d371-f76c-49c8-a71f-5f974c94ee8f,
rmtNodeId=4b174081-7009-4f37-ae
c7-713bc88659b9]
at
org.apache.ignite.spi.discovery.tcp.TcpDiscoverySpi.checkFailedError(
TcpDiscoverySpi.java:1644)
at
org.apache.ignite.spi.discovery.tcp.ClientImpl$MessageWorker.body(Cli
entImpl.java:1461)
at
org.apache.ignite.spi.IgniteSpiThread.run(IgniteSpiThread.java:62)

[16:54:13] Ignite node stopped OK [uptime=00:00:06:575]


(note: some private/public ips have been changed to )

It is complaining that some build version is mismatching (only that server
has a SNAPSHOT to the version string).

Can anybody help in identified the issue?



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Ignite-Net-not-successfully-connecting-tp5912.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.


Re: Performance issue on Ignite ODBC API

2016-06-27 Thread Agneeswaran
Hi Igor,

Yes, it takes more than 15 minutes for ~70 thousand rows.
We are running on C++ with Linux. We never tried with java API.

Could you please pass us some links to use Java API.

Thanks in advance,

With regards,
Agneeswaran



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Performance-issue-on-Ignite-ODBC-API-tp5908p5911.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.


Re: Performance issue on Ignite ODBC API

2016-06-27 Thread Igor Sapego
Hi, Agneeswaran,

So, what is the problem? Does this code work slow? Can you compare to the
same query performed using Java API and say the difference?

Best Regards,
Igor

On Mon, Jun 27, 2016 at 11:55 AM, Agneeswaran <
agneeswaran.ponnuraman...@nielsen.com> wrote:

> Hi Team,
>
> We are facing performance issue on ignite ODBC API, please find the details
> as follows,
>
> Our table contains for example 10 thousands row with 7 column( it contains
> string ,double and int).
>
> The while loops runs according to the row size in our example it is 10
> thousand time.
> Please let us know, the efficient way of fetching the value from the
> Database using ODBC API.
>
> We have used the code which is same as in the example ignite ODBC.
>
> Please find the below code and provide your valuable suggestion.
>
> SQLHSTMT stmt;
> // Allocate a statement handle
> SQLAllocHandle(SQL_HANDLE_STMT, dbc, );
> std::vector buf(strQuery.begin(),
> strQuery.end());
> ret = SQLExecDirect(stmt, [0],
> static_cast(buf.size()));
> if (SQL_SUCCEEDED(ret))
> {
>   SQLSMALLINT columnsCnt = 0;
>   SQLNumResultCols(stmt,
> );
>   std::vector
> columns(columnsCnt);
>  for (SQLSMALLINT i = 0; i <
> columnsCnt; ++i)
>   SQLBindCol(stmt,
> i+1, SQL_CHAR, columns[i].buffer,
> ODBC_BUFFER_SIZE, [i].reallen);
> while (true)
> {
> SQLRETURN ret =
> SQLFetch(stmt);
> if
> (!SQL_SUCCEEDED(ret))
> break;
> }
> }
>
>
> Thanks,
> Agneeswaran
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Performance-issue-on-Ignite-ODBC-API-tp5908.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>


Re: Strange collocated distributed set behavior

2016-06-27 Thread AndreyVel
Hello zshamrock,

I cannot reproduce you issue Scenario#1 on Ignite 1.6.0.
It is strange why instance 2-3-4 prints:
[local] Size of the numbers distributed set is 0, and items are [] 

Should be
[local] Size of the numbers distributed set is 1, and items are [42]


To be honest I have used local cluster configuration

IgniteConfiguration cfg = new IgniteConfiguration();
cfg.setPeerClassLoadingEnabled(true);
TcpDiscoveryVmIpFinder ipFinder = new TcpDiscoveryVmIpFinder(true);
ipFinder.setAddresses(Arrays.asList("127.0.0.1:47500..47509"));

TcpDiscoverySpi discoSpi = new TcpDiscoverySpi();
discoSpi.setIpFinder(ipFinder);
cfg.setDiscoverySpi(discoSpi);
final Ignite ignite = Ignition.start(cfg);

Please add logging collection creation

IgniteSet numbers = ignite.set("numbers", null);
if (numbers == null) {
System.out.println("[local] creating collection [numbers]");
numbers = ignite.set("numbers", collectionConfiguration);
}

and at the end of code put

numbers.add(42L);
System.out.printf("Waiting 6000 sec...");
Thread.sleep(1000 * 6000);



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Strange-collocated-distributed-set-behavior-tp5643p5909.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.


Performance issue on Ignite ODBC API

2016-06-27 Thread Agneeswaran
Hi Team,

We are facing performance issue on ignite ODBC API, please find the details
as follows,

Our table contains for example 10 thousands row with 7 column( it contains
string ,double and int).

The while loops runs according to the row size in our example it is 10
thousand time.
Please let us know, the efficient way of fetching the value from the
Database using ODBC API.

We have used the code which is same as in the example ignite ODBC.

Please find the below code and provide your valuable suggestion.

SQLHSTMT stmt;
// Allocate a statement handle
SQLAllocHandle(SQL_HANDLE_STMT, dbc, );
std::vector buf(strQuery.begin(),
strQuery.end());
ret = SQLExecDirect(stmt, [0],
static_cast(buf.size()));
if (SQL_SUCCEEDED(ret))
{
  SQLSMALLINT columnsCnt = 0;
  SQLNumResultCols(stmt, );
  std::vector 
columns(columnsCnt); 
 for (SQLSMALLINT i = 0; i < 
columnsCnt; ++i)
  SQLBindCol(stmt, i+1, 
SQL_CHAR, columns[i].buffer,  
ODBC_BUFFER_SIZE, [i].reallen);
while (true)
{
SQLRETURN ret = 
SQLFetch(stmt);
if (!SQL_SUCCEEDED(ret))
break;
}
}


Thanks,
Agneeswaran



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Performance-issue-on-Ignite-ODBC-API-tp5908.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.


Re: Jetty configuration for adding new Handler

2016-06-27 Thread Andrey Novikov
Hi Saurabh,

I've investigated ignite-rest-http module and found that handler from
configuration will be overrided by default handler
(org/apache/ignite/internal/processors/rest/protocols/http/jetty/GridJettyRestProtocol.java:332)

I've created issue for fix this problem
https://issues.apache.org/jira/browse/IGNITE-3370

As temporally workaround you may do the following:

1) Extend embedded server class and place it
into HandlerCollectionServer jar, add as dependency to project or if your
using binary distributive put it into libs folder.

package my.company.jetty;

public class HandlerCollectionServer extends Server {
private HandlerCollection hndCol;

public HandlerCollectionServer(@Name("threadpool") ThreadPool pool) {
super(pool);

super.setHandler(hndCol = new HandlerCollection());
}

/** {@inheritDoc} */
@Override public void setHandler(Handler hnd) {
// Workaround. Don't override, just add to handlers collection.
hndCol.addHandler(hnd);
}
}

2) Add dependency to project.


org.eclipse.jetty
jetty-rewrite
${jetty.version}


3) Use following jetty configuration:

http://www.eclipse.org/jetty/configure.dtd;>




20
200


false


https
8443
true
true























3
true









*.*
Access-Control-Allow-Origin
*



  





On Fri, Jun 24, 2016 at 5:10 PM, Saurabh Sharma 
wrote:

> Hi,
>
>
>
> Could anyone please tell us how to add response header 
> "Access-Control-Allow-Origin"
> in the response returned from the rest call to ignite.
>
>
>
> Thanks,
> Saurabh
>
>
>
> *From:* Saurabh Sharma [mailto:saurabh.sha...@nviz.com]
> *Sent:* Thursday, June 23, 2016 7:46 PM
> *To:* user@ignite.apache.org
> *Subject:* Jetty configuration for adding new Handler
>
>
>
> Hi,
>
>
>
> We are using  ignite-rest-http module to make Rest http calls. For that we
> have included ignite-rest-http dependency in our ignite module and are able
> to make http calls successfully.
>
>
>
> Now when we are trying to configure Jetty's RewriteHandler to set
> HeaderPatternRule to set "Access-Control-Allow-Origin" this handler is not
> being called and response header is not being set when we make http call.
>
> However I could see this handler being set at the time of ignite startup
> during debugging.
>
>
>
> We are using following configuration. Could you please suggest if we are
> missing anything.
>
>
>
> 
>
>  http://www.eclipse.org/jetty/configure.dtd;>
>
> 
>
> 
>
> 
>
> 
>
> 20
>
> 200
>
> 
>
> 
>
> 
>
> https
>
> 8443
>
> true
>
> true
>
> 
>
>  class="org.eclipse.jetty.rewrite.handler.RewriteHandler">
>
>   
>
>  type="org.eclipse.jetty.rewrite.handler.Rule">
>
>
>
>   
>
>  class="org.eclipse.jetty.rewrite.handler.HeaderPatternRule">
>
>name="pattern">*.*
>
>name="name">myheader
>
>   the
> value of myheader
>
> 
>
>   
>
>
>
> 
>
>   
>
> 
>
> 
>
> 
>
> 
>
> 
>
> 
>
>  type="org.eclipse.jetty.server.ConnectionFactory">
>
> 
>
>  class="org.eclipse.jetty.server.HttpConnectionFactory">
>
> 
>
> 
>
> 
>
> 
>
> 
>
> 
>
>default="localhost"/>
>
> 
>
> 
>
>   
>
> 
>
> 3
>
> true
>
> 
>
> 
>
> 
>
> 
>
>  class="org.eclipse.jetty.server.handler.HandlerCollection">
>
> 
>
> 
>
> 
>
>  class="org.eclipse.jetty.server.handler.ContextHandlerCollection"/>
>
> 
>
> 
>
> 
>
> 
>
> 
>
>
>
>