Re: [orientdb] Re: [announcement] Moving to StackOverflow!

2015-10-02 Thread Andrey Lomakin
It is my personal opinion. I think we may use social networks and pool engines for such kind of interaction. Twitter + LinkedIn IMHO is more efficient tool for announcements and feedback requests than mailing group. On Sat, Oct 3, 2015 at 7:58 AM Wouter de Vaal wrote: > Good idea. > > But wha

[orientdb] Re: [announcement] Moving to StackOverflow!

2015-10-02 Thread Wouter de Vaal
Good idea. But what will happen to announcements, feedback requests and such? Wouter Op vrijdag 2 oktober 2015 16:58:18 UTC+2 schreef l.garulli: > > Hi guys, > In the last year, *StackOverflow* has become the most popular way to ask > support for any kind of technology. We saw also the trend of

[orientdb] Cannot open local storage with mode=rw

2015-10-02 Thread Tsadok Levi Firseck
Hi, I'm using JMeter to run against a OrientDb database. I've already managed to connect to the database (using factory), retrieve vertices, etc. (that was not a trivial task, BTW). My problem now is that after the code runs, and despite the fact that I call shutdown() on the OrientGraph ins

[orientdb] Re: detach

2015-10-02 Thread Ravi Kapoor
Thanks xvik that worked perfectly. Such a simple solution. Thanks Alessandro for helping. Can I present one more problem? I created 'Person' class so it can have more Person as children. I create structure of "Parent" -> "Child" -> "Grand child" and save it. (This works very well) I read the

[orientdb] Get all ancestors from vector ?

2015-10-02 Thread Sebastien Berthezene
Hi, I a new to OrientDB then not very comfortable with SQL for graph. How can i get all ancestor from a vertex ? Considering following definitions : Class Vertex "Folder" extends V,ORestricted Class Vertex "Document" extends V,ORestricted Class Edge "HasFolder" extends E Class E "HasDocument" ex

Re: [orientdb] Re: Speed of count(*) with traverse

2015-10-02 Thread Simon White
https://drive.google.com/folderview?id=0B1XDdHD2qRLScVBlemtLQ3pxOTA&usp=sharing -- --- 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...@goo

Re: [orientdb] Re: Speed of count(*) with traverse

2015-10-02 Thread Simon White
I have cut the database down to just one day of logs, the logs are all stored against today (02/10/2015) The database schema looks like... years -> months -> days -> hours -> minutes -> logs My use case is to first count and then (potentially) return all the logs for a given *month *for a giv

[orientdb] [announcement] Moving to StackOverflow!

2015-10-02 Thread Luca Garulli
Hi guys, In the last year, *StackOverflow* has become the most popular way to ask support for any kind of technology. We saw also the trend of OrientDB users on StackOverflow is growing every month. For this reason, starting from now, the *OrientDB Team will invest more time answering on the Stack

[orientdb] Re: 2.1.1 broke calculations in sql

2015-10-02 Thread alexander anguiano
Ok, it looks like there a way to do this, you must use the eval select hostname, date().asLong(), $agent.lastCommunicationTime[0].asLong() , eval(' date().asLong() - $agent.lastCommunicationTime[0].asLong()'), $agent.version as agentVersion, $agent.lastCommunicationTime as lastCommunication

[orientdb] Re: Select vertices which has incoming vertices from one or two different classes (Optimization)

2015-10-02 Thread alessandrorota04
Hi Bharath, I could not test it on the database at the time, however try this query select ref_id from (select ref_id, count(@rid) as counts from (select expand(in("hasCui")) from Cui where ref_id='C0024530' or ref_id='C0013090') group by @rid) where counts>1 and let me know. Kind regards, Ales

Re: [orientdb] Using OrientDB to improve web application security

2015-10-02 Thread Andrey Lomakin
Hi sure, If your result will be successful maybe you will consider write a blog entry about this user case ? On Fri, Oct 2, 2015 at 1:38 PM Argh Skwidge wrote: > Hi Andrey, > > Thanks, that is a solution I had completely missed, I will try that. It > looks like I wasted a bit of time there writi

Re: [orientdb] Re: Speed of count(*) with traverse

2015-10-02 Thread Simon White
Thank you so much for your offer of help, would I just attach a zip of the database here? On Friday, October 2, 2015 at 7:52:57 AM UTC+1, Luigi Dell'Aquila wrote: > > Hi Simon, > > no, defining an index on the device name won't help. > Could you please share a sample db? I'd like to try your qu

Re: [orientdb] Error on parsing query Found invalid ) character

2015-10-02 Thread Luigi Dell'Aquila
Hi Alain, thanks a lot, I'll check it soon Thanks Luigi 2015-10-02 10:44 GMT+02:00 Alain : > Hi Luigi, > I also noticed the problem and appended the bug > https://github.com/orientechnologies/orientdb/issues/4996 with my case. > > Thank you, > > > Le jeudi 1 octobre 2015 06:58:54 UTC+2, Luigi

Re: [orientdb] Using OrientDB to improve web application security

2015-10-02 Thread Argh Skwidge
Hi Andrey, Thanks, that is a solution I had completely missed, I will try that. It looks like I wasted a bit of time there writing my dodgy connection pool :-/ I notice OPartitionedDatabasePoolFactory is not even mentioned in the manual and OPartitionedDatabasePool is mentioned only briefly.

[orientdb] ObjectAPI: Custom collection interface, implementation, possible?

2015-10-02 Thread Andrii Hrishyn
Hi everyone! Now i playing with OrientDB 2.1.2 ObjectAPI trying to adapt it for already working old project. In this project i have POJO classes containing fields with specific collection interfaces (for example map) like below: public class MyPOJOs { private CustomMap customMap; ... } pub

Re: [orientdb] different query behavior when using Java API vs using Studio - oDB v2.1.0

2015-10-02 Thread Luigi Dell'Aquila
Hi Mihai the difference is that your query will result in something like following: select from V_Comment where in('E_DocComment').@rid in [ "#19:5" ] that is quite different from select from V_Comment where in('E_DocComment').@rid in [ #19:5 ] You can achieve the same result just passing an O

[orientdb] different query behavior when using Java API vs using Studio - oDB v2.1.0

2015-10-02 Thread Mihai Ocneanu
If I run the following query in studio: select from V_Comment where in('E_DocComment').@rid in [ #19:5 ] I get one result, as expected. If I run this code, using the Java API I get no results. OrientGraphFactory graphFactory = new OrientGraphFactory(SERVER_URL, USER_LOGIN, USER_PASS); Strin

Re: [orientdb] Error on parsing query Found invalid ) character

2015-10-02 Thread Alain
Hi Luigi, I also noticed the problem and appended the bug https://github.com/orientechnologies/orientdb/issues/4996 with my case. Thank you, Le jeudi 1 octobre 2015 06:58:54 UTC+2, Luigi Dell'Aquila a écrit : > > Hi Ravinder, > > I lost track of this, was it reported in the issue tracker? > If

[orientdb] Re: detach

2015-10-02 Thread xvik
When you need to use pure pojo instead of proxy you have to introduce new reference: *Element rootPojo =* dbTx.detachAll(root, true); пятница, 2 октября 2015 г., 0:45:24 UTC+6 пользователь Ravi Kapoor написал: > > > Hi Alessandro, > > You used > > dbTx.detachAll(root, false); > > > This h

[orientdb] Re: What is the URL to download latest 2.1.X SNAPSHOT

2015-10-02 Thread alessandrorota04
Hi, https://github.com/orientechnologies/orientdb/branches/active Kind regards, Alessandro -- --- 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+un

[orientdb] upsert/merge/constraints based on connections

2015-10-02 Thread MicahH
New to orient and I am not finding a way to do the following Imagine a Folder/File tree where every File is uniquely named in a Folder--I would like to represent a structure like this in a graph: Folder--contains-->File I can create the structure but I do not see any good way to deal with