[orientdb] Re: Timeout (120001ms) on waiting for synchronous responses from nodes=

[Oleksandr Gubchenko]

Dear Maxim,

could you please attach whole logs of all nodes?
What version of OrientDB are you using?

Il giorno mercoledì 25 aprile 2018 19:37:40 UTC+2, Maxim Nikolaev ha 
scritto:
>
> error execute sql command, but http rest api work
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Restore Database

[Oleksandr Gubchenko]

The version that you are using is old, try to run it with the latest 2.2.x 
and if it doesn't help on the latest version you can also try REPAIR 
DATABASE command.

Il giorno lunedì 13 novembre 2017 12:48:49 UTC+1, Pugazharasan Thirumalai 
ha scritto:
>
> Hai, 
>
> We are using Orientdb 2.0.18 version
>
> Our database has crashed, when we try to restart my database am getting 
> error .
> Provide proper solution to restore my database. Its very urgent please 
> reply soon, all customers are waiting.
>
>
> 2017-11-13 03:55:23:538 INFO  OrientDB auto-config DISKCACHE=12,926MB 
> (heap=910MB os=15,885MB disk=65,193MB) [orientechnologies]
> 2017-11-13 03:55:23:567 INFO  Loading configuration from: 
> /home/jai/orientdb-community-2.0.18/config/orientdb-server-config.xml... 
> [OServerConfigurationLoaderXml]
> 2017-11-13 03:55:23:712 INFO  OrientDB Server v2.0.18 (build 2.0.x@r; 
> 2016-02-02 14:01:56+) is starting up... [OServer]
> 2017-11-13 03:55:23:715 INFO  Databases directory: 
> /home/jai/orientdb-community-2.0.18/databases [OServer]
> 2017-11-13 03:55:23:736 INFO  Listening binary connections on 0.0.0.0:2424 
> (protocol 
> v.28, socket=default) [OServerNetworkListener]
> 2017-11-13 03:55:23:737 INFO  Listening http connections on 0.0.0.0:2480 
> (protocol 
> v.10, socket=default) [OServerNetworkListener]
> 2017-11-13 03:55:23:745 INFO  Installing dynamic plugin 
> 'studio-2.0.zip'... [OServerPluginManager]
> 2017-11-13 03:55:23:802 INFO  Installing GREMLIN language v.2.6.0 - 
> graph.pool.max=50 [OGraphServerHandler]
> 2017-11-13 03:55:23:803 INFO  [OVariableParser.resolveVariables] Error on 
> resolving property: distributed [orientechnologies]
> 2017-11-13 03:55:23:804 INFO  Installing Script interpreter. WARN: 
> authenticated clients can execute any kind of code into the server by using 
> the following allowed languages: [sql] [OServerSideScriptInterpreter]
> 2017-11-13 03:55:23:806 INFO  Automatic backup plugin installed and 
> active: delay=8640ms, firstTime=null, targetDirectory=backup/ 
> [OAutomaticBackup]
> 2017-11-13 03:55:23:807 INFO  OrientDB Server v2.0.18 is active. [OServer]
> 2017-11-13 03:56:04:429 WARNING {db=mio} segment file 'database.ocf' was 
> not closed correctly last time [OSingleFileSegment]
> 2017-11-13 03:56:04:493 WARNING {db=mio} Storage mio was not closed 
> properly. Will try to restore from write ahead log. [OLocalPaginatedStorage]
> 2017-11-13 03:56:04:493 INFO  {db=mio} Looking for last checkpoint... 
> [OLocalPaginatedStorage]
> 2017-11-13 03:56:04:498 INFO  {db=mio} Found FUZZY checkpoint. 
> [OLocalPaginatedStorage]
> 2017-11-13 03:56:04:596 INFO  {db=mio} Data restore procedure from FUZZY 
> checkpoint is started. [OLocalPaginatedStorage]
> 2017-11-13 03:56:04:661 WARNING {db=mio} Non tx operation was used during 
> data modification we will need index rebuild. 
> [OLocalPaginatedStorage]{db=mio} Exception during storage data restore.
> com.orientechnologies.orient.core.exception.OStorageException: File with 
> id 1211 does not exist.
> at 
> com.orientechnologies.orient.core.index.hashindex.local.cache.OWOWCache.openFile(OWOWCache.java:420)
> at 
> com.orientechnologies.orient.core.index.hashindex.local.cache.OReadWriteDiskCache.openFile(OReadWriteDiskCache.java:183)
> at 
> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreAtomicUnit(OAbstractPaginatedStorage.java:2283)
> at 
> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFrom(OAbstractPaginatedStorage.java:2216)
> at 
> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromFuzzyCheckPoint(OAbstractPaginatedStorage.java:2187)
> at 
> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromCheckPoint(OAbstractPaginatedStorage.java:2162)
> at 
> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromWAL(OAbstractPaginatedStorage.java:2095)
> at 
> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreIfNeeded(OAbstractPaginatedStorage.java:1469)
> at 
> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.open(OAbstractPaginatedStorage.java:171)
> at 
> com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.open(ODatabaseDocumentTx.java:244)
> at 
> com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:636)
> at 
> com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:618)
> at 
> com.orientechnologies.orient.server.network.protocol.http.command.OServerCommandAuthenticatedDbAbstract.authenticate(OServerCommandAuthenticatedDbAbstract.java:167)
> at 
> com.orientechnologies.orient.server.network.protocol.http.command.OServerCommandAuthenticatedDbAbstract.beforeExecute(OServerCommandAuthenticatedDbAbstract.java:127)
> at 
> 

[orientdb] Re: We can't open the database, Gettting error..

[Oleksandr Gubchenko]

Can you try with the latest 2.2.29 ?

Il giorno venerdì 6 ottobre 2017 10:13:46 UTC+2, pugazh...@waffor.com ha 
scritto:
>
> Wa are using Orientdb 2.0.18 version, when we try to upload the manual 
> downloaded database by .json format.
>
> On Thursday, October 5, 2017 at 1:08:24 PM UTC+5:30, Oleksandr Gubchenko 
> wrote:
>>
>> Which version are you using? What actions were performed on the database?
>>
>> Il giorno mercoledì 4 ottobre 2017 16:40:12 UTC+2, Pugazharasan 
>> Thirumalai ha scritto:
>>>
>>> 2017-10-04 19:55:27:292 WARNING {db=mio} segment file 'database.ocf' was 
>>> not closed correctly last time [OSingleFileSegment]
>>> 2017-10-04 19:55:27:292 SEVERE {db=mio} Internal server error:
>>> com.orientechnologies.orient.core.exception.OStorageException: Cannot 
>>> open local storage 
>>> '/home/centos/waffor/orientdb-community-2.0.18/databases/mio' with mode=rw
>>> --> com.orientechnologies.orient.core.exception.OStorageException: File 
>>> with id 1057 does not exist. [ONetworkProtocolHttpDb]
>>> 2017-10-04 19:55:27:297 WARNING {db=mio} Storage mio was not closed 
>>> properly. Will try to restore from write ahead log. [OLocalPaginatedStorage]
>>> 2017-10-04 19:55:27:297 INFO  {db=mio} Looking for last checkpoint... 
>>> [OLocalPaginatedStorage]
>>> 2017-10-04 19:55:27:300 INFO  {db=mio} Found FUZZY checkpoint. 
>>> [OLocalPaginatedStorage]
>>> 2017-10-04 19:55:27:301 INFO  {db=mio} Data restore procedure from FUZZY 
>>> checkpoint is started. [OLocalPaginatedStorage]{db=mio} Exception during 
>>> storage data restore.
>>> com.orientechnologies.orient.core.exception.OStorageException: File with 
>>> id 1057 does not exist.
>>> at 
>>> com.orientechnologies.orient.core.index.hashindex.local.cache.OWOWCache.openFile(OWOWCache.java:420)
>>> at 
>>> com.orientechnologies.orient.core.index.hashindex.local.cache.OReadWriteDiskCache.openFile(OReadWriteDiskCache.java:183)
>>> at 
>>> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreAtomicUnit(OAbstractPaginatedStorage.java:2283)
>>> at 
>>> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFrom(OAbstractPaginatedStorage.java:2216)
>>> at 
>>> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromFuzzyCheckPoint(OAbstractPaginatedStorage.java:2187)
>>> at 
>>> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromCheckPoint(OAbstractPaginatedStorage.java:2162)
>>> at 
>>> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromWAL(OAbstractPaginatedStorage.java:2095)
>>> at 
>>> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreIfNeeded(OAbstractPaginatedStorage.java:1469)
>>> at 
>>> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.open(OAbstractPaginatedStorage.java:171)
>>> at 
>>> com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.open(ODatabaseDocumentTx.java:244)
>>> at 
>>> com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:636)
>>> at 
>>> com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:618)
>>> at 
>>> com.orientechnologies.orient.server.network.protocol.http.command.OServerCommandAuthenticatedDbAbstract.authenticate(OServerCommandAuthenticatedDbAbstract.java:167)
>>> at 
>>> com.orientechnologies.orient.server.network.protocol.http.command.OServerCommandAuthenticatedDbAbstract.beforeExecute(OServerCommandAuthenticatedDbAbstract.java:127)
>>> at 
>>> com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.service(ONetworkProtocolHttpAbstract.java:173)
>>> at 
>>> com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.execute(ONetworkProtocolHttpAbstract.java:581)
>>> at 
>>> com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:69)
>>>
>>> 2017-10-04 19:55:27:319 SEVERE {db=mio} Internal server error:
>>> com.orientechnologies.orient.core.exception.OStorageException: Cannot 
>>> open local storage 
>>> '/home/centos/waffor/orientdb-community-2.0.18/databases/mio' with mode=rw
>>> --> com.orientechnologies.orient.core.exception.OStorageException: File 

[orientdb] Re: Orientdb Getting very slow process when enable automatic backup option in config file

[Oleksandr Gubchenko]

What are the system's specs? 
Can you try it on the latest 2.2.28 ?

Il giorno giovedì 5 ottobre 2017 12:45:01 UTC+2, jaya raj ha scritto:
>
>
>   I am using 2.0.18 version using, to enabled automatic backup option in 
> config file , when ever backup is going our server getting slow down.. how 
> can i fix it,
>
> without disturbing the server. 
>
>
>   
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: We can't open the database, Gettting error..

[Oleksandr Gubchenko]

Which version are you using? What actions were performed on the database?

Il giorno mercoledì 4 ottobre 2017 16:40:12 UTC+2, Pugazharasan Thirumalai 
ha scritto:
>
> 2017-10-04 19:55:27:292 WARNING {db=mio} segment file 'database.ocf' was 
> not closed correctly last time [OSingleFileSegment]
> 2017-10-04 19:55:27:292 SEVERE {db=mio} Internal server error:
> com.orientechnologies.orient.core.exception.OStorageException: Cannot open 
> local storage '/home/centos/waffor/orientdb-community-2.0.18/databases/mio' 
> with mode=rw
> --> com.orientechnologies.orient.core.exception.OStorageException: File 
> with id 1057 does not exist. [ONetworkProtocolHttpDb]
> 2017-10-04 19:55:27:297 WARNING {db=mio} Storage mio was not closed 
> properly. Will try to restore from write ahead log. [OLocalPaginatedStorage]
> 2017-10-04 19:55:27:297 INFO  {db=mio} Looking for last checkpoint... 
> [OLocalPaginatedStorage]
> 2017-10-04 19:55:27:300 INFO  {db=mio} Found FUZZY checkpoint. 
> [OLocalPaginatedStorage]
> 2017-10-04 19:55:27:301 INFO  {db=mio} Data restore procedure from FUZZY 
> checkpoint is started. [OLocalPaginatedStorage]{db=mio} Exception during 
> storage data restore.
> com.orientechnologies.orient.core.exception.OStorageException: File with 
> id 1057 does not exist.
> at 
> com.orientechnologies.orient.core.index.hashindex.local.cache.OWOWCache.openFile(OWOWCache.java:420)
> at 
> com.orientechnologies.orient.core.index.hashindex.local.cache.OReadWriteDiskCache.openFile(OReadWriteDiskCache.java:183)
> at 
> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreAtomicUnit(OAbstractPaginatedStorage.java:2283)
> at 
> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFrom(OAbstractPaginatedStorage.java:2216)
> at 
> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromFuzzyCheckPoint(OAbstractPaginatedStorage.java:2187)
> at 
> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromCheckPoint(OAbstractPaginatedStorage.java:2162)
> at 
> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromWAL(OAbstractPaginatedStorage.java:2095)
> at 
> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreIfNeeded(OAbstractPaginatedStorage.java:1469)
> at 
> com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.open(OAbstractPaginatedStorage.java:171)
> at 
> com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.open(ODatabaseDocumentTx.java:244)
> at 
> com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:636)
> at 
> com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:618)
> at 
> com.orientechnologies.orient.server.network.protocol.http.command.OServerCommandAuthenticatedDbAbstract.authenticate(OServerCommandAuthenticatedDbAbstract.java:167)
> at 
> com.orientechnologies.orient.server.network.protocol.http.command.OServerCommandAuthenticatedDbAbstract.beforeExecute(OServerCommandAuthenticatedDbAbstract.java:127)
> at 
> com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.service(ONetworkProtocolHttpAbstract.java:173)
> at 
> com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.execute(ONetworkProtocolHttpAbstract.java:581)
> at 
> com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:69)
>
> 2017-10-04 19:55:27:319 SEVERE {db=mio} Internal server error:
> com.orientechnologies.orient.core.exception.OStorageException: Cannot open 
> local storage '/home/centos/waffor/orientdb-community-2.0.18/databases/mio' 
> with mode=rw
> --> com.orientechnologies.orient.core.exception.OStorageException: File 
> with id 1057 does not exist. [ONetworkProtocolHttpDb]
> 2017-10-04 19:55:27:538 WARNING {db=mio} segment file 'database.ocf' was 
> not closed correctly last time [OSingleFileSegment]
> 2017-10-04 19:55:27:543 WARNING {db=mio} Storage mio was not closed 
> properly. Will try to restore from write ahead log. [OLocalPaginatedStorage]
> 2017-10-04 19:55:27:543 INFO  {db=mio} Looking for last checkpoint... 
> [OLocalPaginatedStorage]
> 2017-10-04 19:55:27:545 INFO  {db=mio} Found FUZZY checkpoint. 
> [OLocalPaginatedStorage]
> 2017-10-04 19:55:27:546 INFO  {db=mio} Data restore procedure from FUZZY 
> checkpoint is started. [OLocalPaginatedStorage]{db=mio} Exception during 
> storage data restore.
> com.orientechnologies.orient.core.exception.OStorageException: File with 
> id 1057 does not exist.
> at 
> com.orientechnologies.orient.core.index.hashindex.local.cache.OWOWCache.openFile(OWOWCache.java:420)
> at 
> 

[orientdb] Re: Traverse all possible N degree separation paths between vertexes

[Oleksandr Gubchenko]

Hi,

you can try this 
code: 
https://stackoverflow.com/questions/37481736/orientdb-all-paths-between-two-nodes

Il giorno mercoledì 20 settembre 2017 15:48:21 UTC+2, Jyothis K P ha 
scritto:
>
>
> Is it possible to find out all possible paths between two nodes?
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: doc outdated: ODatabaseDocumentPool is deprecated

[Oleksandr Gubchenko]

You can edit the docs, thanks!

Il giorno domenica 10 settembre 2017 20:58:23 UTC+2, ad...@cs.miami.edu ha 
scritto:
>
> The docs state:
>
> ODatabaseDocumentTx db = ODatabaseDocumentPool.global()
>>   .acquire("remote:localhost/petshop", 
>>   "admin", "admin_passwd");
>>
>> at http://orientdb.com/docs/last/Document-API-Database.html
>
> I suggest the following instead
>
> OPartitionedDatabasePool pool =  new OPartitionedDatabasePool(url , 
>> "admin", "admin_passswrd");
>> ODatabaseDocumentTx db = pool.acquire();
>>
>
>
> -Adam
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Delete default value for property without deleting the property

[Oleksandr Gubchenko]

Hello,

you can use ALTER PROPERTY with DEFAULT set to NULL, see the latest 
docs: https://orientdb.com/docs/last/SQL-Alter-Property.html
Example:
ALTER PROPERTY Client.created DEFAULT NULL

Il giorno giovedì 13 luglio 2017 12:10:52 UTC+2, Fritz Gerald ha scritto:
>
> Hi everyone,
>
> does anyone know how to drop the predefined default value for a property 
> without deleting the property? PostgreSQL uses "ALTER [ COLUMN ] column 
> DROP DEFAULT". However, the OrientDB docs "
> https://orientdb.com/docs/2.1/SQL-Alter-Property.html; do not give any 
> hint.
>
> Thanks, Fritz
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: slow insert performance for few million vertices and edges

[Oleksandr Gubchenko]

Dear Zeeshan Ahmad, which version are you using?
Can you provide your script to perform some tests?

Also what is your memory configuration?

Thank you.
Best regards,
Alex.

Il giorno mercoledì 31 maggio 2017 22:53:00 UTC+2, Zeeshan Ahmad ha scritto:
>
> Hi,
>
> I am using pyorient driver for orientdb. Number of Vertices are around 3 
> million and Edges around 4 million. I wrote a script to populate the 
> database, and individual queries in the script seem to be working fine, but 
> as the data grew to around a million the insertion operation has 
> significantly slowed down. I am not getting any slow query logs or out of 
> memory logs.
> Am i missing something on part of configuring the server?
>
> I can provide the script if required.
>
> Please provide with some suggestions. I have been stuck for a while.
>
> Thanks,
> Zeeshan Ahmad
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: The property type of a content in schema less mode

[Oleksandr Gubchenko]

Choose from one of the embedded types:
http://orientdb.com/docs/last/Types.html

Il giorno giovedì 9 febbraio 2017 19:39:49 UTC+1, André Toscano ha scritto:
>
> Hi everyone 
> We are using OrientDB like mongodb for some properties and it is working 
> very well but we need to index some keys of the document (considering 
> JSON). 
> Please, what is the type of a property that stores a json object with many 
> levels nested? 
> Thanks in advance 
> Best regards 
> André 
>
> On 6 Jan 2017 06:24,  wrote:
>
> orient-database@googlegroups.com 
> 
>  Google 
> Groups 
> 
>  
> 
>  
> Topic digest 
> View all topics 
> 
>  
>
>- Proper way to generate and insert data into OrientDB 
>
> <#CAPrw5MEiW4xEetA8hd-qYQzfgnfdWR0q61D4=-KHmaaMQ4yfyw@mail.gmail.com_m_4313801924897894530_group_thread_0>
>  
>- 2 Updates 
>- Kotlin 
>
> <#CAPrw5MEiW4xEetA8hd-qYQzfgnfdWR0q61D4=-KHmaaMQ4yfyw@mail.gmail.com_m_4313801924897894530_group_thread_1>
>  
>- 1 Update 
>- Reached maximum number of concurrent connections 
>
> <#CAPrw5MEiW4xEetA8hd-qYQzfgnfdWR0q61D4=-KHmaaMQ4yfyw@mail.gmail.com_m_4313801924897894530_group_thread_2>
>  
>- 1 Update 
>
> Proper way to generate and insert data into OrientDB 
> 
>  
> Cyprien Gottstein : Jan 05 06:44AM 
> -0800 
>
> Hi,
>  
> The scripts are in java, those are not batches, and we didn't wanted to 
> post it online to be perfectly honest.
>  
> But.
>  
> Great news, problem solved !
>  
> I remembered something crucial, it's mainly me who is working on the 
> subject and at first i wanted to run the OrientDB server on my own local 
> machine. Since my computer is not what i would call young and powerful, i 
> asked to make it run on a virtual machine in our own datacenter. I work in 
> France. The Datacenter is in Poland.
>  
> What was it again ? Non-Transactionnal Mode means " for every new entity 
> we 
> write it immediately on disk ", it meant for every entry we were eating 
> the 
> latency between our building in France and the datacenter in Poland.
>  
> We made a proper uber-jar to run the generation code on the very same 
> machine holding the Orient DB server's instance.
> We did some simple benchmark to check how the total execution time would 
> behave depending on the transaction mode and location of the program.
>  
> Job Place - Transactionnal : 900 secs (i don't have the real number, i 
> just 
> know its around that, sorry.)
> Job Place - Non-Transactionnal : more than 54000 secs
> Datacenter - Transactionnal : 212 secs
> Datacenter - Non-Transactionnal : 2700 secs (i don't have the real number, 
> i just know its around that, sorry.)
>  
> So thanks to executing the code from the right place we avoided some HUGE 
> loss of times. The Non-Transactionnal mode is slower but your promess was 
> kept, it runs with a constant amount of RAM, that means if we want to 
> generate 10 millions or even 50 millions of entities we can in a 
> reasonnable time so i would guess it's fine.
>  
> Last question and i think this case will be closed (at least for me) :
>  
> The OrientDB Documentation warns in 
>
> http://orientdb.com/docs/last/Performance-Tuning.html#wise-use-of-transactions
>  
> that :
>  
> "Transactions slow down massive inserts unless you're using a "remote" 
> > connection. In that case it speeds up all the insertion because the 
> > client/server communication happens only at commit time."
>  
> We can indeed see it in effect when we run our little benchmark 
> (Transactionnal - 212 VS Non-Transactionnal 2700) , are we in a difference 
> of speed that is to be expected ? Or does something still feels off ?
>  
> Thanks again for your time,
>  
> Cyprien Gottstein
> Luca Garulli : Jan 05 11:06PM +0100 
>
> Hi Cyprien,
>  
> Glad you solved it.
>  
> With remote and/or graph operations, specially when you add multiple edges,
> transaction always help. Before 2.2 transactions didn't run in parallel,
> but after 2.2 they can. In facts, this is my next question. Are you running
> on multiple threads?
>  
> Best Regards,
>  
> Luca Garulli
> Founder & CEO
> OrientDB LTD 
>  
> On 5 January 2017 at 15:44, Cyprien Gottstein  >
> wrote:
>  
> Back to top 
> <#CAPrw5MEiW4xEetA8hd-qYQzfgnfdWR0q61D4=-KHmaaMQ4yfyw@mail.gmail.com_m_4313801924897894530_digest_top>
>  
> Kotlin 
> 
>  
> Roberto 

[orientdb] Re: If i use eval() method in query it can,t give proper result because some value are null or empty?

[Oleksandr Gubchenko]

Make your function/query do eval only if the value is not null.

Il giorno mercoledì 11 gennaio 2017 08:09:12 UTC+1, Pugazharasan Thirumalai 
ha scritto:
>
> If i use eval() method in query it can give proper result because some 
> value are null or empty,
> Is there  any possible way to overcome this problem.
>
> Thanks and Regards,
> T.Pugazharasan.
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Replace # in rid

[Oleksandr Gubchenko]

Don't think it's possible.

Il giorno venerdì 6 gennaio 2017 20:45:08 UTC+1, NUVUZ ha scritto:
>
> Is it possible to replace the use of the hash/pound (#) sign in the RID? 
>  I'm running into conflicts with coldfusion that uses # signs extensively 
> for its markup.
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Reached maximum number of concurrent connections

[Oleksandr Gubchenko]

This kind of error usually occurs when database.close() is not executed. 
The default value for the maximum number of concurrent connections is 1000, 
to change it use -Dnetwork.maxConcurrentSessions

Il giorno mercoledì 4 gennaio 2017 15:19:46 UTC+1, leon...@adimplere.com.br 
ha scritto:
>
> Hi,
>
> May anyone use the orientdb with java so that it closes the used connections 
> and avoids the error "Reached maximum number of concurrent connections" ?
>
> A simple test that I do. I'm using java8 and orientdb 2.2.14 with remote. 
> Config sets don't work.
>
>val poolFactory = new OPartitionedDatabasePoolFactory()
> poolFactory.setMaxPoolSize(40)
>
> val pool = poolFactory.get("remote:db.adimplere.com.br/adimplere", 
> "admin", "ab12HTT")
> val conn = pool.acquire()
>
> try {
>  
>   val query = StringBuilder.newBuilder
>
>   query.append("SELECT @this.tojson(\"fetchPlan:*:-1\") AS itens FROM 
> Parceiro limit 1000;")
>
>   //connection.query(new OSQLSynchQuery[ODocument]("SELECT * FROM Cliente 
> WHERE cpfCnpj=?").setFetchPlan("*:-1"))
>
>   val res = conn.query[java.util.List[ODocument]](new 
> OSQLSynchQuery[ODocument](query.toString)).asScala.toList
>
>   val result = {
> if (res.isEmpty) {
>   None
> } else {
>   Some(res(0).field("itens"))
> }
>   }
>
>   result
>
> } finally {
>   conn.close()
>   pool.close()
>   poolFactory.close()
> }
>
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Proper way to get ORID

[Oleksandr Gubchenko]

Try
record.getIdentity();

Il giorno venerdì 23 dicembre 2016 14:41:42 UTC+1, TomekK ha scritto:
>
> Hello, could you help me?
>
> I have class with documents with link to attachments in another class. 
> I need to get RIDs and some (not all) fields.
>
> My code:
>final OSQLSynchQuery query = new 
> OSQLSynchQuery("select @rid as id, attachmentRID, field_1, 
> field_2  from Mail");
>for (ODocument record : resultset) {
>   ORID rid = ((ODocument)record.field("id")).getIdentity();
>   ORID arrachmentRid = 
> ((ODocument)record.field("attachment")).getIdentity();
>   ...
>}}
>
> 1) What's the proper way to get RID of document, or linked document?
> I suppose that there is a better way, because I don't want to get all 
> document, but only RIDs.
>
> 2) Is "select field_1, field_2, ... field_k from..." faster or require 
> lower memory than getting all field "select * from... "?
> Some of the fields stores files, and I don't want to download them from 
> the database, when it's not necessary. Should I put them into different 
> class and use OType.Link?
>
>
>
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Unable to create a database in remote

[Oleksandr Gubchenko]

What version are you using?

Il giorno venerdì 23 dicembre 2016 11:00:08 UTC+1, poorvitha h.p ha scritto:
>
> Hi,
>
> I have been trying to load data using the ETL and this is in a distributed 
> environment. There are 3 clusters.
>
> When I try to use remote, I get null pointer exception..
>
> "loader": { "orientdb": {
>   URL: "remote:localhost/trick1",
>   User: "root",
>   Password: ".",
>   tx: true,
>   batchCommit: 1000,
>   dbType: "graph",
> "classes": [ { "name": "myVertex", "extends", "V" },
>],
> "indexes": [
> {"class": "myVertex","fields": ["id:string"],"type": "UNIQUE"},
> {"class": "myVertex","fields": ["name:string"],"type": "NOTUNIQUE"},
> {"class": "myVertex","fields": ["name:kind"],"type": "NOTUNIQUE"}
> ]
> }
>   }
> }
>
> What is wrong with this one. If I use plocal instead of remote it creates 
> a database but that is not visible in the studio.
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Proper way to generate and insert data into OrientDB

[Oleksandr Gubchenko]

It might be a jvm memory tuning issue. You can check out the gclog adding 
this parameters:
add -XX:+PrintGCDateStamps -XX:+PrintGCTimeStamps -XX:+PrintGCID 
-XX:+PrintGCDetails -Xloggc:$ORIENTDBHOME/log/gc%p_%t.log 
check the memory usage and give server the correct amount of memory.

Il giorno giovedì 22 dicembre 2016 18:29:49 UTC+1, Cyprien Gottstein ha 
scritto:
>
> Hello everyone,
>
> We are currently testing OrientDB to check if we may use it as a database. 
> The problem we are facing right now is about memory consumption through 
> data generation.
>
> We want to test if OrientDB support our queries in a larger scale so we 
> went through building a little generator in java to insert data 
> corresponding to our needs.In order to generate and insert the data in a 
> fast way we parse first ontologies (which serve for semantic data 
> referencing) and store them in memory. Afterwards we generate some random 
> data, bind them together on-the-fly and also bind them to some concepts in 
> the ontologies graphs. All of that is made using the Java Graph API.
>
> It works nicely at the beginning, but in the end it always crashes with 
> "java.lang.OutOfMemoryError: GC overhead limit exceeded". The java program 
> which handle the data generation has 1.5 GB ram to work with and when it 
> crashes we have almost generated a million of OrientDB elements ( about a 
> third as vertices, the rest as edges).
>
> We tried a lot of things, Massive Insert intent, setting 
> keepReferencesInMemory to false, limiting disk cache size, and we checked 
> multiple times to ensure we were not doing anything stupid with the memory. 
> We also thought about using fetchplan to ensure the cache only stores the 
> main document in memory and not all of its edges but this option is not 
> accessible in the Graph API.Yet, we can't make the generator go further 
> because it always lack memory.
>
> We think it's related to the disk cache usage, we can't properly measure 
> it but its visible in htop, the memory usage keeps growing during the last 
> half of the generation even though at this point we are only inserting data 
> in the graph and we are not storing anything anymore in the Java program. 
> Our theory behind this is that we store pointers to the ontology nodes 
> which themselves points on the nodes we generate on the fly and at some 
> point this may trigger the cache to keep the pointed nodes alive in memory. 
> This would explain why the memory keep growing.
>
> I'm sorry of its a bit fuzzy.
>
> We could just add more RAM to the JVM but we can't help but wonder: What 
> are we missing  ? Is there a way to properly generate a set data with 
> connections between eachother and insert it into OrientDB ?
>
> Thanks,
>
> Cyprien Gottstein.
>
>
>
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

Re: [orientdb] Re: can no longer start orientdb server

[Oleksandr Gubchenko]

Are you using plocal o remote connection to the server?

Il giorno mercoledì 21 dicembre 2016 12:44:34 UTC+1, Gregory Mace ha 
scritto:
>
> linux 
> Ubuntu 16.04.1 LTS 
>
>
>
>
> On Wednesday, December 21, 2016 at 3:36:11 AM UTC-8, Luigi Dell'Aquila 
> wrote:
>>
>> Hi Gregory,
>>
>> Are you on windows, linux or mac (or other)?
>>
>> Thanks
>>
>> Luigi
>>
>>
>> 2016-12-21 12:31 GMT+01:00 Gregory Mace :
>>
>>> this happens when I try to put orientdb-spatial jar file in the ./lib 
>>> directory.
>>> I'm running v2.2.13 server and using : orientdb-spatial-2.2.13.jar
>>>
>>> the problem goes away when I remove it.
>>>
>>>
>>> On Wednesday, December 21, 2016 at 3:12:12 AM UTC-8, Gregory Mace wrote:

 I get a warning in the log:

 Database is open by another process [OPaginatedStorageDirtyFlag]


 but there is no other process that has 'Database' open.  Is there some 
 lock file that is hung out to dry?


 -- 
>>>
>>> --- 
>>> 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-databa...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Exception while invoking OrientBaseGraph.commit()

[Oleksandr Gubchenko]

What version are you on? What is you configuration? What operation are you 
performing?

Thanks.

Il giorno mercoledì 21 dicembre 2016 11:36:39 UTC+1, Barath Kumar ha 
scritto:
>
> While calling OrientBaseGraph.commit(), getting the below exception.
>
> 1. How to fix this exception.
> 2. Will the data be committed successfully when the below exception is got
>
> Please advise
>
> [21 Dec 2016 07:43:08:023] RCAERR:
> com.orientechnologies.orient.server.distributed.ODistributedException: 
> Error on executing distributed request (id=1706 from=elektra task=tx 
> userName=) against database 'webnmsdb.[managedobject, default]' to nodes 
> [natchios, elektra]
> at 
> com.orientechnologies.orient.server.hazelcast.OHazelcastDistributedDatabase.send2Nodes(OHazelcastDistributedDatabase.java:195)
> at 
> com.orientechnologies.orient.server.hazelcast.OHazelcastPlugin.sendRequest(OHazelcastPlugin.java:354)
> at 
> com.orientechnologies.orient.server.distributed.ODistributedStorage.commit(ODistributedStorage.java:914)
> at 
> com.orientechnologies.orient.core.tx.OTransactionOptimistic.doCommit(OTransactionOptimistic.java:488)
> at 
> com.orientechnologies.orient.core.tx.OTransactionOptimistic.commit(OTransactionOptimistic.java:147)
> at 
> com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.commit(ODatabaseDocumentTx.java:2433)
> at 
> com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.commit(ODatabaseDocumentTx.java:2403)
> at 
> com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.commit(ONetworkProtocolBinary.java:1092)
> at 
> com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.executeRequest(ONetworkProtocolBinary.java:394)
> at 
> com.orientechnologies.orient.server.network.protocol.binary.OBinaryNetworkProtocolAbstract.execute(OBinaryNetworkProtocolAbstract.java:217)
> at 
> com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:69)
> Caused by: 
> com.orientechnologies.orient.server.distributed.ODistributedException: 
> Quorum 2 not reached for request (id=1706 from=elektra task=tx 
> userName=). Elapsed=10ms Servers in timeout/conflict are:
>  - natchios: [#20:1670803 v.460261, #22:247038 v.87321, 2030]
> Received: {natchios=[#20:1670803 v.460261, #22:247038 v.87321, 2030], 
> elektra=[#20:1807065 v.625279, #22:688321 v.169774, 2030]}
> at 
> com.orientechnologies.orient.server.distributed.ODistributedResponseManager.manageConflicts(ODistributedResponseManager.java:585)
> at 
> com.orientechnologies.orient.server.distributed.ODistributedResponseManager.getFinalResponse(ODistributedResponseManager.java:349)
> at 
> com.orientechnologies.orient.server.hazelcast.OHazelcastDistributedDatabase.waitForResponse(OHazelcastDistributedDatabase.java:358)
> at 
> com.orientechnologies.orient.server.hazelcast.OHazelcastDistributedDatabase.send2Nodes(OHazelcastDistributedDatabase.java:192)
> ... 10 more
> [21 Dec 2016 07:43:08:182] RCAERR: Exception while committing graph at:
> [21 Dec 2016 07:43:08:182] RCAERR:
> com.orientechnologies.orient.server.distributed.ODistributedException: 
> Error on executing distributed request (id=17033340 from=elektra task=tx 
> userName=) against database 'webnmsdb.[managedobject, default]' to nodes 
> [natchios, elektra]
> at 
> com.orientechnologies.orient.server.hazelcast.OHazelcastDistributedDatabase.send2Nodes(OHazelcastDistributedDatabase.java:195)
> at 
> com.orientechnologies.orient.server.hazelcast.OHazelcastPlugin.sendRequest(OHazelcastPlugin.java:354)
> at 
> com.orientechnologies.orient.server.distributed.ODistributedStorage.commit(ODistributedStorage.java:914)
> at 
> com.orientechnologies.orient.core.tx.OTransactionOptimistic.doCommit(OTransactionOptimistic.java:488)
> at 
> com.orientechnologies.orient.core.tx.OTransactionOptimistic.commit(OTransactionOptimistic.java:147)
> at 
> com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.commit(ODatabaseDocumentTx.java:2433)
> at 
> com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.commit(ODatabaseDocumentTx.java:2403)
> at 
> com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.commit(ONetworkProtocolBinary.java:1092)
> at 
> com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.executeRequest(ONetworkProtocolBinary.java:394)
> at 
> com.orientechnologies.orient.server.network.protocol.binary.OBinaryNetworkProtocolAbstract.execute(OBinaryNetworkProtocolAbstract.java:217)
> at 
> com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:69)
> Caused by: 
> com.orientechnologies.orient.server.distributed.ODistributedException: 
> Quorum 2 not reached for request (id=17033340 from=elektra task=tx 
> userName=). 

[orientdb] Re: orientdb-neo4j-importer: Importing from neo4j with multiple Labels on nodes

[Oleksandr Gubchenko]

It's not possible.
See official 
documentation: http://orientdb.com/docs/last/OrientDB-Neo4j-Importer.html
Limitations:
Schema limitations:
- In case a node in Neo4j has multiple Labels, it will be imported into a 
single OrientDB Class ("MultipleLabelNeo4jConversion").
 -- Note that the information about the original set of Labels is not lost 
but stored into an internal property of the imported vertex 
("Neo4jLabelList"). As a result it will be possible to query nodes with a 
specific Neo4j Label. Note also that the nodes imported into the single 
class "MultipleLabelNeo4jConversion" can then be moved to other Classes, 
according to your specific needs, using the MOVE VERTEX command.
- Neo4j Nodes with same Label but different case, e.g. LABEL and LAbel will 
be aggregated into a single OrientDB vertex Class.


Alex.

Il giorno lunedì 19 dicembre 2016 20:13:12 UTC+1, Gregory Mace ha scritto:
>
>
> I've imported several millions of records from Neo4j.  They all came over, 
> but the class type is not what I wanted them to be. I have some questions:
>
> 1. can orientdb represent Vertexes similar to Neo4j in terms of supporting 
> multiple Labels on a Vertex.  If so, how?
> 2. how can I bulk change the classes of records ( Vertexes ) that I 
> imported from Neo4j?
> 3. Is there a way to pre-define how I want an import to assign classes?
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: I can't expand more than three times in let query. what is the alternative way?

[Oleksandr Gubchenko]

Are you using the latest version?

Il giorno lunedì 19 dicembre 2016 10:41:50 UTC+1, Pugazharasan Thirumalai 
ha scritto:
>
> If i execute the below query,
>
> select sum($service.gross_value) as total from #25:1073 let $service = 
> (select expand(out('store_has_billing')['is_deleted = false']) from (select 
> expand(out('network_has_store')['is_deleted = false']) from 
> $parent.$current))
>
> am get result.
>
> But if i expand again, then am not getting answer,
>
> select sum($service.gross_value) as total from #25:1073 let $service = 
> (select expand(out('billing_has_billing_services')) from (select 
> expand(out('store_has_billing')['is_cancel = false']['is_deleted = false']) 
> from (select expand(out('network_has_store')['is_deleted = false']) from 
> $parent.$current)))
>
> Any please give suggestion or alternative way for this?
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Restore database with the same RID

[Oleksandr Gubchenko]

Can you just try to copy the folder containing the database?

Il giorno sabato 17 dicembre 2016 21:23:35 UTC+1, André Toscano ha scritto:
>
> Hi, I've made an export/import database and I the objects changed its RIDs.
> I take a look at the documentation again and I saw that is recommended to 
> use backup/restore database instead of export/import.
> My questions are:
> 1 - is there a way do preserve rid? backup/restore will do that?
> 2 - with an exported database, I can see the @rid exported in the objects 
> but when I restore the database using import the rid changes. Is there a 
> way to maintain the same rid described in the export json file?
> Thanks in advance
> Best regards
>
> André Emilio Toscano
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Backup and Restore tools/APIs

[Oleksandr Gubchenko]

Hi,

yes there is native backup available in enterprise edition, 
see: http://orientdb.com/docs/last/Backup-and-Restore.html
A demonstrational video can be found 
here: https://www.youtube.com/watch?v=hU2UkWiDjNM


Alex.

Il giorno martedì 13 dicembre 2016 23:26:24 UTC+1, Brendan Jacobs ha 
scritto:
>
> I'm trying to research tools or APIs for backing up and restoring OrientDB 
> databases.  Are their existing enterprise tools for backing up and 
> restoring data, and if so are their any videos or documentation on those 
> tools?  
>
> Also, if you know of any other projects that have wrapped your Java APIs 
> in a user interface, could you please send me URLs or project names?  The 
> automatic backup classes seem like they may be extensible for a backup and 
> restore webapp.  Thanks in advance. 
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Orientdb studio give error "server might offline" while executing some queries.

[Oleksandr Gubchenko]

Can you share the query and server logs?

Il giorno venerdì 2 dicembre 2016 05:51:34 UTC+1, Amee ha scritto:
>
> Its not occasional..
> but its strange..query working on console perfectly but not in studio.
>
> On Thursday, 1 December 2016 21:09:03 UTC+5:30, Oleksandr Gubchenko wrote:
>>
>> Is it an occasional behaviour?
>> Also use the latest 2.2.13 version.
>>
>> Il giorno giovedì 1 dicembre 2016 12:51:46 UTC+1, Amee ha scritto:
>>>
>>> Hi
>>> i am using orientdb 2.2.10-SNAPSHOT version.
>>> This error comes while i was fetching specific record with one specific 
>>> class only. 
>>> 2 clusters are connected with this class.
>>> I was thinking like when that specific record created it was connected 
>>> with one node and now may be other node is online.
>>> And Either side..on console everything works well. same query executed 
>>> and data is loaded perfectly.
>>> i am beginner with orientdb so don't know much about cluster , node.
>>>
>>> Thanks
>>>
>>> On Tuesday, 29 November 2016 13:42:04 UTC+5:30, user.w...@gmail.com 
>>> wrote:
>>>>
>>>> Hi,
>>>>
>>>> Can you provide more information? 
>>>> How can I reproduce this issue? 
>>>> Which version are you using?
>>>> Which is your structure?
>>>> What were you trying to do?
>>>> Can you post the query?
>>>>
>>>> Thx in advance
>>>>
>>>> Regards,
>>>> MIchela
>>>>
>>>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Orientdb studio give error "server might offline" while executing some queries.

[Oleksandr Gubchenko]

Is it an occasional behaviour?
Also use the latest 2.2.13 version.

Il giorno giovedì 1 dicembre 2016 12:51:46 UTC+1, Amee ha scritto:
>
> Hi
> i am using orientdb 2.2.10-SNAPSHOT version.
> This error comes while i was fetching specific record with one specific 
> class only. 
> 2 clusters are connected with this class.
> I was thinking like when that specific record created it was connected 
> with one node and now may be other node is online.
> And Either side..on console everything works well. same query executed and 
> data is loaded perfectly.
> i am beginner with orientdb so don't know much about cluster , node.
>
> Thanks
>
> On Tuesday, 29 November 2016 13:42:04 UTC+5:30, user.w...@gmail.com wrote:
>>
>> Hi,
>>
>> Can you provide more information? 
>> How can I reproduce this issue? 
>> Which version are you using?
>> Which is your structure?
>> What were you trying to do?
>> Can you post the query?
>>
>> Thx in advance
>>
>> Regards,
>> MIchela
>>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: [HELP] find document inside list

[Oleksandr Gubchenko]

Try this one:

select from EHR where 'composition' in compositionList.class

Il giorno giovedì 1 dicembre 2016 15:03:58 UTC+1, Oleksandr Gubchenko ha 
scritto:
>
> What is a type of compositionList? Is it an embedded list?
>
> Il giorno giovedì 1 dicembre 2016 14:27:12 UTC+1, Academia Learning Centro 
> de inglés y de formación ha scritto:
>>
>> Hi, I want to look for a document within a list, but I can not find the 
>> way, I'm trying this but it gives me error
>>
>> *select from object where compositionsList traverse ( class = 
>> 'composition' ),* 
>>
>> but this not working
>>
>> *select from EHR where compositionsList['class'] like 'comp%'*
>>
>> { "object" :{
>>
>> "compositionList" : [
>>{"class" : "composition"},
>>{"class" : "example"}
>>
>> ]
>> }
>>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: [HELP] find document inside list

[Oleksandr Gubchenko]

What is a type of compositionList? Is it an embedded list?

Il giorno giovedì 1 dicembre 2016 14:27:12 UTC+1, Academia Learning Centro 
de inglés y de formación ha scritto:
>
> Hi, I want to look for a document within a list, but I can not find the 
> way, I'm trying this but it gives me error
>
> *select from object where compositionsList traverse ( class = 
> 'composition' ),* 
>
> but this not working
>
> *select from EHR where compositionsList['class'] like 'comp%'*
>
> { "object" :{
>
> "compositionList" : [
>{"class" : "composition"},
>{"class" : "example"}
>
> ]
> }
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Good query for for edges regarding start and end vertex.

[Oleksandr Gubchenko]

Hi,  did you tried it using indexes?

Il giorno mercoledì 30 novembre 2016 15:19:24 UTC+1, Ray Neiheiser ha 
scritto:
>
> I have some performance problems with reading edges depending on their 
> start and end nodes. Is there a better way than checking every edges end 
> vertex of every start vertex?
>
> Iterable startNodes = 
> getVertexList(relationshipStorage.getStartNode(), graph);
> Iterable endNodes = 
> getVertexList(relationshipStorage.getEndNode(), graph);
>
> List list = 
> StreamSupport.stream(startNodes.spliterator(), false)
> .flatMap(vertex1 -> 
> StreamSupport.stream(vertex1.getEdges(Direction.OUT, 
> relationshipId).spliterator(), false))
> .filter(edge -> 
> StreamSupport.stream(endNodes.spliterator(), false).anyMatch(vertex -> 
> edge.getVertex(Direction.OUT).equals(vertex)))
> .collect(Collectors.toList());
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: [HELP] Order by date not working

[Oleksandr Gubchenko]

Which version are you using?

Il giorno martedì 29 novembre 2016 14:18:25 UTC+1, Academia Learning Centro 
de inglés y de formación ha scritto:
>
> I have tried with this query and I get this results (not ordered):
>
> *select value.uid.value as id, value.context.start_time.value as date*
> *from CompositionVersions order by value.context.start_time.value desc 
> limit 5*
>
> id
> date
> fe9e6036
> 2014-02-23T12:33:10.000+01:00
> 80eee423
> 2014-03-08T11:35:25.000+01:00
> 0600c7bd
> 2014-01-27T22:49:36.000+01:00
> 291c1e1e
> 2014-03-08T04:28:15.000+01:00
> a8b7d7c9
> 2014-01-04T03:31:02.000+01:00
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Select where version = max (), How would this be done?

[Oleksandr Gubchenko]

Maybe you should use @version

Il giorno venerdì 25 novembre 2016 14:54:53 UTC+1, Aceitunas y encurtidos 
Quijote ha scritto:
>
> I've tried this but it does not work either.
>
> SELECT FROM CompositionVersions LET 
> $temp = (select max(version) from CompositionVersions)
> WHERE $temp = version 
>
> El viernes, 25 de noviembre de 2016, 9:48:53 (UTC+1), Aceitunas y 
> encurtidos Quijote escribió:
>>
>> Hi, I want to retrieve the latest version of each Composition object.
>>
>> *select from CompositionVersions where version = (select max(version) 
>> from CompositionVersions)*
>>
>> But this not working.
>>
>> 1-Is there another more efficient way to recover the latest version, 
>> without knowing the number of versions that there are?
>> 2-Would it be convenient to save in the Composition object, an attribute 
>> with the id of the latest version?
>>  
>>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Unable to shutdown orientGraph

[Oleksandr Gubchenko]

Which version are you using? Can you post server logs or give more 
information?

Il giorno venerdì 25 novembre 2016 10:12:02 UTC+1, Avi gud ha scritto:
>
> Hi,
>
> I am using orientGraph(1.5) to read one graph in java and when i am 
> deploying the JAR in weblogic 12 server, looks like the graph is not 
> shutdown even after the execution completes.
> I am using "graph.shutdown" in my code to shutdown the graph. I am not 
> getting error/exception but unable to update/delete the graphDB created.
>
> Any help is appreciated, thanks in advance.
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Database is closed Exception

[Oleksandr Gubchenko]

Which version are you using?

Il giorno giovedì 24 novembre 2016 14:01:38 UTC+1, Academia Learning Centro 
de inglés y de formación ha scritto:
>
> yes,
>
> [com.tinkerpop.blueprints.impls.orient.OrientBaseGraph.makeActive(OrientBaseGraph.java:361),
>  
> com.tinkerpop.blueprints.impls.orient.OrientBaseGraph.command(OrientBaseGraph.java:1783),
>  
> com.indra.mymed.drm.openehr.test.orientdb.OrientDBOperations.getComposition(OrientDBOperations.java:252),
>  
> com.indra.mymed.drm.openehr.test.OpenEHRBaseTest.test4CompositionInsertAndRetrieve(OpenEHRBaseTest.java:137),
>  
> com.indra.mymed.drm.openehr.test.orientdb.OrientDBTest.test4CompositionInsertAndRetrieve(OrientDBTest.java:42),
>  
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method), 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57),
>  
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43),
>  
> java.lang.reflect.Method.invoke(Method.java:606), 
> org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50),
>  
> org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12),
>  
> org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47),
>  
> org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17),
>  
> org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75),
>  
> org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86),
>  
> org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84),
>  
> org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325), 
> org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:252),
>  
> org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94),
>  
> org.junit.runners.ParentRunner$3.run(ParentRunner.java:290), 
> org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71), 
> org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288), 
> org.junit.runners.ParentRunner.access$000(ParentRunner.java:58), 
> org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268), 
> org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26),
>  
> org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61),
>  
> org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27), 
> org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70),
>  
> org.junit.runners.ParentRunner.run(ParentRunner.java:363), 
> org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191),
>  
> org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86),
>  
> org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38),
>  
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459),
>  
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675),
>  
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382),
>  
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)]
>
> El jueves, 24 de noviembre de 2016, 13:24:27 (UTC+1), Ivan Mainetti 
> escribió:
>>
>> please post at least the full stacktrace
>>
>> Il giorno giovedì 24 novembre 2016 13:03:23 UTC+1, Academia Learning 
>> Centro de inglés y de formación ha scritto:
>>>
>>> In the 2º function when tries to run the command sql, give exception: 
>>> Database is closed (because in ther first function I have done 
>>> graph.shutdown();)
>>>
>>>
>>>
>>> El jueves, 24 de noviembre de 2016, 12:05:38 (UTC+1), Ivan Mainetti 
>>> escribió:

 could you post the exception?
 which part of the code throws it?


 Il giorno giovedì 24 novembre 2016 11:04:08 UTC+1, Academia Learning 
 Centro de inglés y de formación ha scritto:
>
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Adding new spatial reference system native support in lucene Engine for OrientDB

[Oleksandr Gubchenko]

Hi,

have you checked this guides?

http://orientdb.com/docs/last/Spatial-Index.html
http://orientdb.com/spatial-module-orientdb-2-2/

Il giorno martedì 15 novembre 2016 14:43:08 UTC+1, VIKRAM SINGH CHOUHAN ha 
scritto:
>
> Hi All,
>
> I am working on an Open Source GIS project and new to Spatial Reference 
> systems.
>
> As we know the new Lucene Plugin for OrientDB (version 2.2) is enhanced 
> with Support of Complex Geometry like line, polygon etc.
> I am exploring on adding a new spatial reference system native support for 
> storage and retrieval of spatial data in lucene Plugin for OrientDB.
>
> Currently Lucene Engine supports well known WSG_84 reference system.
> I would like to add a native support for a new SRS(Spatial Reference 
> System) i.e. EPSG:27700 and other. i don't want to go with SRS conversions 
> using external library like proj4.
>
> As per my analysis for the support added in Lucene for WSG_84. I found 
> datum configuration parameters in PlanetModel class file like :
>
> WGS84_MEAN = 6371009.0;
> WGS84_POLAR = 6356752.314245;
> WGS84_EQUATORIAL = 6378137.0;
> PlanetModel WGS84 = new PlanetModel (1.0011188180710464, 
> 0.9977622562211103);
>
> which are used in Mathematical evaluations for calculating Flattering of 
> earth, North Pole, South Pole geographical reference Points etc.
>
> I am suspecting this configuration are specific to WSG_84 Spatial 
> reference system only. Is my understanding correct?
> And similarly, there will be new set of configuration needs to be defined 
> for other reference system to achieve a native support in the DB storage 
> and retrieval of GeoSpatial Data.
> Or WSG_84 is a base reference system for all the other Reference Systems 
> and conversion has to happen?
>
> Any suggestion will be very helpful. 
> Thanks in Advance.
>
> Regards,
> vikram
>
>
>
>
>  
>  
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Is it possible to get records without meta-information?

[Oleksandr Gubchenko]

You can open a feature-request on github.

Il giorno martedì 15 novembre 2016 09:16:48 UTC+1, Academia Learning Centro 
de inglés y de formación ha scritto:
>
> The problem is that the resulting json with these attributes does not 
> validate my application schema.
>
> El lunes, 14 de noviembre de 2016, 15:35:21 (UTC+1), Oleksandr Gubchenko 
> escribió:
>>
>> I think you can't do it, because when you use select you get always back 
>> a document("@type": "d",) with its version.
>>
>> Il giorno lunedì 14 novembre 2016 15:13:25 UTC+1, Academia Learning 
>> Centro de inglés y de formación ha scritto:
>>>
>>> Hi,
>>>
>>> I have tried, it has worked with some properties and with others, you 
>>> would not know why?
>>>
>>>
>>> select * from pueblo
>>> {
>>> "result": [
>>> {
>>> "@type": "d",
>>> "@rid": "#67:0",
>>> "@version": 1,
>>> "@class": "pueblo",
>>> "name": "malagon"
>>> },
>>> {
>>> "@type": "d",
>>> "@rid": "#68:0",
>>> "@version": 1,
>>> "@class": "pueblo",
>>> "name": "pozuelo"
>>> },
>>> {
>>> "@type": "d",
>>> "@rid": "#69:0",
>>> "@version": 1,
>>> "@class": "pueblo",
>>> "name": "valenzuela"
>>> }
>>> ],
>>> "notification": "Query executed in 0.038 sec. Returned 3 record(s)"
>>> }
>>>
>>>
>>>
>>> select expand(@this.exclude('@type','@rid','@version','@class')) from 
>>> pueblo
>>> {
>>> "result": [
>>> {
>>> "@type": "d",
>>> "@version": 1,
>>> "name": "malagon"
>>> },
>>> {
>>> "@type": "d",
>>> "@version": 1,
>>> "name": "pozuelo"
>>> },
>>> {
>>> "@type": "d",
>>> "@version": 1,
>>> "name": "valenzuela"
>>> }
>>> ],
>>> "notification": "Query executed in 0.039 sec. Returned 3 record(s)"
>>> }
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> El lunes, 14 de noviembre de 2016, 14:51:48 (UTC+1), Oleksandr Gubchenko 
>>> escribió:
>>>>
>>>> Try this query:
>>>>
>>>> select expand(@this.exclude('@type','@rid','@version','@class')) from v
>>>>
>>>>
>>>>
>>>>
>>>> Il giorno lunedì 14 novembre 2016 14:27:27 UTC+1, Academia Learning 
>>>> Centro de inglés y de formación ha scritto:
>>>>>
>>>>> Can I get records without this parameters?
>>>>>
>>>>> "@type": "d",
>>>>> "@rid": "#21:2",
>>>>> "@version": 1,
>>>>> "@class": "EHR",
>>>>>
>>>>> Thanks
>>>>>
>>>>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Is it possible to get records without meta-information?

[Oleksandr Gubchenko]

I think you can't do it, because when you use select you get always back a 
document("@type": "d",) with its version.

Il giorno lunedì 14 novembre 2016 15:13:25 UTC+1, Academia Learning Centro 
de inglés y de formación ha scritto:
>
> Hi,
>
> I have tried, it has worked with some properties and with others, you 
> would not know why?
>
>
> select * from pueblo
> {
> "result": [
> {
> "@type": "d",
> "@rid": "#67:0",
> "@version": 1,
> "@class": "pueblo",
> "name": "malagon"
> },
> {
> "@type": "d",
> "@rid": "#68:0",
> "@version": 1,
> "@class": "pueblo",
> "name": "pozuelo"
> },
> {
> "@type": "d",
> "@rid": "#69:0",
> "@version": 1,
> "@class": "pueblo",
> "name": "valenzuela"
> }
> ],
> "notification": "Query executed in 0.038 sec. Returned 3 record(s)"
> }
>
>
>
> select expand(@this.exclude('@type','@rid','@version','@class')) from 
> pueblo
> {
> "result": [
> {
> "@type": "d",
>     "@version": 1,
> "name": "malagon"
> },
> {
> "@type": "d",
> "@version": 1,
> "name": "pozuelo"
> },
> {
> "@type": "d",
> "@version": 1,
> "name": "valenzuela"
> }
> ],
> "notification": "Query executed in 0.039 sec. Returned 3 record(s)"
> }
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> El lunes, 14 de noviembre de 2016, 14:51:48 (UTC+1), Oleksandr Gubchenko 
> escribió:
>>
>> Try this query:
>>
>> select expand(@this.exclude('@type','@rid','@version','@class')) from v
>>
>>
>>
>>
>> Il giorno lunedì 14 novembre 2016 14:27:27 UTC+1, Academia Learning 
>> Centro de inglés y de formación ha scritto:
>>>
>>> Can I get records without this parameters?
>>>
>>> "@type": "d",
>>> "@rid": "#21:2",
>>> "@version": 1,
>>> "@class": "EHR",
>>>
>>> Thanks
>>>
>>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Is it possible to get records without meta-information?

[Oleksandr Gubchenko]

Try this query:

select expand(@this.exclude('@type','@rid','@version','@class')) from v




Il giorno lunedì 14 novembre 2016 14:27:27 UTC+1, Academia Learning Centro 
de inglés y de formación ha scritto:
>
> Can I get records without this parameters?
>
> "@type": "d",
> "@rid": "#21:2",
> "@version": 1,
> "@class": "EHR",
>
> Thanks
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Edges Bug?

[Oleksandr Gubchenko]

Yes, it is!

Il giorno lunedì 14 novembre 2016 10:57:20 UTC+1, Ruituraj Gandhi 
(Knowledge Explosion) ha scritto:
>
> Is it with 2.2.11?
>
> ~Ruitu
>
>
> On Nov 14, 2016, at 3:16 PM, Oleksandr Gubchenko <user.w...@gmail.com 
> > wrote:
>
> I've tried it on the same version without problems, same query, the only 
> difference is my rid, see:
>
>
> <https://lh3.googleusercontent.com/-yMfKLYXgw5E/WCmHyGs-QbI/AGs/-j1c-tnRVjcIPi_e1vQ6y0qsYibb-tNUwCLcB/s1600/query_media_person.jpg>
>
> Alex.
>
> Il giorno lunedì 14 novembre 2016 10:33:54 UTC+1, Ruituraj Gandhi 
> (Knowledge Explosion) ha scritto:
>>
>> Yes. Attached
>>
>>
>>
>>
>> On Nov 14, 2016, at 2:51 PM, Oleksandr Gubchenko <user.w...@gmail.com> 
>> wrote:
>>
>> Can you confirm that the structure is the same as here:
>>
>>
>> <https://lh3.googleusercontent.com/-6dM0a0nmK6o/WCmB_CYsbeI/AGU/q6UK1k5c-CgcJ1j0oSs8qAgSyPmsFRJgACLcB/s1600/media_person.jpg>
>>
>>
>>
>>
>> Il giorno lunedì 14 novembre 2016 09:58:26 UTC+1, Ruituraj Gandhi 
>> (Knowledge Explosion) ha scritto:
>>>
>>> Hi,
>>>
>>> I’m having trouble dealing with vertex edges. I’ve a ‘Media’ vertex 
>>> connected with multiple ‘Person' using ‘isUploaded’ edge. 
>>>
>>> I can retrieve the edges separately using following queries:
>>>
>>> *select * from #41:169*
>>> *select * from #41:94*
>>>
>>> But when I try to retrieve edges using ‘Media’, it only returns 1 edge. 
>>> I’ve double checked the edge direction etc and also tried with JAVA api.
>>>  
>>> *select expand(outE(‘isUploaded')) from Media where @rid = '#31:94'*
>>>
>>> I’ve attached the PNG showcasing this.
>>>
>>> Version: 2.2.11
>>> OS: Mac
>>>
>>>
>>>
>>>
>>>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Live query getting stuck

[Oleksandr Gubchenko]

Which version are you using? Can you post more information: logs, your 
code/structure etc.

Alex.

Il giorno lunedì 14 novembre 2016 10:40:25 UTC+1, Shivagami M ha scritto:
>
> We are using live query for getting the updates and storing it into a csv 
> using node js ,live query is running in the background but after two or 
> three days the live query is getting stuck and no data is being updated.Can 
> you please help in solving the issue.
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Edges Bug?

[Oleksandr Gubchenko]

I've tried it on the same version without problems, same query, the only 
difference is my rid, see:

<https://lh3.googleusercontent.com/-yMfKLYXgw5E/WCmHyGs-QbI/AGs/-j1c-tnRVjcIPi_e1vQ6y0qsYibb-tNUwCLcB/s1600/query_media_person.jpg>

Alex.

Il giorno lunedì 14 novembre 2016 10:33:54 UTC+1, Ruituraj Gandhi 
(Knowledge Explosion) ha scritto:
>
> Yes. Attached
>
>
>
>
> On Nov 14, 2016, at 2:51 PM, Oleksandr Gubchenko <user.w...@gmail.com 
> > wrote:
>
> Can you confirm that the structure is the same as here:
>
>
> <https://lh3.googleusercontent.com/-6dM0a0nmK6o/WCmB_CYsbeI/AGU/q6UK1k5c-CgcJ1j0oSs8qAgSyPmsFRJgACLcB/s1600/media_person.jpg>
>
>
>
>
> Il giorno lunedì 14 novembre 2016 09:58:26 UTC+1, Ruituraj Gandhi 
> (Knowledge Explosion) ha scritto:
>>
>> Hi,
>>
>> I’m having trouble dealing with vertex edges. I’ve a ‘Media’ vertex 
>> connected with multiple ‘Person' using ‘isUploaded’ edge. 
>>
>> I can retrieve the edges separately using following queries:
>>
>> *select * from #41:169*
>> *select * from #41:94*
>>
>> But when I try to retrieve edges using ‘Media’, it only returns 1 edge. 
>> I’ve double checked the edge direction etc and also tried with JAVA api.
>>  
>> *select expand(outE(‘isUploaded')) from Media where @rid = '#31:94'*
>>
>> I’ve attached the PNG showcasing this.
>>
>> Version: 2.2.11
>> OS: Mac
>>
>>
>>
>>
>>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Edges Bug?

[Oleksandr Gubchenko]

Can you confirm that the structure is the same as here:






Il giorno lunedì 14 novembre 2016 09:58:26 UTC+1, Ruituraj Gandhi 
(Knowledge Explosion) ha scritto:
>
> Hi,
>
> I’m having trouble dealing with vertex edges. I’ve a ‘Media’ vertex 
> connected with multiple ‘Person' using ‘isUploaded’ edge. 
>
> I can retrieve the edges separately using following queries:
>
> *select * from #41:169*
> *select * from #41:94*
>
> But when I try to retrieve edges using ‘Media’, it only returns 1 edge. 
> I’ve double checked the edge direction etc and also tried with JAVA api.
>  
> *select expand(outE(‘isUploaded')) from Media where @rid = '#31:94'*
>
> I’ve attached the PNG showcasing this.
>
> Version: 2.2.11
> OS: Mac
>
>
>
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: How to write upsert query for edge ?

[Oleksandr Gubchenko]

You can also ask for updates 
here: https://github.com/orientechnologies/orientdb/issues/4436

Il giorno lunedì 7 novembre 2016 11:16:05 UTC+1, user.w...@gmail.com ha 
scritto:
>
> Hi,
>
> can you open an issue?
>
> Thx.
>
> Regards,
> Michela
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Looking for help connecting to OrientDB using OrientDB Studio

[Oleksandr Gubchenko]

By default OrientDB server manages the database under the directory 
"$ORIENTDB_HOME/databases" where $ORIENTDB_HOME is the OrientDB 
installation directory. By setting the configuration parameter 
"server.database.path" in server orientdb-server-config.xml you can specify 
a custom path. Example:


  ...
  

  



Il giorno venerdì 4 novembre 2016 21:04:20 UTC+1, Erik T ha scritto:
>
> Hello,
>
> I'm using OrientDB 2.2.6 on Windows 7. I have set up an embedded OrientDB 
> instance using a plocal connection. I'm unable to view my database as an 
> option in Studio. It appears Studio doesn't 'see' my database. I tried 
> specifying the location manually using 'New DB' but failed to create the 
> instance since an instance with that name already exists. I tried closing 
> the plocal connection to see if my DB would show in the drop down but its 
> still not there. I must have the wrong folder structure in my application. 
> I'm not entirely sure how to set up that structure though. How should it be 
> set up?
>
> I attached a pic to show what I have so far. orientDbTestHttp is my 
> application and orientSystemDb is where I want to store my database. There 
> is a set of database files there and two folders 
> 1) databases
> 2) plugins
>
> plugins contains studio-2.2.zip and databases contains another set of 
> database files. I placed the plugins directory in this location but I'm not 
> sure if this is correct.
>
> Can some one tell me how I should set up my folder structure in my 
> orientDbTestHttp application so I can access my orientSystemDb using the 
> OrientDB studio?
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: traverse in a graph with a restricted cluser throws a security exception rendering traverse unusable

[Oleksandr Gubchenko]

Hi,

I've reproduced your issue, can you open a request on github?

Thanks.

Il giorno giovedì 3 novembre 2016 20:20:35 UTC+1, Neil Dsouza ha scritto:
>
> and for anyone else:
>
> after this, login as reader and do
> select from product -->  i would expect bananas
> or select expand(in('intermediate')) from manufacturing--> i would expect 
> bananas
>
> 
> create class product extends V
> create class product_secret extends product
> create class manufacturing extends V
> create class intermediate extends E
> alter class OIdentity superclass V
> UPDATE ORole PUT rules = "database.class.product_secret", 0 WHERE name = 
> "reader"
> UPDATE ORole PUT rules = "database.cluster.product_secret", 0 WHERE name = 
> "reader"
>
>
> insert into product set name = 'bananas'
> insert into manufacturing set name = 'banana growing'
> insert into product_secret set name = 'apples'
> insert into manufacturing set name = 'apple growing'
> create edge intermediate from (select from product where name = 'bananas') 
> to (select from manufacturing where name = 'banana growing')
> create edge intermediate from (select from product where name = 'apples') 
> to (select from manufacturing where name = 'apple growing')
>
> 
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Can't start distributed configuration

[Oleksandr Gubchenko]

Are you getting the same exception on 2.2.12 version?

Il giorno mercoledì 2 novembre 2016 03:09:23 UTC+1, André Toscano ha 
scritto:
>
> Hi guys, 
> I followed the guide here: 
> http://orientdb.com/docs/2.2/Distributed-Configuration.html
> I'm using community version 2.2.11.
>
> Any hint about the error below:
>
> 
> ...
> Members [2] {
> Member [192.168.30.91]:2434
> Member [192.168.30.92]:2434 this
> }
>  [ClusterService]
> 2016-11-02 00:00:13:598 INFO  [192.168.30.92]:2434 [orientdb] [3.6.5] 
> Address[192.168.30.92]:2434 is STARTED [LifecycleService]
> 2016-11-02 00:00:13:598 INFO  Starting distributed server 'odb-node2' 
> (hzID=33db0e9a-5839-4072-ad11-1ca6f934cba1)... [OHazelcastPlugin]
> 2016-11-02 00:00:13:693 WARNI [odb-node2] Servers in cluster: [odb-node2, 
> odb-node1] [OHazelcastPlugin]
> 2016-11-02 00:00:13:955 INFO  [odb-node2] Current node is a MASTER for 
> database 'bid-monitor' [OHazelcastPlugin]
> 2016-11-02 00:00:13:976 INFO  [odb-node2] New distributed configuration 
> for database: bid-monitor (version=1)
>
> CLUSTER CONFIGURATION (LEGEND: X = Owner, o = Copy)
> ++---+--+-+-+-+
> ||   |  | MASTER  |   MASTER|   MASTER|
> ||   |  | ONLINE  |NOT_AVAILABLE|NOT_AVAILABLE|
> ++---+--+-+-+-+
> |CLUSTER |writeQuorum|readQuorum|odb-node1|  odb-node2  |  odb-node3  |
> ++---+--+-+-+-+
> |*   | 1 |1 |X|  o  |  o  |
> |internal| 1 |1 | | | |
> ++---+--+-+-+-+
>
>  [OHazelcastPlugin]
> 2016-11-02 00:00:13:977 INFO  [odb-node2] Saving distributed configuration 
> file for database 'bid-monitor' to: 
> /orientdb/databases/bid-monitor/distributed-config.json [OHazelcastPlugin]
> 2016-11-02 00:00:14:070 INFO  [odb-node2] Distributed servers status:
>
>
> +--++---+-+---+--+--++
> |Name  |Status  |Databases  |Conns|StartedOn   
>|Binary|HTTP  |UsedMemory  |
>
> +--++---+-+---+--+--++
> |odb-node2*|STARTING|   |0|2016-11-01 
> 23:59:59.383|192.168.30.92:2424|192.168.30.92:2480|56.19MB/3.56GB (1.54%)  |
> |odb-node1 |ONLINE  |bid-monitor=ONLINE (MASTER)|1|2016-11-01 
> 23:58:23.890|192.168.30.91:2424|192.168.30.91:2480|776.88MB/3.56GB (21.34%)|
>
> +--++---+-+---+--+--++
>  [OHazelcastPlugin]
> 2016-11-02 00:00:14:087 WARNI [odb-node2]->[[odb-node1]] Requesting deploy 
> of database 'bid-monitor' on local server... [OHazelcastPlugin]
> 2016-11-02 00:00:18:482 WARNI [odb-node2] Moving existent database 
> 'bid-monitor' in '/orientdb/databases/bid-monitor' to 
> '/orientdb/databases//../backup/databases/bid-monitor' and get a fresh copy 
> from a remote node... [OHazelcastPlugin]
> 2016-11-02 00:00:18:483 INFO  [odb-node2]<-[odb-node1] Copying remote 
> database 'bid-monitor' to: /tmp/orientdb/install_bid-monitor.zip 
> [OHazelcastPlugin]
> 2016-11-02 00:00:18:486 INFO  [odb-node2]<-[odb-node1] Installing database 
> 'bid-monitor' to: /orientdb/databases/bid-monitor... [OHazelcastPlugin]
> 2016-11-02 00:00:18:488 INFO  [odb-node2] - writing chunk #1 offset=0 
> size=8.00MB [OHazelcastPlugin]
> 2016-11-02 00:00:19:470 INFO  [odb-node2] - writing chunk #2 
> offset=8388589 size=19b [OHazelcastPlugin]
> 2016-11-02 00:00:19:486 INFO  [odb-node2] - writing chunk #3 
> offset=8388608 size=3.18MB [OHazelcastPlugin]
> 2016-11-02 00:00:19:518 INFO  [odb-node2] - writing chunk #4 
> offset=11718656 size=4.82MB [OHazelcastPlugin]
> 2016-11-02 00:00:20:806 INFO  [odb-node2] - writing chunk #5 
> offset=16777135 size=81b [OHazelcastPlugin]
> 2016-11-02 00:00:20:820 INFO  [odb-node2] - writing chunk #6 
> offset=16777216 size=2.52MB [OHazelcastPlugin]
> 2016-11-02 00:00:20:848 INFO  [odb-node2] - writing chunk #7 
> offset=19415040 size=5.48MB [OHazelcastPlugin]
> 2016-11-02 00:00:22:370 INFO  [odb-node2] - writing chunk #8 
> offset=25165254 size=570b [OHazelcastPlugin]
> 2016-11-02 00:00:22:389 INFO  [odb-node2] - writing chunk #9 
> offset=25165824 size=2.98MB [OHazelcastPlugin]
> 2016-11-02 00:00:22:418 INFO  [odb-node2] - writing chunk #10 
> offset=28286976 size=5.02MB [OHazelcastPlugin]
> 2016-11-02 00:00:23:764 INFO  [odb-node2] - writing chunk #11 
> offset=33553780 size=652b [OHazelcastPlugin]
> 2016-11-02 00:00:23:774 INFO  [odb-node2] - writing chunk #12 
> 

[orientdb] Re: Let is not working on sub-query

[Oleksandr Gubchenko]

Can you try this one?

select $aa.@rid, a from B
let $aa = (select from A where id = 1)



Il giorno mercoledì 26 ottobre 2016 08:37:19 UTC+2, boro...@gmail.com ha 
scritto:
>
>
> Hello,
>
> I seem to run into a wall while trying to figure the LET statement which 
> is just failing on me, Here are 2 classes where one has link to another. I 
> need to use the LET statement to get the linked class by provided id, but 
> the result never returns any records. Sub query does return the result 
> correctly, but not the query with the LET statement.
>
> My classes:
>
> create class A extends V
> create property A.id INTEGER (NOTNULL TRUE, MANDATORY TRUE)
>
> create class B extends V
> create property B.a LINK A (NOTNULL TRUE, MANDATORY TRUE)
>
> insert into A (id) values (1)
> insert into B set a = (select from A where id = 1)
>
> select from B let $aa = (select from A where id = 1) where a = $aa
> select from B let $aa = (select from A where id = 1) where a = $aa.@rid
>
>
> Here is the data
>
> orientdb {db=Customers}> select from A
>
> ++--+--++
> |#   |@RID  |@CLASS|id  |
> ++--+--++
> |0   |#185:0|A |1   |
> ++--+--++
>
> 1 item(s) found. Query executed in 0.002 sec(s).
> orientdb {db=Customers}> insert into B set a = (select from A where id = 
> 1)
>
> Inserted record 'B#189:0{a:#185:0} v1' in 0.004000 sec(s).
>
> orientdb {db=Customers}> select from B
>
> ++--+--+--+
> |#   |@RID  |@CLASS|a |
> ++--+--+--+
> |0   |#189:0|B |#185:0|
> ++--+--+--+
>
>
> As you can see from above, class B has a link to class A. In my 
> understanding the query below must work, but it returns nothing. I tried 2 
> combinations of the query and both don't work.
>
> orientdb {db=Customers}> select from B let $aa = (select from A where id = 
> 1) where a = $aa
>
> 0 item(s) found. Query executed in 0.003 sec(s).
>
> orientdb {db=Customers}> select from B let $aa = (select from A where id 
> = 1) where a = $aa.@rid
>
> 0 item(s) found. Query executed in 0.003 sec(s).
>
>
>
> Am I doing something wrong or is it a bug?
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: select @rid from expand() not working

[Oleksandr Gubchenko]

Try this query:

select expand(out("Sell").@rid) from Account where @rid=#25:0

Hope it helps.

Il giorno mercoledì 26 ottobre 2016 07:06:23 UTC+2, boro...@gmail.com ha 
scritto:
>
> Hello, I'm running OrientDB 2.2.12 on Mac/Linux
>
> I'm trying to perform a simple out() lookup from a class and get all 
> properties of another class. I can get all properties except @rid. I tried 
> different ways, but nothing seem to work or return the @rid. How do I get 
> the @rid as a property? Here is what I tried:
>
> My class: 
>
> orientdb {db=Customers}> info class SellCampaign
>
>
> CLASS 'SellCampaign'
>
> Records..: 1
>
> Super classes: [V]
>
> Default cluster..: sellcampaign (id=149)
>
> Supported clusters...: sellcampaign(149), sellcampaign_1(150), 
> sellcampaign_2(151), sellcampaign_3(152)
>
> Cluster selection: round-robin
>
> Oversize.: 0.0
>
>
> PROPERTIES
>
>
> ++++-+-+++++---+---+
>
> |#   |NAME|TYPE|LINKED-TYPE/CLASS|MANDATORY|READONLY|NOT-NULL|MIN 
> |MAX |COLLATE|DEFAULT|
>
>
> ++++-+-+++++---+---+
>
> |0   |leadCategory|LINK|LeadCategory |true |false   |true|   
>  ||default|   |
>
>
> ++++-+-+++++---+---+
>
> Here are the queries I tried:
>
> // returns only leadCategory property
> select expand(out('Sell')) from Account where @rid = #25:0
>
> // returns only leadCategory property
> select expand(out('Sell').include('@rid','leadCategory')) from Account 
> where @rid = #25:0
>
> // results in error
> select expand(out('Sell').include(@rid.asString(),'leadCategory')) from 
> Account where @rid = #25:0
>
> Error on execution of command: sql.select 
> expand(out('Sell').include(@rid.asString(),'leadCategory')) from Account 
> where @rid = #25:0
> DB name="Customers"
> DB name="Customers"
>
> If I simply run a select statement with @rid.asString() it works fine: 
> select @rid.asString(), leadCategory from SellCampaign
>
>
> How do I get the @rid of the class when I traverse to it?
>
> Please help.
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: onCreate.identityType=role not the first one

[Oleksandr Gubchenko]

I've answered you on stack.

Alex.

Il giorno martedì 25 ottobre 2016 10:09:46 UTC+2, lu...@emaxsrl.com ha 
scritto:
>
> I'm using v. 2.2.12 enterprise. 
>
> I've got a problem using onCreate.identityType. 
>
> The documentation says:
>
> onCreate.identityType: Specifies whether to insert the user's object or its 
> role (*the first one*). By default, it is set to user, but you can also set 
> it to use its role.
>
> But it's not true, I've got a user with multiple roles and inserting a new 
> record into a ORestricted class it takes randomly on of them. Here what I 
> did:
>
>- create a new db
>- create class test extends ORestricted
>- ALTER CLASS test CUSTOM onCreate.identityType=role
>- insert into ouser set 
>name='test',password='test',status='ACTIVE',roles=(select from orole where 
>name in ['reader','writer'])
>- Logged with test user
>- insert into test set now=sysdate() (x 10 times)
>
> Casually _allow field contains #4:1 or #4:2
>
> Is it a bug? 
>
> If not, any suggestion for making it work like written in the 
> documentation?
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: orientDB picturs

[Oleksandr Gubchenko]

Hello,

what do you mean pictures? If you need to install OrientDB follow this 
guide: http://orientdb.com/docs/last/Tutorial-Installation.html
What is your operating system?
You can also start from this Udemy course for complete beginners which will 
show you also installation process at the very 
beginning: https://www.udemy.com/orientdb-getting-started/

Oleksandr.

Il giorno venerdì 14 ottobre 2016 18:27:40 UTC+2, Hosain Yaghobi ha scritto:
>
>
> Hi!
>
> i start with orientDB.
> befor use !
>  
> i need to get the picturs screenshut about  orientedDB  environment. 
> instalation  and use .
>
> pleaze send  to me if you have.
>
> thanks.
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: OrientDB and Rexster

[Oleksandr Gubchenko]

For informatio about supported rexster 
see: http://orientdb.com/docs/last/Rexster.html

Il giorno giovedì 13 ottobre 2016 11:13:56 UTC+2, Nigel Brown ha scritto:
>
> I have an existing system running titan/rexster/rexster-plugin. I am 
> interested in swapping titan for orientdb.
>
> I have orient 2.2 and rexster 2.5.0 set up like so
> 
>   true
>   g
>   com.tinkerpop.rexster.OrientGraphConfiguration
> 
>   remote:localhost/datagraph
> 
> root
> 
> 
> 
>   
> plgin:origin
>   
>
> 
> 
>
> My plugin is receiving post/get requests (I step through the code), which 
> it then processes and returns good results at the end of the @
> ExtensionDefinition .
> Unfortunately, lower down the call stack an exception is thrown because 
> Orient does not supportsThreadIsolatedTransactions . The get response 
> just states "Internal Error".
>
> My question is how to avoid this?
>
> What are the supported versions of rexster and orientdb (if any)?
>
> And a bonus question, what is the status of Tinkerpop3?
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Can't remove embedded list item from 3 levels down

[Oleksandr Gubchenko]

Is this issue similar to your case? Can you confirm?
https://github.com/orientechnologies/orientdb/issues/5703

Il giorno mercoledì 12 ottobre 2016 18:16:28 UTC+2, Oleksandr Gubchenko ha 
scritto:
>
> Can you add an insert that you are using to originally create the #25:0 ?
>
> Thanks.
>
> Il giorno mercoledì 12 ottobre 2016 17:47:25 UTC+2, boro...@gmail.com ha 
> scritto:
>>
>> Hi Michela, here are the schemas starting from the most inner class and 
>> up all the way to account. 
>>
>> // Property Override
>> create class PropertyOverride extends V
>> create property PropertyOverride.standardProperty STRING (NOTNULL TRUE)
>> create property PropertyOverride.customProperty STRING (NOTNULL TRUE)
>> create property PropertyOverride.customValues EMBEDDEDMAP STRING (NOTNULL 
>> TRUE)
>>
>> // Class Override
>> create class LeadClass extends V
>> create property LeadClass.template STRING (NOTNULL TRUE)
>> create property LeadClass.booleanTrue STRING (NOTNULL TRUE, COLLATE "ci")
>> create property LeadClass.booleanFalse STRING (NOTNULL TRUE, COLLATE "ci")
>> create property LeadClass.dateFormat STRING (NOTNULL TRUE, COLLATE "ci")
>> create property LeadClass.timestampFormat STRING (NOTNULL TRUE, COLLATE 
>> "ci")
>> create property LeadClass.overrideProperties EMBEDDEDLIST 
>> PropertyOverride (NOTNULL TRUE)
>>
>> // Account Settings
>> create class AccountSettings extends V
>> create property AccountSettings.leads EMBEDDEDMAP LeadClass
>>
>> // Account
>> create class Account extends V
>> create property Account.id INTEGER (DEFAULT 
>> "sequence('accountId').next()", READONLY TRUE)
>> create property Account.created DATETIME (DEFAULT "sysdate()", READONLY 
>> TRUE)
>> create property Account.active BOOLEAN (NOTNULL TRUE, DEFAULT FALSE)
>> create property Account.company STRING (NOTNULL TRUE, MANDATORY TRUE, MIN 
>> 2, MAX 50, COLLATE "ci")
>> create property Account.settings EMBEDDED AccountSettings
>>
>> The #25:0 (in the original post) is the actual Account record. What I'm 
>> trying to do is to simply add/remove PropertyOverride embedded classes to 
>> the LeadClass.overrideProperties embedded list in the LeadClass. I could 
>> add it easy as mentioned before, but when I tried to remove it I ran into 
>> exceptions. All is done in the terminal. Thanks for helping to figure it 
>> out.
>>
>>
>> On Tuesday, October 11, 2016 at 11:35:08 PM UTC-7, user.w...@gmail.com 
>> wrote:
>>>
>>> Hi,
>>>
>>> can you post you schema? I don't understand very well your structure. 
>>>
>>> Regards,
>>> Michela
>>>
>>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Can't remove embedded list item from 3 levels down

[Oleksandr Gubchenko]

Can you ad an insert that you are using to originally create the #25:0  ?

Thanks.

Il giorno mercoledì 12 ottobre 2016 17:47:25 UTC+2, boro...@gmail.com ha 
scritto:
>
> Hi Michela, here are the schemas starting from the most inner class and up 
> all the way to account. 
>
> // Property Override
> create class PropertyOverride extends V
> create property PropertyOverride.standardProperty STRING (NOTNULL TRUE)
> create property PropertyOverride.customProperty STRING (NOTNULL TRUE)
> create property PropertyOverride.customValues EMBEDDEDMAP STRING (NOTNULL 
> TRUE)
>
> // Class Override
> create class LeadClass extends V
> create property LeadClass.template STRING (NOTNULL TRUE)
> create property LeadClass.booleanTrue STRING (NOTNULL TRUE, COLLATE "ci")
> create property LeadClass.booleanFalse STRING (NOTNULL TRUE, COLLATE "ci")
> create property LeadClass.dateFormat STRING (NOTNULL TRUE, COLLATE "ci")
> create property LeadClass.timestampFormat STRING (NOTNULL TRUE, COLLATE 
> "ci")
> create property LeadClass.overrideProperties EMBEDDEDLIST PropertyOverride 
> (NOTNULL TRUE)
>
> // Account Settings
> create class AccountSettings extends V
> create property AccountSettings.leads EMBEDDEDMAP LeadClass
>
> // Account
> create class Account extends V
> create property Account.id INTEGER (DEFAULT 
> "sequence('accountId').next()", READONLY TRUE)
> create property Account.created DATETIME (DEFAULT "sysdate()", READONLY 
> TRUE)
> create property Account.active BOOLEAN (NOTNULL TRUE, DEFAULT FALSE)
> create property Account.company STRING (NOTNULL TRUE, MANDATORY TRUE, MIN 
> 2, MAX 50, COLLATE "ci")
> create property Account.settings EMBEDDED AccountSettings
>
> The #25:0 (in the original post) is the actual Account record. What I'm 
> trying to do is to simply add/remove PropertyOverride embedded classes to 
> the LeadClass.overrideProperties embedded list in the LeadClass. I could 
> add it easy as mentioned before, but when I tried to remove it I ran into 
> exceptions. All is done in the terminal. Thanks for helping to figure it 
> out.
>
>
> On Tuesday, October 11, 2016 at 11:35:08 PM UTC-7, user.w...@gmail.com 
> wrote:
>>
>> Hi,
>>
>> can you post you schema? I don't understand very well your structure. 
>>
>> Regards,
>> Michela
>>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: "out_" array empty when there's too many outgoing edges

[Oleksandr Gubchenko]

You can try implementing it with a SQL query inside your function, using:
LIMIT

see: http://orientdb.com/docs/last/SQL-Query.html

Il giorno martedì 11 ottobre 2016 19:57:25 UTC+2, Alexandre DeFreitas ha 
scritto:
>
> Hello,
>
> I'm using OrientJS's query builder to fetch records (nodes) each of which 
> has multiple outgoing edges to other records.  When the number of outgoing 
> edges for a record is relatively small, such as 15 or so, the "out_" 
> property of the query result contains the outgoing references to the other 
> records as expected.
>
> However, I have a node that has 101 outgoing edges that keeps returning an 
> empty "out_" property.  I searched Google, SO, and the OrientDB docs high 
> and low and played with various settings in orientdb-server-config.xml such 
> as db.pool.max, graph.pool.max, and distributed.queueMaxSize, but "out_" 
> still comes back empty.
>
> I hope my explanation makes sense.   Is there a setting in a config file 
> somewhere that limits the number of nodes that can be referenced and 
> returned in a result set?
>
> Thanks
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: custom function returns the same result

[Oleksandr Gubchenko]

I didn't get your last post, sorry.

Il giorno sabato 8 ottobre 2016 00:59:07 UTC+2, Renzo Ludeña ha scritto:
>
>
> thank you very much run the size ()
>
>
>
> 
>
>
>
>
>
>
>
>
>
>
>
> El viernes, 7 de octubre de 2016, 17:19:59 (UTC-5), Renzo Ludeña escribió:
>>
>> Hello friends, I created a function in orientdb studio use the version 
>> 2.2.4 but when I called me back the same result for all
>>
>>
>>
>> 
>>
>>
>>
>>
>>
>>
>> 
>>
>>
>> thanks for your help
>>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: custom function returns the same result

[Oleksandr Gubchenko]

Where is the issue? Can you explain better, please? You are querying for 
data from a record id #27:0 so you get it.
Do you want the same output from browse section using SQL? If so, you can 
just call saved function by calling it from browse section:
select expand(countComment(#27:0))



Il giorno sabato 8 ottobre 2016 00:38:20 UTC+2, Renzo Ludeña ha scritto:
>
>
> thanks for your answer did also the command but I keep returning the same 
>> result, the negative think is the id of the function, if I call 
>> individually works well
>>
>
>
> 
>  
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: custom function returns the same result

[Oleksandr Gubchenko]

Hi, I see a negative rid in your output, can you try with this code?

var g= orient.getGraph();
var query= g.command("sql","YOUR_QUERY_HERE");
return query;



Il giorno sabato 8 ottobre 2016 00:19:59 UTC+2, Renzo Ludeña ha scritto:
>
> Hello friends, I created a function in orientdb studio use the version 
> 2.2.4 but when I called me back the same result for all
>
>
>
> 
>
>
>
>
>
>
> 
>
>
> thanks for your help
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Problem with UPSERT on Edges

[Oleksandr Gubchenko]

Answered you on stack, there is no need to post the same question here and 
on stack.

Thanks.

Il giorno giovedì 6 ottobre 2016 19:02:54 UTC+2, nick@icgsolutions.com 
ha scritto:
>
> Hello,
>
> I have a Vertex class called Person and an Edge class called Relationship. 
>  When I try to UPSERT an edge using the following: 
>
> *update relationship set in = #123, out = #456 upsert where in = #123 and 
> out = #456*
>
> The command succeeds, the Relationship is created, but the Person vertices 
> aren't updated with "in" and "out" values.  So the Edge knows about itself 
> but the Vertices don't.  This means in() and out() queries are broken, as 
> is the graph view in studio. 
>
> If I run the following, everything works as expected: 
>
> *create edge relationship from #123 to #456*
>
> I need to run the update/upsert query though, as I intend on using unique 
> constraints on my edges.  
>
> Any help would be appreciated.  
>
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Unable to list connections

[Oleksandr Gubchenko]

Tried both on 2.2.0 and 2.2.1, in remote and plocal, same behaviour as 
described by you.
You can open an issue on github.

Thanks.

Il giorno venerdì 30 settembre 2016 07:20:44 UTC+2, boro...@gmail.com ha 
scritto:
>
> Hello guys, 
>
> I'm new to OrientDB and trying to simply list connections but puzzled here 
> if I'm doing something wrong or is it a bug. Every time I execute "list 
> connections" I get an error message. I tried with root and admin users to 
> no avail. Here are the steps I followed:
>
>
> iMac:developer mike$ orientdb-community-2.2.10/bin/console.sh 
>
>
> OrientDB console v.2.2.10 (build 
> 2.2.x@rc32d4ee06d4c38e27eb66931d027eb54854872ff; 2016-09-15 08:47:27+) 
> www.orientdb.com
>
> Type 'help' to display all the supported commands.
>
> Installing extensions for GREMLIN language v.2.6.0
>
>
> orientdb> *connect remote:localhost/Customers root*  
>
> Enter password: 
>
>
> Connecting to database [remote:localhost/Customers] with user 'root'...OK
>
> orientdb {db=Customers}> *list indexes*
>
>
> INDEXES
>
>
> ++--+-+---+-+---+---+
>
> |#   |NAME  |TYPE |RECORDS|CLASS|COLLATE|FIELDS   
>   |
>
>
> ++--+-+---+-+---+---+
>
> |0   |accessKey |UNIQUE   |8  |Account  
> |default|accessKey(STRING)  |
>
> |1   |accountId |UNIQUE   |8  |Account  
> |default|id(INTEGER)|
>
> |2   |dictionary|DICTIONARY   |0  | |default| 
>   |
>
> |3   |OFunction.name|UNIQUE_HASH_INDEX|0  
> |OFunction|default|name(STRING)   |
>
> |4   |ORole.name|UNIQUE   |3  |ORole|ci 
> |name(STRING)   |
>
> |5   |OUser.name|UNIQUE   |3  |OUser|ci 
> |name(STRING)   |
>
> |6   |purchaseKey   |UNIQUE   |8  |Account  
> |default|purchaseKey(STRING)|
>
> |7   |settingsKey   |UNIQUE   |1  |Settings 
> |default|key(STRING)|
>
> |8   |systemIP  |UNIQUE   |3  |systemIP 
> |default|ip(STRING) |
>
> |9   |userEmail |UNIQUE   |3  |User 
> |default|email(STRING)  |
>
>
> ++--+-+---+-+---+---+
>
> ||TOTAL | |37 | |   | 
>   |
>
>
> ++--+-+---+-+---+---+
>
> orientdb {db=Customers}> *list connections*
>
>
> Not connected to the Server instance. You've to connect to the Server 
> using server's credentials (look at orientdb-*server-config.xml file)
>
> orientdb {db=Customers}> 
>
>
> As you can see, I am connected to the database and can run queries, but 
> not "list connections" one.
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Query for filter based on date of birth.

[Oleksandr Gubchenko]

Can you share your test DB ore describe your databases's schema, please?
What version are you using?

Il giorno giovedì 29 settembre 2016 15:25:13 UTC+2, Pugazharasan Thirumalai 
ha scritto:
>
> Structure is '2015-12-06 00:00:00
>
>
> Actually this query is work when from date is '2016-9-29' and to date up 
> to '2016-12-31'
>
> select dob, anniversary_date from (select expand(out('store_customer')) 
> from #48:843) where is_deleted = 0 and in_store_customer['out = 
> #48:843'].is_active = 1 and dob.format('MM-dd') between '09-29' to '12-31' 
> desc skip 0 limit 11
>
> but if my to date changes to next year  ie to '2017-01-31' that query is 
> not working
>
> select dob, anniversary_date from (select expand(out('store_customer')) 
> from #48:843) where is_deleted = 0 and in_store_customer['out = 
> #48:843'].is_active = 1 and dob.format('MM-dd') between '09-29' to '01-31' 
> desc skip 0 limit 11
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Query for filter based on date of birth.

[Oleksandr Gubchenko]

What is your structure?
What query are you using?

Il giorno giovedì 29 settembre 2016 13:03:33 UTC+2, Pugazharasan Thirumalai 
ha scritto:
>
> Hai,
>
> Am trying to get list of upcoming birthday of the customer from the 
> database but i can't get exact list from the database.
>
> Thanks and Regards,
> T.Pugazharasan
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Exposing traversal depth from MATCH

[Oleksandr Gubchenko]

$depth is used in while condition, so you define it.
Are you looking for shortest/longest path?

Il giorno lunedì 26 settembre 2016 23:18:07 UTC+2, user.w...@gmail.com ha 
scritto:
>
> Hi,
>
> can you explain it better?
>
> Thx
>
> Regards,
> Michela
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Wrong result with simple query

[Oleksandr Gubchenko]

I've unswered you on stackoverflow.

Il giorno lunedì 26 settembre 2016 13:37:25 UTC+2, Tan Ho ha scritto:
>
> Seem that OrientDB doesn't return the correct result for the simple search.
>
> I created a class node item with 2 properties id and flag
>
>
>- id: type STRING, index: UNIQUE
>- flag: type DECIMAL
>
> flag can be set by 1, 0, or null value.
>
> I use the query below to get all item which has flag is 1
>
> `select from item where flag = 1`
>
> But the query returns nothing.
>
> *Note:* I have tested on 2.2.7 and 2.2.10, and seem that this issue only 
> occurs if flag was defined in schema before feeding data.
> Is it bug?
>
> Thanks and best regards,
>
> Tan
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Issue with Orient DB Clustering

[Oleksandr Gubchenko]

If you run out of available connections, this means the client never closes 
them.
Can you post your full code?

Il giorno lunedì 26 settembre 2016 08:37:38 UTC+2, Krishna Kant ha scritto:
>
> I am using 2.2.4 DB version and for orient Graph orientGraphVersion=2.2.8 is 
> my JAR dependency in code.
>
> On Monday, 26 September 2016 09:54:13 UTC+5:30, Oleksandr Gubchenko wrote:
>>
>> Which version are you using?
>>
>> Il giorno sabato 24 settembre 2016 15:30:10 UTC+2, Krishna Kant ha 
>> scritto:
>>>
>>> Hi All,
>>>
>>> I am setting up Orient DB master-master cluster environment and facing 
>>> below two issues:
>>> 1)Maximum connection reached
>>> 2)Concurrent modification exception while writing record.
>>>
>>> I am using Orient Graph factory with max 20 connection for my 4 client 
>>> apps. Also all the graph related call is surrounded by try and finally 
>>> having graph.shutdown(), so where connection is getting leaked?
>>>
>>> Another issue which I am observing is writing a vertex to class in 
>>> clustered environment. It hits OConcurrentModificationException and once I 
>>> try to print the IDs I saw the record got started with #60:0 and while 
>>> commit during graph.shutdown() it has id as #60:1. I do not have any 
>>> concurrent thread running. So is DB sync up can modify the record id.
>>>
>>> Same write record once i tried using single node it worked fine.
>>>
>>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Limit Skip Query Issue

[Oleksandr Gubchenko]

Post your full complex query.

Il giorno domenica 25 settembre 2016 17:25:32 UTC+2, Ruituraj Gandhi 
(Knowledge Explosion) ha scritto:
>
> Hi,
>
> Trying to understand the unexpected behavior with following query - 
>
> *select mid, path, sz, created FROM (select * from Media ORDER BY created 
> DESC LIMIT 20 SKIP 1)*
>
> Scenario:
> I’ve *5* records in the db. This query ‘select * from Media ORDER BY 
> created DESC LIMIT 20 SKIP 1’ skips first record and returns *4* records, 
> which I intend to do.
>
> But when I combine it like this ‘select mid, path, created FROM (select * 
> from Media ORDER BY created DESC LIMIT 20 SKIP 1)’ it *doesn’t skip* the 
> records. I would expect it to get details for only filtered results (4 
> records) but returns details for 5. Is it a bug or something wrong with the 
> query. The above query is simple version of the complex query. 
>
> Please can someone comment on it?
>
> *OS - Mac*
> *Orientdb - 2.2.6*
>
>
> ~Ruitu
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Issue with Orient DB Clustering

[Oleksandr Gubchenko]

Which version are you using?

Il giorno sabato 24 settembre 2016 15:30:10 UTC+2, Krishna Kant ha scritto:
>
> Hi All,
>
> I am setting up Orient DB master-master cluster environment and facing 
> below two issues:
> 1)Maximum connection reached
> 2)Concurrent modification exception while writing record.
>
> I am using Orient Graph factory with max 20 connection for my 4 client 
> apps. Also all the graph related call is surrounded by try and finally 
> having graph.shutdown(), so where connection is getting leaked?
>
> Another issue which I am observing is writing a vertex to class in 
> clustered environment. It hits OConcurrentModificationException and once I 
> try to print the IDs I saw the record got started with #60:0 and while 
> commit during graph.shutdown() it has id as #60:1. I do not have any 
> concurrent thread running. So is DB sync up can modify the record id.
>
> Same write record once i tried using single node it worked fine.
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Error on unmarshalling field

[Oleksandr Gubchenko]

You can also try exporting your db and than importing it 
again: http://orientdb.com/docs/last/Export-and-Import.html
But the best solution would be upgrade to the latest 2.2.x release with all 
bug-fixes of these years.
See: http://orientdb.com/docs/last/Upgrade.html for instructions. If you 
need any assistance with upgrade you can just ask.

Alex.

Il giorno giovedì 22 settembre 2016 12:05:08 UTC+2, Pugazharasan Thirumalai 
ha scritto:
>
> No..
>
> On Thursday, September 22, 2016 at 3:29:17 PM UTC+5:30, Oleksandr 
> Gubchenko wrote:
>>
>> So after this you are able to do delete or select the rid?
>>
>> Il giorno giovedì 22 settembre 2016 11:55:27 UTC+2, Pugazharasan 
>> Thirumalai ha scritto:
>>>
>>> Repairing database...
>>> - Fixing dirty links...Done! Fixed links: 186, modified documents: 6
>>> Repair database complete (0 errors)
>>> orientdb {db=crm}>
>>>
>>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Error on unmarshalling field

[Oleksandr Gubchenko]

So after this you are able to do delete or select of the rid?

Il giorno giovedì 22 settembre 2016 11:55:27 UTC+2, Pugazharasan Thirumalai 
ha scritto:
>
> Repairing database...
> - Fixing dirty links...Done! Fixed links: 186, modified documents: 6
> Repair database complete (0 errors)
> orientdb {db=crm}>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Error on unmarshalling field

[Oleksandr Gubchenko]

What is data type of install_count property?

Il giorno giovedì 22 settembre 2016 09:02:38 UTC+2, Pugazharasan Thirumalai 
ha scritto:
>
> Ya already i tried it ,am getting the same error..
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Error on unmarshalling field

[Oleksandr Gubchenko]

Can you try this query and post the output?

select @raw #33:2073

Do you have JSON data in your record?

Il giorno giovedì 22 settembre 2016 08:48:08 UTC+2, Pugazharasan Thirumalai 
ha scritto:
>
> select from  #33:2073
>
> and response is
>
> com.orientechnologies.orient.core.exception.OSerializationException: 
> Error on unmarshalling field 'install_count' in record #33:2073 with value: 
> install_count:"0"
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Error on unmarshalling field

[Oleksandr Gubchenko]

Can you post your queries and db to reproduce the issue?

Il giorno giovedì 22 settembre 2016 08:35:35 UTC+2, Pugazharasan Thirumalai 
ha scritto:
>
> At that time of create the application, i have use that version in future 
> we are plan to migrate to newer version.
> Now currently am having that error, kindly give solution for recover that 
> error, am waiting for your answer.
>
> On Thursday, September 22, 2016 at 11:59:18 AM UTC+5:30, Oleksandr 
> Gubchenko wrote:
>>
>> Why are you using such an old version?
>> There were some bugs fixed in next versions, see: 
>> https://github.com/orientechnologies/orientdb/issues/2924
>>
>> Are you considering updating to the latest 2.2.x version?
>>
>> Il giorno giovedì 22 settembre 2016 08:23:18 UTC+2, Pugazharasan 
>> Thirumalai ha scritto:
>>>
>>> Version : orientdb-community-1.7.11-20141127.163804-2-distribution
>>>
>>> On Thursday, September 22, 2016 at 11:50:05 AM UTC+5:30, Oleksandr 
>>> Gubchenko wrote:
>>>>
>>>> Hi, which version are you using?
>>>>
>>>> Thank you.
>>>>
>>>> Il giorno giovedì 22 settembre 2016 08:13:50 UTC+2, Pugazharasan 
>>>> Thirumalai ha scritto:
>>>>>
>>>>>
>>>>> Hai, 
>>>>> If i select that particular record #33:2073 or if update  am getting 
>>>>> this error,
>>>>>
>>>>> com.orientechnologies.orient.core.exception.OSerializationException: 
>>>>> Error on unmarshalling field 'install_count' in record #33:2073 with 
>>>>> value: 
>>>>> install_count:"0"
>>>>>
>>>>> Even i can't delete that record also.
>>>>>
>>>>> Thanks and Regards,
>>>>> T.Pugazharasan.
>>>>>
>>>>>
>>>>>
>>>>>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Error on unmarshalling field

[Oleksandr Gubchenko]

Why are you using such an old version?
There were some bugs fixed in next versions, 
see: https://github.com/orientechnologies/orientdb/issues/2924

Are you considering updating to the latest 2.2.x version?

Il giorno giovedì 22 settembre 2016 08:23:18 UTC+2, Pugazharasan Thirumalai 
ha scritto:
>
> Version : orientdb-community-1.7.11-20141127.163804-2-distribution
>
> On Thursday, September 22, 2016 at 11:50:05 AM UTC+5:30, Oleksandr 
> Gubchenko wrote:
>>
>> Hi, which version are you using?
>>
>> Thank you.
>>
>> Il giorno giovedì 22 settembre 2016 08:13:50 UTC+2, Pugazharasan 
>> Thirumalai ha scritto:
>>>
>>>
>>> Hai, 
>>> If i select that particular record #33:2073 or if update  am getting 
>>> this error,
>>>
>>> com.orientechnologies.orient.core.exception.OSerializationException: 
>>> Error on unmarshalling field 'install_count' in record #33:2073 with value: 
>>> install_count:"0"
>>>
>>> Even i can't delete that record also.
>>>
>>> Thanks and Regards,
>>> T.Pugazharasan.
>>>
>>>
>>>
>>>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Error on unmarshalling field

[Oleksandr Gubchenko]

Hi, which version are you using?

Thank you.

Il giorno giovedì 22 settembre 2016 08:13:50 UTC+2, Pugazharasan Thirumalai 
ha scritto:
>
>
> Hai, 
> If i select that particular record #33:2073 or if update  am getting this 
> error,
>
> com.orientechnologies.orient.core.exception.OSerializationException: Error 
> on unmarshalling field 'install_count' in record #33:2073 with value: 
> install_count:"0"
>
> Even i can't delete that record also.
>
> Thanks and Regards,
> T.Pugazharasan.
>
>
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: simple query ist mysterious

[Oleksandr Gubchenko]

I've done some tests and you are right, with you db there is some strange 
behaviour.
But this query seems to work fine:

select * from option where 30 = strike


or:
select * from contract where 30 = strike


<https://lh3.googleusercontent.com/-jYULXDC2WJ0/V9-oyszlSMI/AFc/D8o94otBnbI6ayhZ5cDObSVbflMn_PKCACLcB/s1600/code3.jpg>



Hope it helps.


Il giorno lunedì 19 settembre 2016 10:35:39 UTC+2, hartmut bischoff ha 
scritto:
>
> Thanks for checking.
>
> still mysterious.
>
> I attatched my test-database.
> can you do a test with it, too?
>
>
>
> On Monday, September 19, 2016 at 9:44:30 AM UTC+2, Oleksandr Gubchenko 
> wrote:
>>
>> I've also tried it on 2.2.7 with option being sub-class of contract.
>>
>>
>> <https://lh3.googleusercontent.com/-xy-QJL0_MKY/V9-YUB8KsNI/AE0/lkqfcI60aOIZ5ccDnl9MvcncWBENPtH4ACLcB/s1600/Immagine.png>
>> All works properly.
>>
>>
>>
>> Il giorno lunedì 19 settembre 2016 09:36:02 UTC+2, Oleksandr Gubchenko ha 
>> scritto:
>>>
>>> On 2.2.10 I get this:
>>>
>>>
>>> <https://lh3.googleusercontent.com/-W39YcQO9WbU/V9-VQKpPBnI/AEo/_6LW-iicC-Amt1Ds7luo3uTM0iQeyW3UACLcB/s1600/code2.jpg>
>>>
>>>
>>> Your contract class is a superclass of option?
>>>
>>> Il giorno lunedì 19 settembre 2016 09:26:30 UTC+2, hartmut bischoff ha 
>>> scritto:
>>>>
>>>> I'm using 2.2.7
>>>>
>>>>
>>>> <https://lh3.googleusercontent.com/-0o2KfD6oAro/V9-TDDNcPBI/K44/7FzDgCuAGxkX8sNOBZrxPmiwCxkUiRhaQCLcB/s1600/strike.png>
>>>>
>>>>
>>>>
>>>>
>>>> On Monday, September 19, 2016 at 8:42:38 AM UTC+2, Oleksandr Gubchenko 
>>>> wrote:
>>>>>
>>>>> I've tried it on the latest 2.2.10 and both studio and rest (using 
>>>>> postman) give me the right result:
>>>>>
>>>>> {"result":[{"@type":"d","@rid":"#21:0","@version":1,"@class":
>>>>> "contract","strike":30,"@fieldTypes":"strike=c"}]}
>>>>>
>>>>>
>>>>>>>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: simple query ist mysterious

[Oleksandr Gubchenko]

I've also tried it on 2.2.7 with option being sub-class of contract.
All works properly.

Il giorno lunedì 19 settembre 2016 09:36:02 UTC+2, Oleksandr Gubchenko ha 
scritto:
>
> On 2.2.10 I get this:
>
>
> <https://lh3.googleusercontent.com/-W39YcQO9WbU/V9-VQKpPBnI/AEo/_6LW-iicC-Amt1Ds7luo3uTM0iQeyW3UACLcB/s1600/code2.jpg>
>
>
> Your contract class is a superclass of option?
>
> Il giorno lunedì 19 settembre 2016 09:26:30 UTC+2, hartmut bischoff ha 
> scritto:
>>
>> I'm using 2.2.7
>>
>>
>> <https://lh3.googleusercontent.com/-0o2KfD6oAro/V9-TDDNcPBI/K44/7FzDgCuAGxkX8sNOBZrxPmiwCxkUiRhaQCLcB/s1600/strike.png>
>>
>>
>>
>>
>> On Monday, September 19, 2016 at 8:42:38 AM UTC+2, Oleksandr Gubchenko 
>> wrote:
>>>
>>> I've tried it on the latest 2.2.10 and both studio and rest (using 
>>> postman) give me the right result:
>>>
>>> {"result":[{"@type":"d","@rid":"#21:0","@version":1,"@class":"contract",
>>> "strike":30,"@fieldTypes":"strike=c"}]}
>>>
>>>
>>>>>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: simple query ist mysterious

[Oleksandr Gubchenko]

On 2.2.10 I get this:

<https://lh3.googleusercontent.com/-W39YcQO9WbU/V9-VQKpPBnI/AEo/_6LW-iicC-Amt1Ds7luo3uTM0iQeyW3UACLcB/s1600/code2.jpg>


Your option class is a superclass of contract?

Il giorno lunedì 19 settembre 2016 09:26:30 UTC+2, hartmut bischoff ha 
scritto:
>
> I'm using 2.2.7
>
>
> <https://lh3.googleusercontent.com/-0o2KfD6oAro/V9-TDDNcPBI/K44/7FzDgCuAGxkX8sNOBZrxPmiwCxkUiRhaQCLcB/s1600/strike.png>
>
>
>
>
> On Monday, September 19, 2016 at 8:42:38 AM UTC+2, Oleksandr Gubchenko 
> wrote:
>>
>> I've tried it on the latest 2.2.10 and both studio and rest (using 
>> postman) give me the right result:
>>
>> {"result":[{"@type":"d","@rid":"#21:0","@version":1,"@class":"contract",
>> "strike":30,"@fieldTypes":"strike=c"}]}
>>
>>
>>>>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: simple query ist mysterious

[Oleksandr Gubchenko]

I've tried it on the latest 2.2.10 and both studio and rest (using postman) 
give me the right result:

{"result":[{"@type":"d","@rid":"#21:0","@version":1,"@class":"contract",
"strike":30,"@fieldTypes":"strike=c"}]}

Alex.

Il giorno lunedì 19 settembre 2016 08:35:01 UTC+2, Oleksandr Gubchenko ha 
scritto:
>
> Hi,
>
> which version are you using?
>
> Il giorno lunedì 19 settembre 2016 08:20:41 UTC+2, hartmut bischoff ha 
> scritto:
>>
>> Hi,
>>
>> I was very surprised, that a simple query " select from something where a 
>> = b " could be a subject.
>>
>> but
>> 2.3.1 :001 > DB.execute{ "select from contract where strike = 30" }
>>  => [] 
>> 2.3.1 :002 > DB.execute{ "select from contract where strike between 30 
>> and 30" }
>>  => [#"d", 
>> "class"=>"option", "version"=>1, "fieldTypes"=>"expiry=t,strike=c", 
>> "cluster"=>25, "record"=>25},  @attributes={ (...) "strike"=>30.0, (...) ] 
>> 2.3.1 :003 > 
>>
>>  
>> (rest-api)
>>
>> A verification in studio was successful. 
>>
>> The property "strike" is defined as decimal. 
>>
>> Why is the simple "where strike =  30" or "where strike = 30.0" returning 
>> an empty result,
>> whereas "where strike between 30 and 30" returns the correct record?
>>
>>
>>
>> hartmut
>>
>>
>>
>>
>>
>>
>>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: simple query ist mysterious

[Oleksandr Gubchenko]

Hi,

which version are you using?

Il giorno lunedì 19 settembre 2016 08:20:41 UTC+2, hartmut bischoff ha 
scritto:
>
> Hi,
>
> I was very surprised, that a simple query " select from something where a 
> = b " could be a subject.
>
> but
> 2.3.1 :001 > DB.execute{ "select from contract where strike = 30" }
>  => [] 
> 2.3.1 :002 > DB.execute{ "select from contract where strike between 30 and 
> 30" }
>  => [#"d", 
> "class"=>"option", "version"=>1, "fieldTypes"=>"expiry=t,strike=c", 
> "cluster"=>25, "record"=>25},  @attributes={ (...) "strike"=>30.0, (...) ] 
> 2.3.1 :003 > 
>
>  
> (rest-api)
>
> A verification in studio was successful. 
>
> The property "strike" is defined as decimal. 
>
> Why is the simple "where strike =  30" or "where strike = 30.0" returning 
> an empty result,
> whereas "where strike between 30 and 30" returns the correct record?
>
>
>
> hartmut
>
>
>
>
>
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Required orientdb 2.0.18 jdbc server

[Oleksandr Gubchenko]

Hi, you should use the same version of your OrientDB:


  com.orientechnologies
  orientdb-jdbc
  ORIENTDB_VERSION




To be used inside your project, simply add the dependency to your pom.

See official documentation: http://orientdb.com/docs/last/JDBC-Home.html

Il giorno sabato 17 settembre 2016 10:57:28 UTC+2, jaya raj ha scritto:
>
> Hi,
>
>  I am using orientdb 2.0.18 , which version of the orientdb jdbc 
> driver is suitable, refer the download link of jdbc driver.
>
>
>
> Regards,
> Jayaraj
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Looking for some help to query paths...

[Oleksandr Gubchenko]

Hi, you have find some tips on pattern matching here:

http://orientdb.com/pattern-matching-with-orientdb/

http://orientdb.com/docs/last/SQL-Match.html


Il giorno venerdì 9 settembre 2016 17:53:28 UTC+2, William ha scritto:
>
> Hi Alessandro,
>
> Yeah, I saw that this morning... it solved the problem.  Ivan's solution 
> was this:
>
> SELECT Date, Weight, list(B_ID)[0] as B1_ID, list(B_ID)[1] as B2_ID, 
> list(A_Flag)[0] 
> as A1_Flag, list(A_Flag)[1] as A2_Flag
>
> FROM
> (
> MATCH {class: C, AS: C, WHERE: (Weight>0.9 AND 
> Date.format('-MM')='2014-09')}.out('E2')
> {as: B}.in('E1') {as: A, where: ($matched.C.Date=$currentMatch.Date)}
> RETURN C, C.Date AS Date, C.Weight AS Weight, B.ID, A.Flag
> )
> GROUP BY C
>
>
> I haven't seen the array style notation in my reading so far... Where 
> would I look in the docs to read up on what he was doing with the 
> list(B_ID)[0] 
> pieces of the query?  
>
> Thanks!
>   -William
>
>
> On Friday, September 9, 2016 at 6:34:46 AM UTC-6, alessand...@gmail.com 
> wrote:
>>
>> Hi,
>> have you seen the aswer by Ivan Mainetti at this link 
>> 
>>  ?
>>
>> Best 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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: .net Prepared query throwing error

[Oleksandr Gubchenko]

Can you try with this code snippet? I've tested it, and it works without 
exceptions.

var selectedValue = database
.Select()
.From("Person")
.Where("lastName")
.Equals("Murphy")
.ToList();

Hope it helps.

Il giorno venerdì 9 settembre 2016 15:18:04 UTC+2, Ticket Voodoo ha scritto:
>
> running the query 
> SELECT FROM Person WHERE lastName = 'Murphy'
> in Studio brings back results so I know that the query works as well 
> against the VehicleHistoryGraph example db.
>
> On Friday, September 9, 2016 at 2:13:20 PM UTC+1, Ticket Voodoo wrote:
>>
>> line 106 is the .Query
>>
>> thanks :-)
>> screen shot below
>>
>>
>>
>>
>>
>>
>> On Friday, September 9, 2016 at 2:08:54 PM UTC+1, Oleksandr Gubchenko 
>> wrote:
>>>
>>> You have an ArrayIndexOutOfBoundsException, can you post the line 
>>> numbers of your code?
>>>
>>> Il giorno venerdì 9 settembre 2016 12:53:50 UTC+2, Ticket Voodoo ha 
>>> scritto:
>>>>
>>>> I have the following 2 tests (see code below)
>>>> The first test works fine CanQUeryDBNoParams,
>>>> However, the second test CanQueryDBWithParams
>>>> fails with the following error which I have unsuccessfuly tried to 
>>>> google for help with to no avail, so any help with this would be greatly 
>>>> appreciated.
>>>>
>>>> I am using the latest .net from nuget against the lastest OrientDB 
>>>> running on windows 10, as the first test works I know the code and 
>>>> database 
>>>> works.
>>>>
>>>> error:
>>>> Test Name:CanQueryDBWithParams
>>>> Test FullName:
>>>> UnitTestTVGraphDB.UnitTestTVGraphDB.CanQueryDBWithParams
>>>> Test Source:
>>>> E:\TVMercurialSCM\johnc\Source\TicketVoodooGraphDB\UnitTestTVGraphDB\UnitTestTVGraphDB.cs
>>>>  
>>>> : line 91
>>>> Test Outcome:Failed
>>>> Test Duration:0:00:00.0297952
>>>>
>>>> Result StackTrace:
>>>> at Orient.Client.Protocol.Response.Receive()
>>>>at 
>>>> Orient.Client.Protocol.Connection.ExecuteOperationInternal(IOperation 
>>>> operation)
>>>>at Orient.Client.Protocol.Connection.ExecuteOperation(IOperation 
>>>> operation)
>>>>at Orient.Client.API.Query.PreparedQuery.RunInternal()
>>>>at Orient.Client.API.Query.PreparedQuery.Run(String[] properties)
>>>>at UnitTestTVGraphDB.UnitTestTVGraphDB.CanQueryDBWithParams() in 
>>>> E:\TVMercurialSCM\johnc\Source\TicketVoodooGraphDB\UnitTestTVGraphDB\UnitTestTVGraphDB.cs:line
>>>>  
>>>> 106
>>>> Result Message:
>>>> Test method UnitTestTVGraphDB.UnitTestTVGraphDB.CanQueryDBWithParams 
>>>> threw exception: 
>>>> Orient.Client.OException: 
>>>> com.orientechnologies.orient.core.exception.OSerializationException: Error 
>>>> on unmarshalling content. Class: q
>>>> DB name="VehicleHistoryGraph"
>>>> java.lang.ArrayIndexOutOfBoundsException:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> [TestMethod]
>>>>  public void CanQueryDBNoParams()
>>>> {
>>>>  
>>>> using (GraphDbContext dbContext = new GraphDbContext())
>>>> {
>>>>  
>>>> using (ODatabase database = new 
>>>> ODatabase(GraphDbConnection.DatabaseAlias))
>>>> {
>>>> List result = database
>>>> .Select("firstName").As("firstName")   
>>>>  
>>>> .Also("lastName").As("lastName")
>>>> .Also("fullName").As("fullName")
>>>> .Also("gender").As("gender")
>>>> .Also("birthday").As("birthday")
>>>> .From()
>>>> .OrderBy("lastName").Descending()
>>>> .ToList();
>>>> Assert.IsNotNull(result);
>>>> Assert.IsTrue(result.Count > 0);
>>>> Console.WriteLine(String.Format("result count:{0}", 
>>>> result.Count));
>>>>  
>>>> foreach (var doc in result)
>>>> {
>>>> Console.WriteLine(String.Format("CanQueryDBNoParams 
>>>> doc.OClassName:{0}", doc.OClassName ));
>>>> }
>>>> }
>>>> }
>>>> }
>>>>  
>>>> [TestMethod]
>>>>  public void CanQueryDBWithParams()
>>>> {
>>>>  
>>>> using (GraphDbContext dbContext = new GraphDbContext())
>>>> {
>>>>  
>>>> using (ODatabase database = new 
>>>> ODatabase(GraphDbConnection.DatabaseAlias))
>>>> {
>>>>   
>>>> var query = new PreparedQuery(" SELECT FROM Person WHERE 
>>>> lastName = ? ", "*:0");
>>>>  
>>>> var selectedValue = database
>>>> .Query(query)
>>>> .Run("Murphy")
>>>> .ToList();
>>>>  
>>>> Assert.IsTrue(selectedValue.Count > 0);
>>>>  
>>>> }
>>>> }
>>>> }
>>>>
>>>>
>>>>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: .net Prepared query throwing error

[Oleksandr Gubchenko]

You have an ArrayIndexOutOfBoundsException, can you post the line numbers 
of your code?

Il giorno venerdì 9 settembre 2016 12:53:50 UTC+2, Ticket Voodoo ha scritto:
>
> I have the following 2 tests (see code below)
> The first test works fine CanQUeryDBNoParams,
> However, the second test CanQueryDBWithParams
> fails with the following error which I have unsuccessfuly tried to google 
> for help with to no avail, so any help with this would be greatly 
> appreciated.
>
> I am using the latest .net from nuget against the lastest OrientDB running 
> on windows 10, as the first test works I know the code and database works.
>
> error:
> Test Name:CanQueryDBWithParams
> Test FullName:UnitTestTVGraphDB.UnitTestTVGraphDB.CanQueryDBWithParams
> Test Source:
> E:\TVMercurialSCM\johnc\Source\TicketVoodooGraphDB\UnitTestTVGraphDB\UnitTestTVGraphDB.cs
>  
> : line 91
> Test Outcome:Failed
> Test Duration:0:00:00.0297952
>
> Result StackTrace:
> at Orient.Client.Protocol.Response.Receive()
>at 
> Orient.Client.Protocol.Connection.ExecuteOperationInternal(IOperation 
> operation)
>at Orient.Client.Protocol.Connection.ExecuteOperation(IOperation 
> operation)
>at Orient.Client.API.Query.PreparedQuery.RunInternal()
>at Orient.Client.API.Query.PreparedQuery.Run(String[] properties)
>at UnitTestTVGraphDB.UnitTestTVGraphDB.CanQueryDBWithParams() in 
> E:\TVMercurialSCM\johnc\Source\TicketVoodooGraphDB\UnitTestTVGraphDB\UnitTestTVGraphDB.cs:line
>  
> 106
> Result Message:
> Test method UnitTestTVGraphDB.UnitTestTVGraphDB.CanQueryDBWithParams threw 
> exception: 
> Orient.Client.OException: 
> com.orientechnologies.orient.core.exception.OSerializationException: Error 
> on unmarshalling content. Class: q
> DB name="VehicleHistoryGraph"
> java.lang.ArrayIndexOutOfBoundsException:
>
>
>
>
>
> [TestMethod]
>  public void CanQueryDBNoParams()
> {
>  
> using (GraphDbContext dbContext = new GraphDbContext())
> {
>  
> using (ODatabase database = new 
> ODatabase(GraphDbConnection.DatabaseAlias))
> {
> List result = database
> .Select("firstName").As("firstName")
> .Also("lastName").As("lastName")
> .Also("fullName").As("fullName")
> .Also("gender").As("gender")
> .Also("birthday").As("birthday")
> .From()
> .OrderBy("lastName").Descending()
> .ToList();
> Assert.IsNotNull(result);
> Assert.IsTrue(result.Count > 0);
> Console.WriteLine(String.Format("result count:{0}", 
> result.Count));
>  
> foreach (var doc in result)
> {
> Console.WriteLine(String.Format("CanQueryDBNoParams 
> doc.OClassName:{0}", doc.OClassName ));
> }
> }
> }
> }
>  
> [TestMethod]
>  public void CanQueryDBWithParams()
> {
>  
> using (GraphDbContext dbContext = new GraphDbContext())
> {
>  
> using (ODatabase database = new 
> ODatabase(GraphDbConnection.DatabaseAlias))
> {
>   
> var query = new PreparedQuery(" SELECT FROM Person WHERE lastName 
> = ? ", "*:0");
>  
> var selectedValue = database
> .Query(query)
> .Run("Murphy")
> .ToList();
>  
> Assert.IsTrue(selectedValue.Count > 0);
>  
> }
> }
> }
>
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: OreintDB on Android

[Oleksandr Gubchenko]

Hi,

have you checked out http://wuman.github.io/orientdb-android/ ?

Il giorno sabato 3 settembre 2016 23:59:05 UTC+2, Tony Sterrett ha scritto:
>
> Hello:
>
> I'm interested in provided a front-end to an OrientDB on Android. I've 
> done this before using the HTTP REST interface. This time I prefer to use 
> the 
> native Java (remote) interface. I am aware of the wu-man port but that's 
> OrientDB 1.x is there a more modern port available.  Anybody accepting 
> volunteers to write one.?
>
> Thanks in Advance, 
> Tony
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: How to check the vertex doesn't have specific edge

[Oleksandr Gubchenko]

Hi,

I've created a little test schema:




And used this query to find all products that was viewd but not ordered:


select from product where in("viewed").size() > 0 and in("ordered").size() = 
0


Hope it helps,

Alex.





Il giorno venerdì 2 settembre 2016 23:25:56 UTC+2, Tan Ho ha scritto:
>
> Hi all,
>
> Maybe this is a simple question for you but I was not able to find any 
> answer.
>
> I have some vertices of class 'product' which can be 'viewed', 'ordered' 
> by 'user'.
> My problem is that I want to get all product where 'viewed' by specific 
> user, and it's has not been 'ordered' by any user.
>
> Eg:  ProductA <-viewed- User1
>ProductB <-viewed- User1
>ProductC <-viewed- User1
>ProductC <-ordered- User1
>ProductD <-viewed- User1
>ProductD <-viewed- User2
>ProductD <-ordered- User2
>
> Input: User1
> Expected result:ProductA, ProductB
> Note: ProductC and ProductD don't exist in result set because they were 
> 'ordered' by User1, User2.
>
> I want to get it by using SQL or Match command.
>
> Thanks,
> Tan
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Best query to get all related vertices through an Edge?

[Oleksandr Gubchenko]

You need to specify each property name after the edge name: 
OUT('HasComments')).property1, OUT('HasComments')).property2
etc

Il giorno martedì 30 agosto 2016 04:57:47 UTC+2, Quốc Nam Lê ha scritto:
>
> I have another question.
> I want to see all properties of Comment vertex, and Record ID of Post 
> vertex in query result.
> So, I try to run select statement:
>
> SELECT EXPAND(OUT('HasComments')), @rid as post_id FROM #10:1
>
> But this statememt is wrong.
> Please tell me how to do this.
>
>
> On Tuesday, August 16, 2016 at 11:32:22 AM UTC+7, Quốc Nam Lê wrote:
>>
>> In my case, I have 2 vertices and 1 edge follow:
>> Post (#10:1) > HasComments -> Comment (#11:1, #11:2, ...)
>>  (V)   out  (E)  (in)   (V)
>>
>> So, What is the best query (speed, performance) to get all Comments from 
>> a Post through HasComments?
>> Here is my query:
>>
>> SELECT EXPAND(OUT('HasComments')) FROM #10:1
>>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: How Many Masters Required for OrientDB

[Oleksandr Gubchenko]

What do you mean saying all node details?
Distribuited configuration examples can be found here 
<http://orientdb.com/docs/last/Distributed-Configuration.html>.
If you are worried about security issues, some server security tips can be 
found on this page <http://orientdb.com/docs/last/Server-Security.html> of 
documentation.

Alex.

Il giorno mercoledì 10 agosto 2016 20:35:25 UTC+2, Shaik M ha scritto:
>
> Thank you, Alex.
>
> when we configure in Distributed setup, do we need to pass all OrientDB 
> master node details at application end ?
>
> how the configuration we need to be taken care?
>
> Thanks,
> Shaik
>
> On Wednesday, 10 August 2016 03:37:31 UTC+8, Oleksandr Gubchenko wrote:
>>
>> Hi,
>>
>> it really depends on your needs, DB size, usage, number of users and load.
>>
>> You can find some information in official documentation:
>>
>>- Replication <http://orientdb.com/docs/last/Replication.html>
>>- Distributed Architecture 
>><http://orientdb.com/docs/last/Distributed-Architecture.html>
>>
>> Alex.
>>
>> Il giorno martedì 9 agosto 2016 21:15:30 UTC+2, Shaik M ha scritto:
>>>
>>> Hi,
>>>
>>> I am new to OrientDB. we are planning to use in our coming project. 
>>>
>>> I saw in documentation there is no Master/Salve concept for OrientDB. In 
>>> this case what is best practice, with how many nodes can we go 
>>> Master-Master architecture and to use multi masters at application end?
>>>
>>> Please help us to understand.
>>>
>>> Thanks,
>>> Shaik
>>>
>>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: How Many Masters Required for OrientDB

[Oleksandr Gubchenko]

Hi,

it really depends on your needs, DB size, usage, number of users and load.

You can find some information in official documentation:

   - Replication 
   - Distributed Architecture 
   
   
Alex.

Il giorno martedì 9 agosto 2016 21:15:30 UTC+2, Shaik M ha scritto:
>
> Hi,
>
> I am new to OrientDB. we are planning to use in our coming project. 
>
> I saw in documentation there is no Master/Salve concept for OrientDB. In 
> this case what is best practice, with how many nodes can we go 
> Master-Master architecture and to use multi masters at application end?
>
> Please help us to understand.
>
> Thanks,
> Shaik
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: File is locked by another proce

[Oleksandr Gubchenko]

You have some process that is running and holding the lock to the database.
Check the procceses running. You can try to restart OrientDB and/or reboot 
your machine.
See this issue for more 
details: https://github.com/orientechnologies/orientdb/issues/5827

Thanks.

Il giorno mercoledì 6 luglio 2016 19:37:19 UTC+2, Pugazharasan Thirumalai 
ha scritto:
>
> I can't access the database, version 2.0.18
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: File is locked by another proce

[Oleksandr Gubchenko]

Which operations are you executing?
Can you give us more details, like all steps you are doing to help us 
investigate on the problem, whole server log, OrientDB version.

Thank you.

Il giorno mercoledì 6 luglio 2016 19:15:13 UTC+2, Pugazharasan Thirumalai 
ha scritto:
>
>
> com.orientechnologies.common.concur.lock.OLockException: File 
> '/home/gms/orientdb/orientdb-community-2.0.18/databases/ces/internal.cpm' 
> is locked by another process, maybe the database is in use by another 
> process. Use the remote mode with a OrientDB server to allow multiple 
> access to the same database.
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Disk quota exceeded

[Oleksandr Gubchenko]

Hi, I have tried with the same version and I'm not getting any error.

The problem seems to be with your database. In OrientDB when you delete a 
record the disk space remains allocated.
As a workaround you can export your DB, delete the database directory, and 
then import it again.

Can you try it and let me know if it works?
Also consider and update to the latest available version: 2.2.3 by now.
Thank you.

Il giorno mercoledì 6 luglio 2016 15:35:56 UTC+2, Pugazharasan Thirumalai 
ha scritto:
>
> Version : orientdb-community-2.0.18
> Am getting this problem when i start the server
> Am having large amount of space
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Disk quota exceeded

[Oleksandr Gubchenko]

Which version of OrientDB are you using? Are you getting this error during 
the server startup o during some operations?
Do you have free space available on your hard disk?

Thank you.

Il giorno mercoledì 6 luglio 2016 15:28:33 UTC+2, Pugazharasan Thirumalai 
ha scritto:
>
>  Please check it
>
>> OrientDB auto-config DISKCACHE=0MB (heap=455MB os=4,096MB disk=0MB) 
>> [orientechnologies]java.util.logging.ErrorManager: 2
>> java.io.IOException: Disk quota exceeded
>> at java.io.FileOutputStream.writeBytes(Native Method)
>> at java.io.FileOutputStream.write(FileOutputStream.java:282)
>> at 
>> java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
>> at 
>> java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
>> at 
>> java.util.logging.FileHandler$MeteredStream.flush(FileHandler.java:141)
>> at sun.nio.cs.StreamEncoder.implFlush(StreamEncoder.java:278)
>> at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:122)
>> at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:212)
>> at java.util.logging.StreamHandler.flush(StreamHandler.java:223)
>> at java.util.logging.FileHandler.publish(FileHandler.java:554)
>> at java.util.logging.Logger.log(Logger.java:509)
>> at java.util.logging.Logger.doLog(Logger.java:531)
>> at java.util.logging.Logger.log(Logger.java:554)
>> at 
>> com.orientechnologies.common.log.OLogManager.log(OLogManager.java:118)
>> at com.orientechnologies.common.log.OLogManager.info
>> (OLogManager.java:154)
>> at 
>> com.orientechnologies.orient.core.config.OGlobalConfiguration.autoConfigDiskCacheSize(OGlobalConfiguration.java:684)
>> at 
>> com.orientechnologies.orient.core.config.OGlobalConfiguration.autoConfig(OGlobalConfiguration.java:652)
>> at 
>> com.orientechnologies.orient.core.config.OGlobalConfiguration.(OGlobalConfiguration.java:566)
>> at 
>> com.orientechnologies.common.profiler.OProfiler.(OProfiler.java:36)
>> at 
>> com.orientechnologies.orient.core.Orient.startup(Orient.java:194)
>> at 
>> com.orientechnologies.orient.core.Orient.(Orient.java:82)
>> at 
>> com.orientechnologies.orient.server.OServer.(OServer.java:119)
>> at 
>> com.orientechnologies.orient.server.OServer.(OServer.java:102)
>> at 
>> com.orientechnologies.orient.server.OServerMain.create(OServerMain.java:26)
>> at 
>> com.orientechnologies.orient.server.OServerMain.main(OServerMain.java:40)
>>
>>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Disk quota exceeded

[Oleksandr Gubchenko]

Hi, can you give us as much information as possible? I.e.: operations that 
you are executing, server logs, ecc

Thank you.

Il giorno mercoledì 6 luglio 2016 15:16:54 UTC+2, Pugazharasan Thirumalai 
ha scritto:
>
> Am getting error as "disk quota exceeded". Kindly give solution as soon as 
> possible.
>
> Thanks and Regards,
> T.Pugazharasan.
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: GeoJson

[Oleksandr Gubchenko]

Hi,

it should work like an import from a normal JSON.
Take a look at official documentation here 
.

Il giorno giovedì 30 giugno 2016 16:51:16 UTC+2, Paolo Bolla ha scritto:
>
> Hello, has anyone ever imported a GeoJson file with ETL? 
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Error on import the automatic backup file(Compressed) into the orientdb, How to import properly?

[Oleksandr Gubchenko]

You should connect to your database in plocal, please refer to the 
documentation that I have linked above.

Il giorno lunedì 27 giugno 2016 09:08:42 UTC+2, Pugazharasan Thirumalai ha 
scritto:
>
> *If i use Restore query, am getting error like this.,*
>
> *Connecting to database [REMOTE:localhost/crmjune] with user 'gms'...OK*
> *orientdb {db=crmjune}> RESTORE DATABASE D:\crm.zip*
>
> *Restoring database DATABASE D:\crm.zip...*
> *Error: java.lang.UnsupportedOperationException: restore*
>
> *orientdb {db=crmjune}>*
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Error on import the automatic backup file(Compressed) into the orientdb, How to import properly?

[Oleksandr Gubchenko]

Could you try restore command instead of import?
RESTORE DATABASE D:\crm.zip

http://orientdb.com/docs/last/Backup-and-Restore.html#restoring-databases

Also try with the latest OrientDB version (2.2.3):
http://orientdb.com/download/

Hope it helps.
Alex.

Il giorno lunedì 27 giugno 2016 08:49:52 UTC+2, Pugazharasan Thirumalai ha 
scritto:
>
>
> Am using Version : orientdb-community-1.7.11-20141127.163804-2-distribution
>
> Thanks and Regards,
> T.Pugazharasan
>
>
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Error on import the automatic backup file(Compressed) into the orientdb, How to import properly?

[Oleksandr Gubchenko]

Can you try the latest version (2.2.3):
http://orientdb.com/download/

Let me know.
Alex.

Il giorno lunedì 27 giugno 2016 08:49:52 UTC+2, Pugazharasan Thirumalai ha 
scritto:
>
>
> Am using Version : orientdb-community-1.7.11-20141127.163804-2-distribution
>
> Thanks and Regards,
> T.Pugazharasan
>
>
>
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Error on import the automatic backup file(Compressed) into the orientdb, How to import properly?

[Oleksandr Gubchenko]

Which version of OrientDB are you using?

Il giorno lunedì 27 giugno 2016 08:40:39 UTC+2, Pugazharasan Thirumalai ha 
scritto:
>
> If manually i did manually export the backup file and i import it , the 
> import has been done successfully.
>
> Am getting this problem only when automatic backup file only.
>
> Thanks and Regards,
> T.Pugazharsan
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Error on import the automatic backup file(Compressed) into the orientdb, How to import properly?

[Oleksandr Gubchenko]

You have NumberFormatException.
There is some problems with data stored in your DB, you should check it:
https://docs.oracle.com/javase/8/docs/api/java/lang/NumberFormatException.html

Il giorno lunedì 27 giugno 2016 08:22:03 UTC+2, Pugazharasan Thirumalai ha 
scritto:
>
> As per your suggestion i tried to get the backup file has .zip extension 
> by changes the config.xml  and get the backup file as zip extension. 
> Then I tried to import it and am getting the error.
> Now i have attached the backup file in zip extension and the screenshot of 
> the error. Can you please give the solution for that.
>
> And am requesting you to give, your zip file and its import query.
>
> Thanks and Regards,
> T.Pugazharasan.
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Error on import the automatic backup file(Compressed) into the orientdb, How to import properly?

[Oleksandr Gubchenko]

Why is your backup file has .json extension?
It should be .zip

I have tried changing it and it works. To import it properly see the 
documentation .

Hope it helps,
Alex.

Il giorno sabato 25 giugno 2016 07:29:30 UTC+2, Pugazharasan Thirumalai ha 
scritto:
>
> I have attached the json file, kindly give solution as soon as possible...
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.

[orientdb] Re: Error on import the automatic backup file(Compressed) into the orientdb, How to import properly?

[Oleksandr Gubchenko]

Hi, can you post your json file or try an import on fresh OrientDB version 
(2.2.3)?

Thanks.

Il giorno giovedì 23 giugno 2016 14:38:11 UTC+2, Pugazharasan Thirumalai ha 
scritto:
>
> I have get the export json file from automatic backup from 
> orientdb-community-1.7.11-SNAPSHOT, below i have mentioned the settings file
>
> 
> 
> 
> 
>  name="target.fileName"/>
> 
> 
> 
> 
> 
>
> The json file content is compressed, when i import the file it shows the 
> error, the error  message i have got screen shot and attached. Kindly give 
> solution to import the compressed json file into orientdb.
>

-- 

--- 
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 options, visit https://groups.google.com/d/optout.