[orientdb] Re: as serious in this graph orientdb mysql query

Hi Renzo, Try this query: SELECT in('hasBusinessLocation').title as title,in('hasBusinessLocation').content as content,address,tags FROM BusinessLocation WHERE (address like '%TEXT%') or (tags contains '%TEXT%') or (in('hasBusinessLocation').title like '%TEXT%') or

[orientdb] how to know a row index in a query?

Hi, I am looking for a function or a row variable which could return the current row index of a row in my query. That's ROWNUM in Oracle, ROW_NUMBER() in MySQL and MSSQL. Is there any equivalent here? My Best, Hung Tran -- --- You received this message because you are subscribed to the

[orientdb] [2.1.9] ODocument save don't throws Exception if the record is not inserted into database

Ihave problems with java Document API. We are using the version 2.1.9 Sometimes, randomly, I cannot save an ODocument into database (with or without transaction) without catching a specific exception from the database. What can be the problem? -- --- You received this message because you are

[orientdb] Re: how to know a row index in a query?

Hi, try this query select $counter, @rid from v let $counter = eval("$counter + 1") 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

[orientdb] Re: [2.1.9] ODocument save don't throws Exception if the record is not inserted into database

Hi, what is the exception ? 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+unsubscr...@googlegroups.com. For more

[orientdb] as serious in this graph orientdb mysql query

Greetings friends, I come from the world of relational database'm understanding the basis of graph data using orientdb, I have several doubts about how serious consultations. I have 2 classes Bussines hasBussinessLocation edge connected to a class BusinessLocation attached to the image of

[orientdb] Is the Caching still working for OrientDB 2.1.8?

Hi, I have just been migrated from version 1.7.8 to version 2.1.8. I have to comment out code related to L1 / L2 caching because the related methods have been removed. I am wondering How could I configure L1/L2 cache for Java client now (remote database)? configure cache strategy / cache

[orientdb] Re: Console - find out version of database

Hi, you can see it in the server console, I don't know if there is a specific command but if you wanna check it write help command in the orientdb console and you will see the whole list of commands. Hope it helps. Regards, Michela -- --- You received this message because you are

Re: [orientdb] Re: Cannot build the version 2.1.8

Hi Keith Freeman, I have not built javadocs, so I don't know where they are. I often use OrientDB document online and OrientDB forum, that's up to dated and enough for me to discover OrientDB. Hope it helps! My Best, Hung Tran On Thursday, January

[orientdb] Re: Console - find out version of database

This is all I see. No version number anywhere. Connecting to database [remote:127.0.0.1/test] with user 'admin'...OK orientdb {db=test}> info Current database: test (url=remote:127.0.0.1/test) DISTRIBUTED CONFIGURATION: none (OrientDB is running in standalone mode) DATABASE PROPERTIES

[orientdb] Re: getting server warnings: Error deserializing record.... (v2.1.9)

Hi Keith, it might be useful for you to look at the following issue on github https://github.com/orientechnologies/orientdb/issues/5290 Regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and

[orientdb] Re: Sort Order is wrong with Link

Hi, try this query select from (select @rid, Statistics.NumActiveContacts from ContactList where (Account = #20:0) and (EntityInfo.State = 0)) order by Statistics asc, @rid asc skip 0 limit 5 Kind regards, Alessandro -- --- You received this message because you are subscribed to the Google

[orientdb] Re: optimizing bulk loading

Hi Leonid, reading the documentation is not specified if it works with plocal or remote so I suppose that it works both with plocal both with remote. Regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from

[orientdb] Re: Console - find out version of database

I don't know if it's the version number that you want but it's the only one. Hope it helps. -- --- You received this message because you are subscribed to the Google Groups

[orientdb] Re: Console - find out version of database

I am looking for the server version number. Like 2.1.9. How can I tell through the console which server version I have connected to? Scott -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving

[orientdb] Re: Sort Order is wrong with Link

Hi Alessandro, Thank for your response, it's working, understood the logic. However, as a result, the query is doing fully cluster scan (verified), so the query performance is just similar to using alias. My Best, Hung Tran On Thursday, January 28, 2016 at 3:24:29 PM UTC+7,

[orientdb] Re: Console - find out version of database

I'll be more specific as to why I am asking. I just update to 2.1.9, but when I open the console, it actually shows version 2.1.6, which was the older version I had before the upgrade. I am pretty sure I did the upgrade properly. I also can see 2.1.9 in studio. So, I am a bit uncertain what is

Re: [orientdb] Re: Cannot build the version 2.1.8

Thanks Hung. Sure would be nice to know how to build the javadocs with the distribution so I can use them while developing e.g. in eclipse without having to go to a browser. On Thursday, January 28, 2016 at 2:03:47 AM UTC-7, Hung Tran wrote: > > Hi Keith Freeman, > > I have not built javadocs,

[orientdb] Re: getting server warnings: Error deserializing record.... (v2.1.9)

Thanks. I think my case is different, since I was using a 2.1.9 server and 2.1.9 client on a fresh database. I added this info to the issue. On Thursday, January 28, 2016 at 2:00:59 AM UTC-7, alessand...@gmail.com wrote: > > Hi Keith, > it might be useful for you to look at the following