[orientdb] Is "case .. when .. else" supported?

Hi, I have looked at OrientDB SQL Syntax, but i cannot see how to work with "case...when" statement. Can i use it in OrderBy clause? Any help will be very appreciated! My Best, Hung Tran -- --- You received this message becaus

Re: [orientdb] [JAVA] WARNING: Create the classes outside the transaction

Yeah but the same behaviour appears if i do this: this.graph.createEdgeType("edge", "E"); this.graph.createKeyIndex("value", Edge.class); Edge edge = this.graph.addEdge("edge", outVertex, inVertex, "example"); if(property != null) { edge.setProperty("value", property); } So i have a subclas

Re: [orientdb] Case insensitive filtering and sorting

Hi Luca, It would be nice to have function-based index, that's very interesting feature in Oracle. Of course, it could be workaround by storing data in lowercase, however it will duplicate data. My Best, Hung Tran On Sunday, August 26, 2012 6:21:21 PM UTC+7, Lvc@ wrote: > > Hi Maciek, > case i

[orientdb] what are files with hib extension?

Hi, I have just looked at database folder, i found there are a lot of hib files, they are consume a lot of disk drive compare to data files (och, ocl). What are they for? how could i configure the size of these files? For example, AuditLog.EntityType0.hib - 16778240 AuditLog.EntityType.him - 1

Re: [orientdb] why ODocument requires db connection

The error is gone if I do not provide class name at new ODocument(). but it would be trouble when having an object tree On Sunday, April 20, 2014 5:06:16 AM UTC-4, Lvc@ wrote: > > Hi Ted, > I think this would add only complexity to the current management. In your > case (create the document deta

Re: [orientdb] Re: 1.7-SNAPSHOT build failing today

Hi, I moved to the snapshot again, things work fine. Regards, -Stefán On Sunday, 20 April 2014 22:36:46 UTC, ste...@activitystream.com wrote: > > > > com.orientechnologies > orientdb-graphdb > 1.7-rc2 > > > On Sunday, 20 April 2014 10:58:36

Re: [orientdb] Re: 1.7-SNAPSHOT build failing today

com.orientechnologies orientdb-graphdb 1.7-rc2 On Sunday, 20 April 2014 10:58:36 UTC, Lvc@ wrote: > > Where it comes from? We've updated all the references to 2.5.0. Can you > see at what point it loads it? > > Lvc@ > > > > On 20 April 2014 1

Re: [orientdb] Re: Problems and Exceptions with Distributed DB Configuration

Another problem: if I want to access the plocal DB and the server is running, I get the following log-messages in JAVA and the program is running in an endless loop: Apr 20, 2014 10:40:29 PM com.orientechnologies.common.log.OLogManager log WARNING: segment file 'database.ocf' was not closed corr

Re: [orientdb] Re: Getting Error: java.lang.IndexOutOfBoundsException: Requested index 0 when the range is 0-0

Hi Mirzhan, please try with 1.7-SNAPSHOT to see if the error is gone. Lvc@ On 20 April 2014 20:18, Mirzhan Kuanshaliyev wrote: > Hi, > I have same problem with 1.6.4 version, how did you deal with that error? > > понедельник, 14 января 2013 г., 14:33:10 UTC+6 пользователь > orientdbexplorer н

Re: [orientdb] Re: Getting Error: java.lang.IndexOutOfBoundsException: Requested index 0 when the range is 0-0

Hi, I have same problem with 1.6.4 version, how did you deal with that error? понедельник, 14 января 2013 г., 14:33:10 UTC+6 пользователь orientdbexplorer написал: > > Thanks Luca. Most of the code has been written already using 1.2 and I > encountered this issue while load testing. I will de

Re: [orientdb] Re: Problems and Exceptions with Distributed DB Configuration

Hi, thanks for your answer. Where can I get the latest snapshot? I use 1.7 RC2 and I've downloaded it on the 1st of April 2014. Ok, when I set hotAlignment = false, I receive the latest update. But I've tested sth.: let's say one node gets "offline" because there's no more network connection. Th

Re: [orientdb] FETCHPLAN - How to LINK / LINKSET when pointing to same record ?

Luca, here is the request in bug system: https://github.com/orientechnologies/orientdb/issues/2259 If its not of much work, can it be added in next stable release ? Regards, Gaurav On Sunday, April 20, 2014 3:06:22 PM UTC+5:30, Gaurav Dhiman wrote: > > Cyclic reference check should be avoided

Re: [orientdb] Re: Problems and Exceptions with Distributed DB Configuration

Hi, thanks for your answer. Where can I get the latest snapshot? I use 1.7 RC2 and I've downloaded it on the 1st of April 2014. Ok, when I set hotAlignment = false, I receive the latest update. But I've tested sth.: let's say one node get "offline" because there's no network connection. Then let

Re: [orientdb] Embedded List Query Performance In OrientDB

Hi, Lvc: Here is the result: orientdb {compounds}> select count(*) from Compound where '75-72-9' in cas +-+- # |@RID |count +-+- 0 |#-2:0|1 +-+- 1 item(s) found. Query executed in 222.285 sec(s). On Sunday, April 20, 2014 4:38:59 PM UTC+8, Lvc@ wrot

Re: [orientdb] full-text search OR query

Hi all, The suggestions with parenthesis and boolean values make the SQL harder to read than needed (I can imagine having to check the documentation to determine what *CONTAINSTEXT(true, true)* is doing). When using a fulltext index it's a bit odd that a given string (e.g "graph databases") th

Re: [orientdb] create edge to super node, performance degradation under multi threads

Ok, it works with UPDATE. I guess there is still no way to use CREATE EDGE without CME? On Sunday, April 20, 2014 11:14:00 AM UTC+2, Lvc@ wrote: > > Hi Pawel, > the problem we found is that current implementation of storage stack > doesn't support concurrent pessimistic locking, because in tra

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

Hi Emmanuel, sure you can use the RDF store on top of Blueprints. About tracking changes you could write an hook to handle such changes and propagate updates. Lvc@ On 20 April 2014 13:14, wrote: > Hello > > I'm currently using a RDF store and I consider to move to orientDB because > some of my

Re: [orientdb] Issue between Gremlin and V1.7

Hi Anthony, create the database as plocal and use always plocal to open it, but if you're using a server, then "remote" is ok. Lvc@ On 20 April 2014 13:18, Anthony Buckton wrote: > HI All, > > I've been going along merrily writing a Java app with the V1.7-snapshot: > > > com.o

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

Hello I'm currently using a RDF store and I consider to move to orientDB because some of my requirements are not met. My database stores data related to music meta-data, some predefined and some user defined. With the value of a RDF triplet (subject, property, value) I need to store some annot

[orientdb] Issue between Gremlin and V1.7

HI All, I've been going along merrily writing a Java app with the V1.7-snapshot: com.orientechnologies orient-commons 1.7-SNAPSHOT bundle com.orientechnologies orientdb-core 1.7-SNAPSHOT bu

Re: [orientdb] Re: 1.7-SNAPSHOT build failing today

Where it comes from? We've updated all the references to 2.5.0. Can you see at what point it loads it? Lvc@ On 20 April 2014 11:43, wrote: > Hi, > > I'm still getting these: > > Downloading: http://maven.restlet.org/com/tinkerpop/gremlin/gremlin- > groovy/2.5.0-SNAPSHOT/gremlin-groovy-2.5.0-S

Re: [orientdb] Re: Create edge after import from rdbms

I created this js function to resolve the problem: function(masterTableName,masterTableName, linkedTableName, linkedPkName, edgeName){ var cursor=db.query("select "+ linkedPkName + " from "+ linkedTableName); if(cursor!=null){ for(var i=0; i > Hi Gianpaolo, > sorry but such creation of links i

Re: [orientdb] Re: 1.7-SNAPSHOT build failing today

Hi, I'm still getting these: Downloading: http://maven.restlet.org/com/tinkerpop/gremlin/gremlin-groovy/2.5.0-SNAPSHOT/gremlin-groovy-2.5.0-SNAPSHOT.jar [INFO] Unable to find resource 'com.tinkerpop.gremlin:gremlin-groovy:jar:2.5.0-SNAPSHOT' in repository Any ideas? Regards, -Stefán

Re: [orientdb] FETCHPLAN - How to LINK / LINKSET when pointing to same record ?

Cyclic reference check should be avoided if the fetch plan do not have infinite depth (cases where depth is greater or equal to 0). What you think ? Regards, Gaurav On Apr 20, 2014 3:00 PM, "Gaurav Dhiman" wrote: > Hi Luca, > > Thanks for response. > > Yes I knew that its done to avoid cyclic r

Re: [orientdb] FETCHPLAN - How to LINK / LINKSET when pointing to same record ?

Hi Luca, Thanks for response. Yes I knew that its done to avoid cyclic reference else fetch will for in infinite loop. My point is, this check for cyclic reference should only be applied if infinite depth (-1) is given in fetch plan. Also as you suggested, additional option to avoid cyclic check

Re: [orientdb] Re: Remove embeddedset item by reference?

Hi, Sorry for the delay. May you try: update #5:12 remove people 0 Lvc@ On 18 April 2014 16:35, Jonathan Rosen wrote: > I asked Luca a question about this that he didn't respond to. I didn't > create the issue because we never clarified how this needs to be fixed. > > > On Fri, Apr 18, 2014 a

Re: [orientdb] Re: Transactions in a distributed environment lead to a corrupt database

Hi guys, As Mateusz pointed the quorum settings should be to 2 and failureAvailableNodesLessQuorum = true to maintain consistency. Then I suggest you to try 1.7-SNAPSHOT where we fixed a few issues against distributed configuration. About your database is it a plocal? The fact your logs show OMVRB

Re: [orientdb] create edge to super node, performance degradation under multi threads

Hi Pawel, the problem we found is that current implementation of storage stack doesn't support concurrent pessimistic locking, because in transaction they can go in dead-lock. We already have a solution for this, but we should wait the 2.0. Can you rather try this? let var1 = INSERT INTO Actor CO

[orientdb] Re: create edge to super node, performance degradation under multi threads

*Seems that Update command is in deadlock with commit. Below is my analysis* "OrientDB <- BinaryClient (/127.0.0.1:45192)@6427" daemon prio=5 tid=0x3bb nid=NA waiting java.lang.Thread.State: WAITING at sun.misc.Unsafe.park(Unsafe.java:-1) at java.util.concurrent.locks.LockSupport.parkNanos(

Re: [orientdb] why ODocument requires db connection

Hi Ted, I think this would add only complexity to the current management. In your case (create the document detached and then save against the graph) it's easier setting the class before to save() it. Have you tried it? Lvc@ On 18 April 2014 17:27, Ted Smith wrote: > Thanks. > > Perhaps an

Re: [orientdb] Re: stupid graph display question

Hi Eric, current version of Studio hasn't the display as graph anymore. This is because we rewrote Studio (now uses Angular.js) and we're working now to the new display panel, much more cooler than before. If you want to use OrientDB from .NET, just install it (look at the right Installation page)

Re: [orientdb] Re: Create edge after import from rdbms

Hi Gianpaolo, sorry but such creation of links is not yet supported: https://github.com/orientechnologies/orientdb/issues/2045 This issue is scheduled for 2.0 and this feature is in draft now. In the meanwhile you could create your own batch or use CREATE LINK mimic the graph behavior: https://g

Re: [orientdb] Re: Problems and Exceptions with Distributed DB Configuration

Hi, Sorry for such delay on answer. We're improving the distributed part in these days by enriching the documentation with new example for replication and sharding. Stay tuned! In the meanwhile may you try last 1.7-SNAPSHOT? We fixed some issues about replication. And if the synchronization with o

Re: [orientdb] FETCHPLAN in SELECT command not working

Hi Gaurav, yes that's the reason. Look at the other your message in this forum. Lvc@ -- --- 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 orient-database+unsubscr.

Re: [orientdb] FETCHPLAN - How to LINK / LINKSET when pointing to same record ?

Hi Gaurav, this is to avoid cyclic references. Think to the case you've the same RID in your graph: it would be recursively infinite. But in your case could have sense to just always expand records even if already expanded. AFAIK we don't have such setting on fetch-plan. May you create a new issue

Re: [orientdb] Re: 1.7-SNAPSHOT build failing today

Hi Stefan, the build is correct now (I've introduced test cases for sharding). Lvc@ On 20 April 2014 09:47, wrote: > > are we there yet? > > > On Saturday, 19 April 2014 10:16:30 UTC, Lvc@ wrote: > >> Hi guys, >> my fault by pushing the wrong branch. I'm going to fix it in short time. >> >> L

Re: [orientdb] Issues with Batch Commit and Edge.setProperry()

On 20 April 2014 06:10, Aditya Gote wrote: > We are using : *orientdb-community-1.7rc2* > > We are undergrad students working on REST implementation of OrientDB > We are facing a very strange behaviour. Let me explain what we are trying > to do. > We want to create an Edge between 2 Vertex and we

Re: [orientdb] Adding Edge properties during vertex.addEdge()

Hi Stefan, you can do it with Standard Blueprints API: OrientEdge edge = some_orient_vertex.addEdge(, in_vertex); edge.setProperty( "name", "Stefan" ); Or for multiple properties: edge.setProperties( "name", "Stefan", "tag", "orientdb-user" ); Or even: Map properties = new HashMap wrote: > Hi

Re: [orientdb] Embedded List Query Performance In OrientDB

Hi Jack, if you execute this: select count(*) from Compound where '75-72-9' in cas How many records are retrieved? How much time does it take? Lvc@ On 20 April 2014 07:07, Wise Jack wrote: > Has anyone got a suggestion? > > > On Tuesday, April 15, 2014 10:00:19 AM UTC+8, Wise Jack wrot

[orientdb] Issues with Batch Commit and Edge.setProperry()

We are using : *orientdb-community-1.7rc2* We are undergrad students working on REST implementation of OrientDB We are facing a very strange behaviour. Let me explain what we are trying to do. We want to create an Edge between 2 Vertex and we want to do this for batches. And perform batch commit

Re: [orientdb] Re: 1.7-SNAPSHOT build failing today

are we there yet? On Saturday, 19 April 2014 10:16:30 UTC, Lvc@ wrote: > > Hi guys, > my fault by pushing the wrong branch. I'm going to fix it in short time. > > Lvc@ > > > On 19 April 2014 10:04, > wrote: > >> Hi, >> >> I'm also getting these in volume: >> >> Downloading: >> http://maven.restl