[orientdb] Re: Getting back all Persons of a Title

2014-09-09 Thread 'Curtis Mosters' via OrientDB
Well Enrico helped me and now I have: select *,out(WROTE).size() as count from ( select expand(in(HAS_TITLE).in(WROTE)) from Title where title LUCENE 'random' LIMIT 3) order by count desc That works pretty well, but I don't think it's what I want to have. It selects results from Lucene

[orientdb] SKIP and Limit does not appear to be working

2014-09-09 Thread yzhong
Firstly I am using the version 1.7.8 downloaded from the http://orientechnologies.com. What is happening is I try to get all the post that a user's friend have posted here is a screenshot of my sql Select expand(out('posted')) from (select expand(out('friend')) from #12:338) order by

[orientdb] Re: Is there a way to just get one Vertex back with Java API instead of all?

2014-09-09 Thread 'Curtis Mosters' via OrientDB
Thank you, will test this when I reimport everything and then write here about the performance. Am Montag, 8. September 2014 21:19:42 UTC+2 schrieb odbuser: The only method that returns a single Vertex is noTxGraph.getVertex(Object id); So if you know there's only one vertex (or if you

Re: [orientdb] asynchronous dserver?

2014-09-09 Thread vogt . ben
So here is my final report... We have scoured all the available docs and come to the conclusion that OrientDB *does not* support 100% asynchronous replication. writeQuorum 1 is just as fast as writeQuorum 2 which leads me to believe this flag has no effect in the sources. Alternatively we have

[orientdb] How to export a 112 GB database when 2.0 is released

2014-09-09 Thread 'Curtis Mosters' via OrientDB
Well I just want to know what is the best way to export my 112 GB to version 2.0 when released officially? I tried to export a 50 GB database but after 1 hour it felt like 500 MB were exported. Also tried to copy the folder and move it to 2.0 which didn't work. But yeah I maybe had an old

[orientdb] Re: SKIP and Limit does not appear to be working

2014-09-09 Thread 'Curtis Mosters' via OrientDB
Sorry but I don't see any Skip? And what is AEC, do you mean ASC? Edit: your pic is not loading, just an empty block ;) Am Dienstag, 9. September 2014 04:21:12 UTC+2 schrieb yzh...@tigs.com.au: Firstly I am using the version 1.7.8 downloaded from the http://orientechnologies.com. What is

Re: [orientdb] How to export a 112 GB database when 2.0 is released

2014-09-09 Thread Emanuel
Hi Curtis, For really use all the feature of the 2.0 version the best way is do the export and the import, but i know that isn't really fast, if is too slow for you feel free to open an issue about it! Copy the file directly should also work and is faster, we have test to guarantee the

[orientdb] Re: Load csv file via ETL

2014-09-09 Thread Sarav
You are right, the etl tool version I have is differnet (based on pom file, it is 0.9.2-SNAPSHOT), but I didn't find the 1.7.8 version of the ETL tool though. Can you share the location of the 1.7.8 ETL please. On Monday, 8 September 2014 19:41:07 UTC+8, Curtis Mosters wrote: I think an

[orientdb] Re: SKIP and Limit does not appear to be working

2014-09-09 Thread yzhong
Thank you for replying. There should be an yellow box some where on this web page that saying the image is not being displayed and there is a option under that for display images. My sql and result are in the screenshot. Also I did meant ASC sorry for the typing mistake. On Tuesday,

[orientdb] Re: Load csv file via ETL

2014-09-09 Thread 'Curtis Mosters' via OrientDB
Well I also have this version. It's the latest but already like 2-3 weeks old. I don't know who is responsible for the ETL plugin. I just think it's not well tested till now. Am Dienstag, 9. September 2014 12:57:56 UTC+2 schrieb Sarav: You are right, the etl tool version I have is differnet

Re: [orientdb] How to export a 112 GB database when 2.0 is released

2014-09-09 Thread 'Curtis Mosters' via OrientDB
I will create one when I have more space on my AWS instance and the 2.0 is officially pre-released. When having problems I will open an issue. Till then. Thanks. Am Dienstag, 9. September 2014 12:32:17 UTC+2 schrieb Emanuele: Hi Curtis, For really use all the feature of the 2.0 version the

[orientdb] Re: SKIP and Limit does not appear to be working

2014-09-09 Thread 'Curtis Mosters' via OrientDB
Please reupload on imgur.com. Google Groups is just crappy. Am Dienstag, 9. September 2014 13:35:48 UTC+2 schrieb yzh...@tigs.com.au: Thank you for replying. There should be an yellow box some where on this web page that saying the image is not being displayed and there is a option under

[orientdb] Re: SKIP and Limit does not appear to be working

2014-09-09 Thread yzhong
I hope in the future this can be hosted somewhere else more stable first image http://imgur.com/qYsCtoL second image: http://imgur.com/PkIFVvE On Tuesday, September 9, 2014 11:13:02 PM UTC+10, Curtis Mosters wrote: Please reupload on imgur.com. Google Groups is just crappy. Am Dienstag, 9.

[orientdb] Create a Composite Unique Constraint (Index) on multiple edges

2014-09-09 Thread Max Matchenko
Hi, For the one vertex, that has two edges, we need to create composite unique constraint using these edges. for example we have the following: *create class V1 extends V* *create class V2 extends V* *create class V3 extends V* *...creating vertexes...* *create class E1 extends E* *create

[orientdb] Why transactions don't work when remote connection is in use? I can't see the changes in console?

2014-09-09 Thread Tomasz Kułakow
1) Why transactions don't work when remote connection is in use? Tutorial says its READ COMMITTED, so it should work. 2) How to check in console if something has changed in the database after program execution? In console i checked orientdb {db} select from #12:0 +-++--- #

[orientdb] Re: Introduction and Vagrant for OrientDb

2014-09-09 Thread Andrea T.
Hi all! I have finished the OrientDB Virtual Box setup with Vagrant. The project is running quite fine. You can download, use and modify from: https://bitbucket.org/nuspy/vagrant-orientdb-with-tinkerpop Please review and comment it! Andrea -- --- You received this message because

[orientdb] Re: OSerialization exception with embeddedmap property with link type linkset

2014-09-09 Thread Jon Fields
Assuming this is a bug: https://github.com/orientechnologies/orientdb/issues/2782 Thanks. On Sunday, September 7, 2014 11:03:32 AM UTC-4, Jon Fields wrote: create class Test1 create property Test1.p embeddedmap linkset desc Test1 Class: Test1 Default cluster..: test1

Re: [orientdb] Why transactions don't work when remote connection is in use? I can't see the changes in console?

2014-09-09 Thread Andrey Lomakin
Hi Tomek, Currently in remote connection SQL commands are not running under transaction, so you should use Java API to perform document changes. For sure we are going to fix this issue in next releases. On Tue, Sep 9, 2014 at 4:25 PM, Tomasz Kułakow tomasz.kula...@gmail.com wrote: 1) Why

[orientdb] looking for find a best Graph DataBase for this structure

2014-09-09 Thread saeed bp
https://lh6.googleusercontent.com/-3kxe0NVCMgA/VA8owdhVh6I/AC0/eJXwBRgoXwU/s1600/graph.png hello i have a simple Graph structure and i want to find a best graph DB solution for this : in this graph structure i just have simple nodes (a BigInt(64bit) value and a String value ) data in

[orientdb] java.lang.IllegalMonitorStateException from OrientDB

2014-09-09 Thread Jing Chen
Hi OrientDB team, We are using 1.7.8 community edition. I saw these message in my program. java.lang.IllegalMonitorStateException at java.util.concurrent.locks.ReentrantLock$Sync.tryRelease(ReentrantLock.java:155) at

Re: [orientdb] java.lang.IllegalMonitorStateException from OrientDB

2014-09-09 Thread Andrey Lomakin
Hi Jing I fixed similar bug on 1.7.9 could you try it ? On Tue, Sep 9, 2014 at 8:55 PM, Jing Chen jingjing...@gmail.com wrote: Hi OrientDB team, We are using 1.7.8 community edition. I saw these message in my program. java.lang.IllegalMonitorStateException at

Re: [orientdb] java.lang.IllegalMonitorStateException from OrientDB

2014-09-09 Thread Dexter Pratt
The other critical point about the error that Jing reports here is that this behavior is only occurring on the CentOS VMs that we have as our deployment platform. We have not seen these errors on our desktop development machines (MacOS, Ubuntu), even when they are executing an exact copy of

Re: [orientdb] java.lang.IllegalMonitorStateException from OrientDB

2014-09-09 Thread Jing Chen
Thanks Andrey. Is there a 1.7.9 package that I can download, or do I need to build one from GitHub? -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [orientdb] java.lang.IllegalMonitorStateException from OrientDB

2014-09-09 Thread Andrey Lomakin
You can use maven repository or helios.orientechnologies.com/job/orient-maven-1.7.9/lastStableBuild/ . On Tue, Sep 9, 2014 at 9:33 PM, Jing Chen jingjing...@gmail.com wrote: Thanks Andrey. Is there a 1.7.9 package that I can download, or do I need to build one from GitHub? -- --- You

[orientdb] Storage not closed properly when using plocal and tinkerpop orientGraphFactory

2014-09-09 Thread Seamus Minogue
I am having a problem with closing a plocal orient database properly when using the tinkerpop graph factory api. orientGraphFactory = new OrientGraphFactory(plocal: + secureProperties. getProperty(orientdb), admin, admin); orientGraphFactory.getDatabase().getStorage().getConfiguration().

Re: [orientdb] java.lang.IllegalMonitorStateException from OrientDB

2014-09-09 Thread Jing Chen
Hi Andrey, I downloaded 1.7.9 from this link https://oss.sonatype.org/content/repositories/snapshots/com/orientechnologies/orientdb-community/1.7.9-SNAPSHOT/orientdb-community-1.7.9-20140908.212816-6-distribution.tar.gz Does this build have your fixes in it? I still get the same error when

[orientdb] Connection pool and multithread environment

2014-09-09 Thread Guilherme Moreira
Hi. We are working on a web application using OrientDB. Each request spawn a new thread on the web server. We have a single instance of OrientGraphFactory and it create a OrientGraph for each request (thread) and at the end call graph.shutdown. Is this the best way to handle connections on

Re: [orientdb] Connection pool and multithread environment

2014-09-09 Thread Luca Garulli
Hi Guilherme, I confirm this is the best way. With 2.0-SNAPSHOT we speed up the pool to be much lighter than 1.7.x. What release are you using? Lvc@ On 9 September 2014 22:44, Guilherme Moreira guilherme1135.microb...@gmail.com wrote: Hi. We are working on a web application using OrientDB.

Re: [orientdb] Create a Composite Unique Constraint (Index) on multiple edges

2014-09-09 Thread Luca Garulli
Hi, Create it on base class, so E in this case. Lvc@ On 9 September 2014 15:28, Max Matchenko mmatche...@gmail.com wrote: Hi, For the one vertex, that has two edges, we need to create composite unique constraint using these edges. for example we have the following: *create class V1

Re: [orientdb] Re: Introduction and Vagrant for OrientDb

2014-09-09 Thread Luca Garulli
Hi Andrea, Thanks for the contribution! I've enlisted it on Installation page: https://github.com/orientechnologies/orientdb/wiki/Tutorial-Installation Tomorrow it will be on the official documentation. Thanks, Lvc@ On 9 September 2014 17:06, Andrea T. a.ta...@gmail.com wrote: Hi all! I

Re: [orientdb] java.lang.IllegalMonitorStateException from OrientDB

2014-09-09 Thread Andrey Lomakin
Him .. Let me check then . On Sep 9, 2014 10:26 PM, Jing Chen jingjing...@gmail.com wrote: Hi Andrey, I downloaded 1.7.9 from this link

Re: [orientdb] Why transactions don't work when remote connection is in use? I can't see the changes in console?

2014-09-09 Thread Tomasz Kułakow
Thanks for your response, I'll use plocal then. And why changes are not visible in the console immediately? I can see them after restarting the console. -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and