Re: [orientdb] Nodes and Edges

2014-06-10 Thread Thomas Kennedy
Hi Luca, The node is traversed from #11:0. The vertices A are connected by an edge called connects. I need to return all nodes and all links. Regards, Tom @Class RID Name In out - A | #11:0 | Link1 A | #11:1 | Link2 A | #11:2 | Link3 A | #11:3 | Link4 Connects

Re: [orientdb] custom functions in console

2014-06-10 Thread Artem Orobets
Hi, Registration of function via *registerFunction* is different from its registration in OFunction. *registerFunction*() is rather for native java functions, while *OFunction* is for functions on dynamic languages (sql, JS). You might call *registerFunction* on client, so the server know

[orientdb] Can OrientDB use indexes for filtering and sorting on a subquery result?

2014-06-10 Thread Wouter de Vaal
Hi, We have an ARTICLE - SUPPLIER - COUNTRY database, with loads of ARTICLE records, quite a few SUPPLIER records and some COUNTRY records. Now if we want to filter on articles with a supplier in a certain country we can do this fast enough by querying like this: select from (select

[orientdb] [JAVA] Getting all elements of an index (all keys)

2014-06-10 Thread Montrazul
Hi, i have two different indices on my vertextype for two different properties. I found the method: graph.getIndexedKeys(elementClass) Is there a possibility to get all elements of the index i specify? With this method i get all indexedKeys but i just want to get the indexedKeys of one index

[orientdb] i want to maintain array of data in a property

2014-06-10 Thread jaya raj
hi, i have one property X to different type of clusters in an array for example X - [#11:0,#12:0,#19:0,#11:1] i have append new cluster id [#11:3] in X property after append cluster id X property look like this X - [#11:0,#12:0,#19:0,#11:1,#11:3] how can i do it pls help me... --

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

2014-06-10 Thread Carlo Polisini
It seems you are getting same exception of me, infact getProviderUtil in OJPAPersistenceProvider it'is not implemented and raise an UnsupportedOperationException(getProviderUtil) whenever is called. https://groups.google.com/forum/#!topic/orient-database/n03vpYocia4 On Tuesday, June 10, 2014

Re: [orientdb] Can OrientDB use indexes for filtering and sorting on a subquery result?

2014-06-10 Thread Artem Orobets
Hi Wouter, It is not really that easy to improve performance of subquery with index. Because in a sub-query you select records from subset created somehow but not from class. General approach in this case is to rewrite your query in more efficient way, change schema or create a manual index.

Re: [orientdb] $path returns only one record. How come?

2014-06-10 Thread Artem Orobets
Hi Bokyum, The TRAVERSE command is not designed to find all paths between nodes. To prevent going into a loop it does not traverse nodes that has already been handled. To find all paths between vertexes you can use gremlin query or write your own function. Best regards, Artem Orobets * Orient

Re: [orientdb] Can OrientDB use indexes for filtering and sorting on a subquery result?

2014-06-10 Thread Wouter de Vaal
Hi Artem, Thanks, I thought as much. One approach for us would be to denormalize data, but I am looking if there exists a way where I wouldn't need to maintain multiple classes/indexes for this to work. Would it be possible to create an index over multiple classes including the relations or

Re: [orientdb] [JAVA] Getting all elements of an index (all keys)

2014-06-10 Thread Montrazul
And when i never ever want to use SQL? ;) Ofcourse it would be an easy solution but i dont want to break my design rules. I could do this: 1. Select all vertices of the vertex type 2. Iterate over the vertices 3. Get all properties of each vertex and store it in a list 4. return

Re: [orientdb] [JAVA] Getting all elements of an index (all keys)

2014-06-10 Thread Montrazul
And when i never ever want to use SQL? ;) Ofcourse it would be an easy solution but i dont want to break my design rules. I could do this: 1. Select all vertices of the vertex type 2. Iterate over the vertices 3. Get the indexed property of each vertex and store it in a list 4.

[orientdb] Re: Released OrientDB 1.7.2 hotfix

2014-06-10 Thread MrFT
Thanks, nice to see that every week a few more bugs are being fixed ! Op zaterdag 7 juni 2014 16:58:50 UTC+2 schreef Lvc@: Hi guys, We fixed some important bugs found in 1.7.1: https://github.com/orientechnologies/orientdb/issues?milestone=19page=1state=closed Please update your 1.7

Re: [orientdb] Can OrientDB use indexes for filtering and sorting on a subquery result?

2014-06-10 Thread Artem Orobets
Hi Wouter, Would it be possible to create an index over multiple classes including the relations or something like that? No, automatic indexing over multiple classes is not supported. You can try to play with a composite index over in_ARTICLE_SUPP_NR and other field and do select from article

Re: [orientdb] [JAVA] Getting all elements of an index (all keys)

2014-06-10 Thread Artem Orobets
Hi, You can always use Orient API if you don't like SQL. Just get the index from OIndexManager and call com.orientechnologies.orient.core.index.OIndex#keyCursor, then use this cursor to iterate over keys. This is the most efficient way. Just Best regards, Artem Orobets * Orient

[orientdb] Elasticsearch river for Orientdb similar to Neo4J ES river

2014-06-10 Thread Shishya
Hi, I am planning to create an OrientDB ES river similar to Neo4J river of ES. Anyone interested to co-op or throw some ideas about it? Greatly appreciate! -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and

Re: [orientdb] Can OrientDB use indexes for filtering and sorting on a subquery result?

2014-06-10 Thread Wouter de Vaal
Hi Artem, Thanks for the info. Do I understand correctly that a lightweight edge is an edge without any properties? Wouter Op dinsdag 10 juni 2014 12:27:14 UTC+2 schreef Artem Orobets: Hi Wouter, Would it be possible to create an index over multiple classes including the relations or

[orientdb] Re: Elasticsearch river for Orientdb similar to Neo4J ES river

2014-06-10 Thread Shishya
Missed to add link of Neo4J ES river https://github.com/sksamuel/elasticsearch-river-neo4j On Tuesday, June 10, 2014 4:03:20 PM UTC+5:30, Shishya wrote: Hi, I am planning to create an OrientDB ES river similar to Neo4J river of ES. Anyone interested to co-op or throw some ideas about it?

[orientdb] UNION query returns wrong result set with OSQLSynchQuery

2014-06-10 Thread Hung Tran
Hi, I am using OrientDB v1.7. Today, I perform a query via API with OSQLSynchQuery, it returns a wrong result. SELECT @rid AS __x0, ifnull(Name,'',Name) AS __x1, ifnull(CreationDate,'',CreationDate) AS __x2, ifnull(LastActivityDate,'',LastActivityDate) AS __x3,

[orientdb] Indexing Problem (Unique Constraint not triggert, entries not found)

2014-06-10 Thread Chris Klinger
Hey, im trying to save some objects to the database, i have a unique constraint defined on my class product. The code looks like this: graphDbFactory = new OrientGraphFactory(plocal: + server.getDatabaseDirectory() + File.separator + graphDatabase, userName, userPassword); graphInstance =

Re: [orientdb] Current implementation of storage does not support sbtree collections

2014-06-10 Thread thomasbp2024
Hi, I am using memory graph: my OrientDB graph is an in-memory datagraph over an Oracle Database. In OrientDB 1.5 the composite index was working well for memory graph (I have done all my tests with 1.5). But not any longer in 1.7 so I am using a naive BTree impementation as an index

Re: [orientdb] Can OrientDB use indexes for filtering and sorting on a subquery result?

2014-06-10 Thread Artem Orobets
Hi Wouter, Lightweight edge is the edge that does not created as a record in an underlying database. By default OrientDB optimize all edges without properties to lightweight. Best regards, Artem Orobets * Orient Technologiesthe Company behind OrientDB* 2014-06-10 13:34 GMT+03:00 Wouter de

Re: [orientdb] [JAVA] Getting all elements of an index (all keys)

2014-06-10 Thread Montrazul
Im sorry but i have no idea what you are talking about. How do i get the OIndexManager? Its an Interface as i can see in documentation. No method of OrientBaseGraph returns OIndexManager. When i call graph.getIndices() the iterator contains no index. Am Dienstag, 10. Juni 2014 12:31:52 UTC+2

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

2014-06-10 Thread alexander anguiano
I don't use play, but i saw your threads. I also don't use jpa. I'm using dropwizard that uses hibernate for validation. The hibernate in dropwizard is somehow causing the jpa to activate. I have no fix for this. On Tuesday, June 10, 2014 2:54:18 AM UTC-5, Carlo Polisini wrote: Thanks

Re: [orientdb] [JAVA] Getting all elements of an index (all keys)

2014-06-10 Thread Montrazul
OIndex? index = this.graph.getRawGraph().getMetadata().getIndexManager().getIndex(indexName); OIndexKeyCursor cursor = index.keyCursor(); When i call this the cursor is null. System.out.println(index.getFirstKey()); getFirstKey() is also null. The index is created, filled and working. Its the

[orientdb] Re: Problem with OrientDB1.6.2 on the Raspberry PI

2014-06-10 Thread Eric Schreiner
...we have now tried with 1.7 final and still have the same problem: (please see config and stacktrace below) INFO @ 14:52:50.147 PicApportDBService.setDbConfig.setDbConfig:*/root/*.picapport/orientdb.properties DEBUG@ 14:52:50.151 PicApportDBService.setDbConfig: - start dump

Re: [orientdb] Re: Problem with OrientDB1.6.2 on the Raspberry PI

2014-06-10 Thread Luca Garulli
Hi, I see you've the default cfg, but the storage.diskCache.bufferSize can't be 4GB on a RaspberryPI! Try setting it to 300MB or less. Edit the server.sh file and put this configuration: java ... -Dstorage.diskCache.bufferSize=300 Lvc@ On 10 June 2014 15:15, Eric Schreiner

Re: [orientdb] Re: Elasticsearch river for Orientdb similar to Neo4J ES river

2014-06-10 Thread Artem Orobets
Cool! OrientDB allow to do that in more efficient way than pooling. Take a look at hooks API. Best regards, Artem Orobets * Orient Technologiesthe Company behind OrientDB* 2014-06-10 13:34 GMT+03:00 Shishya prabha...@gmail.com: Missed to add link of Neo4J ES river

Re: [orientdb] [JAVA] Getting all elements of an index (all keys)

2014-06-10 Thread Montrazul
Yes Am Dienstag, 10. Juni 2014 17:13:37 UTC+2 schrieb Artem Orobets: Hi Montrazul, Are you trying that with Lucene index? Best regards, Artem Orobets * Orient Technologiesthe Company behind OrientDB* 2014-06-10 18:03 GMT+03:00 Montrazul tigge...@googlemail.com javascript:: Maybe

[orientdb] Re: Problem with OrientDB1.6.2 on the Raspberry PI

2014-06-10 Thread Eric Schreiner
Sorry but no change... We also tried -Dstorage.diskCache.bufferSize=100: -Dstorage.diskCache.bufferSize=300: DEBUG@ 16:28:09.476 PicApportDBService.setDbConfig: - start dump db-configur ation -

Re: [orientdb] [JAVA] Getting all elements of an index (all keys)

2014-06-10 Thread Artem Orobets
Hi Montrazul, Are you trying that with Lucene index? Best regards, Artem Orobets * Orient Technologiesthe Company behind OrientDB* 2014-06-10 18:03 GMT+03:00 Montrazul tigges.m...@googlemail.com: Maybe a problem with lucene index? Am Dienstag, 10. Juni 2014 14:16:03 UTC+2 schrieb

Re: [orientdb] OTransactionOptimistic and transaction start counter

2014-06-10 Thread Andrey Lomakin
Hi Odysseas, Could you provide information which I asked in issue ? On Thu, Jun 5, 2014 at 8:34 PM, Odysseas odysseaspe...@gmail.com wrote: Hi Andrey, No, we do not invoke tx.begin() before performing any operations using connections from the pool. I will open a case for this. Thanks,

[orientdb] Tree structure with data inheritance

2014-06-10 Thread Darius Felski
Hello! I need a hint for a scenario with a tree structure and data inheritance. There is a simple node hierarchy with a parent-children relationship: Parent node: { 'name' : 'parentNode', 'color' : { inheritable : true, 'value' : 'red' }, 'speed' : { inheritable : false, 'value' : 'fast' } }

Re: [orientdb] should I move from a RDF store to orientDB ?

2014-06-10 Thread Justin Harris
I've been trying to use OrientDB as a RDF store. Sail provides some good resources to help you load RDF https://github.com/tinkerpop/blueprints/blob/master/blueprints-sail-graph/src/main/java/com/tinkerpop/blueprints/impls/sail/SailGraph.java#L348 but they get much slower after loading

Re: [orientdb] should I move from a RDF store to orientDB ?

2014-06-10 Thread Justin Harris
I think I've managed to keep the speed consistent by disabling WAL: OGlobalConfiguration.USE_WAL.setValue(false); I got some helpful tips from this thread: https://groups.google.com/forum/#!starred/orient-database/PxgQggsOvU8 even though now I get: Jun 11, 2014 12:48:54 AM

[orientdb] I want do rollback and commit in orientdb-php driver

2014-06-10 Thread jaya raj
hi, i want do rollback and commit, i'm using orientdb-php driver still not yet implemented so pls help me.. -- --- 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