[orientdb] Re: migration version 1.7.2 to 2.2 get inconsitance rid for edge creation

2015-10-28 Thread alexander anguiano
I'm not sure about what you are facing, but i do want to tell you that the sql in 2.2 is more strict and may not work. I got errors in my logs. You can get it to be less strict by adding this to your database ALTER DATABASE custom strictSQL=false On Tuesday, October 27, 2015 at 5:57:50 AM UTC

Re: [orientdb] com.orientechnologies.orient.core.exception.OConcurrentModificationException at Distributed mode

2015-10-28 Thread alexander anguiano
I just ran into this problem. In your response you say "reduce occurrences". So, shouldn't we catch the exception and try again in a loop and give up after so many attempts? I thought i've seen some code that did that at one point on this. On Tuesday, September 15, 2015 at 10:53:37 AM UTC-5,

[orientdb] Re: 2.1.1 broke calculations in sql

2015-10-02 Thread alexander anguiano
ionTime as lastCommunicationTime from (select expand(in("MemberOf")) from #14:1 ) Let $agent = in("Manages") where @class = 'Asset' and (date() - $agent.lastCommunicationTime[0]) > 4 On Thursday, September 17, 2015 at 2:28:00 PM UTC-5, alexander anguiano wrote: >

[orientdb] Re: 2.1.1 broke calculations in sql

2015-09-17 Thread alexander anguiano
I sent the schema privately. On Monday, September 14, 2015 at 2:11:37 AM UTC-5, Giulia Brignoli wrote: > > Hi Alexander, > > can you send me your schema? > > Regards, > Giulia > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe f

[orientdb] 2.1.1 broke calculations in sql

2015-09-11 Thread alexander anguiano
I'm trying to move from 2.0.2 to 2.1.1, this query worked in 2.0.2 select hostname, date().asLong(), $agent.lastCommunicationTime[0].asLong() , date().asLong() - $agent.lastCommunicationTime[0].asLong(), $agent.version as agentVersion, $agent.lastCommunicationTime as lastCommunicat

[orientdb] function date in insert sql doesn't work in 2.1.1

2015-09-06 Thread alexander anguiano
I'm trying to move form 2.0.x to 2.1.1 and i have this insert insert into Asset (modifiedTime, guid, hostname, majorType, version, importance, addresses, attributes, tags) values ( date() ,? ,? ,? ,? ,?,?,?,?) This works fine in 2.0.2 when i execute this, it gets this error ! com.orientechno

[orientdb] How to do you debug a problem in a multi-thread app when using a remote orientdb

2015-05-08 Thread alexander anguiano
I have a multi-thread application and i'm getting an error. I don't have any of my package in the stack trace. How do you debug this? ERROR [2015-05-08 18:25:27,781] io.dropwizard.jersey.errors.LoggingExceptionMapper: Error handling a request: 017d43a2a6cbbf3b ! com.orientechnologies.orient

Re: [orientdb] distribution.zip in repository

2015-03-11 Thread alexander anguiano
load. > > Lvc@ > > > On 10 March 2015 at 18:31, alexander anguiano > wrote: > >> I"m trying to put orientdb in an installer. We are trying NOT to put jar >> files in our source repository so i have to get it from maven. I don't see >> the latest

[orientdb] distribution.zip in repository

2015-03-10 Thread alexander anguiano
I"m trying to put orientdb in an installer. We are trying NOT to put jar files in our source repository so i have to get it from maven. I don't see the latest 2.0.4 in the repository.I notices that not all version are there. Is there a reason for that or is that an oversight? If it is no

Re: [orientdb] Create distribution from maven repository

2015-03-09 Thread alexander anguiano
gt; ../releases/orientdb-comunity-/ > > Regards > > Luigi > > > 2015-03-07 0:51 GMT+01:00 alexander anguiano >: > >> >> How do I create the distribution from the maven repository. >> >> when i build my project i need to pull the jars from mav

[orientdb] Create distribution from maven repository

2015-03-06 Thread alexander anguiano
How do I create the distribution from the maven repository. when i build my project i need to pull the jars from maven and create the same structure as the distribution orientdb bin config databases lib orientdb-core-2.0.2.jar ... plugins

[orientdb] Re: Record deadlock issue in 2.0.2

2015-03-02 Thread alexander anguiano
i also was getting this. It seems when you do thing using the graphdb it cause problems My queries and updates where like this select * from groups where @rid = #12:3 I change them to this select * from #12:3 I had updates like this update table set mfield = 12 where @rid = #14:4 i change

[orientdb] Re: How to execute batch scripts using OrientDB Console - OrientDB 2.0.3

2015-03-02 Thread alexander anguiano
i created a file like this called schema.sql Create DATABASE remote:localhost/assets root plocal CREATE CLASS Application extends V CREATE CLASS Asset extends Application create property Asset.addresses embeddedlist when you want to execute it from dos do this console schema.sql On Mon

[orientdb] OTimeoutException: Can not lock record for 2000 ms. seems record is deadlocked by other record

2015-02-11 Thread alexander anguiano
orientdb 2.0.1 java 7 window & linux sql and the java api I have a multi-thread environment with multiple threads updating and reading. date from my graph database. I run this query several times a minutes form different threads QueryA - runs several times a minute update (select expand(in('Ma

[orientdb] Re: OTimeoutException: Timeout on acquiring exclusive lock against resource of class:

2015-02-06 Thread alexander anguiano
I have a similar problem. in the latest release 2.0.1 orientdb 2.0.1 java 7 window & linux I use sql and the java api I have a class that i'm updating frequently in multiple threads. This same class is used in a guery to show in a grid. i did find the setting OGlobalConfiguration.STORAGE_

Re: [orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread alexander anguiano
() > where > out("Manages").guid contains '19da4856-57c0-4b39-8f4b-53fc47f86dcf' > > which will probably give you problems still, dur to the fact that you are > performing a lookup with guid, which seems to take too long. > > > > On Friday, Febr

Re: [orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread alexander anguiano
I didn't realize you can do this. The real query that i need is update (select in('Manages') from asset where guid = '817ea932-4a4a-49a4-8454-37c5098703a2') set lastCommunicationTime=date() but it isn't working, it get this java.lang.IllegalArgumentException: Cluster segment #-2 does not ex

[orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread alexander anguiano
d it should be faster now. > The hanging bit, are you saying that after running update commands like > that , after a bit the server starts hanging and/or the queries taking > longer to execute ? > Anything being printed on the logs ? > > > On Friday, February 6, 2015 at 3:25:

[orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread alexander anguiano
x27;Manages').@rid from asset where guid = '19da4856-57c0-4b39-8f4b-53fc47f86dcf') it does work, any clue why the query slow down? On Friday, February 6, 2015 at 9:16:17 AM UTC-6, alexander anguiano wrote: > > I don't need to expand, how do i get the rid? I tried in(&qu

[orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread alexander anguiano
> > select in('Manages') from asset where guid = > '19da4856-57c0-4b39-8f4b-53fc47f86dcf') > > return a List (like [rid1,rid1,rid3, etc] ) which should be > enough for your purpose, no? > > On Friday, February 6, 2015 at 2:11:46 PM UTC, alexander anguian

[orientdb] sql update with query - will eventually hang

2015-02-06 Thread alexander anguiano
orientdb version 2.0.1 java 7 windows and linux i'm making alot of these calls and eventually they begin to hang update Agent set lastCommunicationTime=date() where @rid in (select @rid from (select expand(in('Manages')) from asset where guid = '19da4856-57c0-4b39-8f4b-53fc47f86dcf'))

Re: [orientdb] Graph Pool Connection

2015-01-27 Thread alexander anguiano
Tx(); > > And yes, connection back to the pool when shutdown is called. > > > On Tue, Jan 27, 2015 at 3:50 PM, alexander anguiano > wrote: > >> What pool is recommended for graph database for 2.0? >> >> Is this one? >> >> http://www.orientechnologies.

[orientdb] Graph Pool Connection

2015-01-27 Thread alexander anguiano
What pool is recommended for graph database for 2.0? Is this one? http://www.orientechnologies.com/docs/last/orientdb.wiki/Graph-Factory.html Also, how is the connection returned to the pool. is it when the shutdown is called? I'm trying to trackdown a database pool leak. -- --- You receiv

Re: [orientdb] Is it possible to create a class that has a field of json?

2014-08-25 Thread alexander anguiano
ct of type "Test". This is automatically > converted from/to json when you work on it. > > Lvc@ > > ᐧ > > > On 25 August 2014 17:32, alexander anguiano > wrote: > >> Is it possible to create a class that has a field of json? >> >> Creat

Re: [orientdb] Is it possible to create a class that has a field of json?

2014-08-25 Thread alexander anguiano
dded field, so: > > Create property embedded EMBEDDED Test; > > To create an embedded object of type "Test". This is automatically > converted from/to json when you work on it. > > Lvc@ > > ᐧ > > > On 25 August 2014 17:32, alexander anguiano > wrote:

[orientdb] Is it possible to create a class that has a field of json?

2014-08-25 Thread alexander anguiano
Is it possible to create a class that has a field of json? Create Class Package extends V; Create property name string; Create property myjson ?; what type would this be? -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe

Re: [orientdb] How do you start a transaction, the wiki is wrong or method in the wiki is wrong

2014-08-05 Thread alexander anguiano
23transactions&sa=D&sntz=1&usg=AFQjCNGbbiIQg_9XZcnDCfOSDxHHYatjwQ> > > Lvc@ > > > > On 4 August 2014 18:47, alexander anguiano > > wrote: > >> I'm using 1.7.7, from the wiki, the api is supposed to be begin(), but >> the begin() method is not availabl

[orientdb] How do you start a transaction, the wiki is wrong or method in the wiki is wrong

2014-08-04 Thread alexander anguiano
I'm using 1.7.7, from the wiki, the api is supposed to be begin(), but the begin() method is not available to OrientGraph object. the commit() and rollback() methods exists https://github.com/orientechnologies/orientdb/wiki/Transactions What is it? -- --- You received this message becau

Re: [orientdb] update return after @rid not working version 1.7.7

2014-07-31 Thread alexander anguiano
> https://github.com/orientechnologies/orientdb/issues/2639) where only > "value" is returned with the returning value, in this case @rid. Please get > last snapshot. > > Lvc@ > > > > > Lvc@ > > > > On 30 July 2014 14:49, alexander anguiano >

[orientdb] update return after @rid not working version 1.7.7

2014-07-30 Thread alexander anguiano
I'm using orientdb 1.7.7 I have this update statement. update TaskStatus set status = 'Running' where status = 'Pending' limit 1 RETURN AFTER @rid I'm expecting the update to return a collection of rids it is failing because it doesn't like the return after keyword com.orientechnologies.ori

[orientdb] Re: Does anyone have 1.7.2 working with dropwizard, play or jpa?

2014-07-28 Thread alexander anguiano
rsion} On Friday, June 13, 2014 9:11:20 AM UTC-5, alexander anguiano wrote: > > I just tried this with 1.7.3 and it still doesn't work. Is there a way to > override this somehow? > > On Tuesday, June 10, 2014 3:25:35 AM UTC-5, Carlo Polisini wrote: >> >> It se

[orientdb] Re: Usage of Embedded Map in SQL and Java

2014-07-02 Thread alexander anguiano
*Create the class* CREATE CLASS Computer extends V create property Computer.hostname string create property Computer.attributes embeddedmap *Object in Java* public class Computer { private Map attributes = new HashMap(); private String version; public Map getAttributes() { return attributes; }

[orientdb] Re: Does anyone have 1.7.2 working with dropwizard, play or jpa?

2014-06-13 Thread alexander anguiano
not implemented and raise an > UnsupportedOperationException("getProviderUtil") whenever is called. > > https://groups.google.com/forum/#!topic/orient-database/n03vpYocia4 > > > On Tuesday, June 10, 2014 2:10:06 AM UTC+2, alexander anguiano wrote: >> >>

[orientdb] Re: javax.validation.ValidationException in Play after OrientDB upgrade

2014-06-10 Thread alexander anguiano
m object that > is jpa annotated, therefore I going to do manual binding and check manually > the constraints to solve this problem. > > On Monday, June 9, 2014 10:36:06 PM UTC+2, alexander anguiano wrote: >> >> I'm having this problem too. How do i fix it? i don

[orientdb] Does anyone have 1.7.2 working with dropwizard, play or jpa?

2014-06-09 Thread alexander anguiano
Does anyone have 1.7.2 working with dropwizard, play or jpa? Also, I create a single jar and with 1.6.4 my jar was 13meg. With 1.7.4 it jumped up to 25.5 meg. (Sorry for the redundancy , there are several threads in the forum with no solutions. ) Here's the stack trace i get with dropwiza

[orientdb] Re: javax.validation.ValidationException in Play after OrientDB upgrade

2014-06-09 Thread alexander anguiano
I'm having this problem too. How do i fix it? i don't use jpa2 On Monday, June 9, 2014 11:14:33 AM UTC-5, Carlo Polisini wrote: > > I upgraded to OrientDB 1.7.1 but still I have this problem. I realized > that is due to the fact that OrientDB now come with JPA 2.0 support and > Play is trying

[orientdb] Re: Cannot download 1.7.1 from US

2014-06-06 Thread alexander anguiano
Ok, the email did link to 1.7.1 and i was able to download it. It was was very slow. On Friday, June 6, 2014 10:09:25 AM UTC-5, alexander anguiano wrote: > > I cannot seem to down load 1.7.1. > > If i use the link on the download page, it says it will down load in 2 > ho

[orientdb] Cannot download 1.7.1 from US

2014-06-06 Thread alexander anguiano
I cannot seem to down load 1.7.1. If i use the link on the download page, it says it will down load in 2 hour but it never completes. If i put register it does the same, it also give me a link to 1.7 not 1.7.1 -- --- You received this message because you are subscribed to the Google Group

Re: [orientdb] Re: Remove edges while deleting a vertex

2014-05-16 Thread alexander anguiano
So, is this fixed? On Tuesday, May 6, 2014 9:36:21 AM UTC-5, Lvc@ wrote: > > Hi Munish, > may you try with 1.7-SNAPSHOT to understand if the bug has been already > fixed? > > Thanks, > Lvc@ > > > On 6 May 2014 16:34, Munish Chopra >wrote: > >> Hi Luca, >> >> Thanks for the reply. >> >> Yes Clas

[orientdb] import export doesn't import my classes using 1.6.4

2014-04-25 Thread alexander anguiano
I'm trying to export and import a graph database using 1.6.4. My class are not being create on the import. I do this export database assets.json DROP DATABASE remote:localhost/assets root *** and it generates the assets.json.gz file. I open it up and my class are in there. I drop the da

[orientdb] Re: sql create edge in java problem

2014-03-31 Thread alexander anguiano
d2)); > > and now i get this > > Argument '?' is not a RecordId in form of string. Format must be: > : > > > On Monday, March 31, 2014 2:15:09 PM UTC-5, alexander anguiano wrote: >> >> How do you create an edge using OCommandRequest, >>

[orientdb] Re: sql create edge in java problem

2014-03-31 Thread alexander anguiano
mat must be: : On Monday, March 31, 2014 2:15:09 PM UTC-5, alexander anguiano wrote: > > How do you create an edge using OCommandRequest, > > I'm using 1.6.4 of orierntdb > > OCommandRequest request =... > > request.command(new OCommandSQL("create edge MemberOf ?

[orientdb] sql create edge in java problem

2014-03-31 Thread alexander anguiano
How do you create an edge using OCommandRequest, I'm using 1.6.4 of orierntdb OCommandRequest request =... request.command(new OCommandSQL("create edge MemberOf ? to ?")).execute(rid1,rid2); gives me Cannot find a command executor for the command request: sql.? to ? -- --- You received