orientechnologies/orientdb

OrientDB document graph NoSQL dbms

Paul Kendall

@pkendall64

Hi, I've written an app that uses orientdb 3.0.30 and uses a live query with the java API. When I have the live query running and notifications are sent to my app it all works.
However when my app creates a new vertex and edge to an already existing vertex that already has edges to other vertices I get a nasty exception in the OLiveQueryHookV2 class even though the class that I am performing the live query on is not part of the update. I have re-produced the exception in a unit test that can be added to OrientDBRemoteTest.java and have create a ticket orientechnologies/orientdb#9200 for the problem.
Has anyone else seen this behaviour? Is there anything I can do to workaround the problem until the bug (if in fact it is one) is fixed? Thanks.

JoggerJoel

@joggerjoel

Hi, I have a clean system and did a git clone the latest and there's no bin directory.

git clone https://github.com/orientechnologies/orientdb.git

commit a14994471faa5a8d9321b6f0013ae75e8d77fa91 (HEAD -> develop, origin/develop, origin/HEAD)
Author: Tglman tglman@tglman.com
Date: Wed Apr 8 14:10:19 2020 +0100

Has this location changed? Thanks

JoggerJoel

@joggerjoel

sh server.sh

server.sh: line 50: cd: /Users/username/Documents/Projects/orientdb/server/bin: No such file or directory
server.sh: line 114: /Users/username/Documents/Projects/orientdb/server/bin/orient.pid: No such file or directory
Error: Could not find or load main class com.orientechnologies.orient.server.OServerMain

JoggerJoel

@joggerjoel

I looked and orientdb-3.0.27 have /bin directory

This only exists in https://orientdb.com/download-previous, not github.

stoica-florian

@stoica-florian

Hi, is there a way to have a live Query over all the records in default cluster? doing .live("select FROM CLUSTER:default ", liveQueryListener does not seem to be enough

Mauro Mariuzzo

@mmariuzzo

Hi, is anyone using OrientDB on Kubernets on Google Cloud Platform? There are some problems or hints?

Ankesh Kapil

@ankeshKapil

Is there any way to cast result from query to java object without using object api?

madiganz

@madiganz

I am running the 3.0.30-tp3 docker imagine for OrientDB that contains a Gremlin server. I am using Gremlin.Net to connect to OrientDB through the Gremlin Server. When I try to run queries using a graph traversal I get the following error: Deserializer for "orient:ORecordId" not found. Does anyone know the cause of this?

ohbutgtol

@ohbutgtol

Hi. I stumbled upon the simple question in my first steps: what so-called "Generic Classes" need for? I have not found a clear answer in the documentation, stackoverflow, and google group (I am sorry if it just by my inadvertence). So can somebody enlighten this for me?

Mauro Mariuzzo

@mmariuzzo

@ankeshKapil supposing your query return a Document mappable to a POJO my approach is to add to the pojo class a static method named "of (Document doc)" where I create a new instance of the java class an manually set all fields values with document values. Then you could use java stream capability to map your result

OResultSet result = session.command("SELECT * FROM abc");
result.stream().map(MyPojo::of);

Enrico Risa

@wolf4ood

Hi @ohbutgtol Generic classes are just classes that does not derive from V or E, usually when you don't want graph capabilities on a particular class

Enrico Risa

@wolf4ood

Hi @madiganz the cause is that the id of OrientDB is a composition of 2 values composing the ORecordId, which is serialized in a custom way.

Could you try this solution if it helps?

https://discourse.orientdb.org/t/deserializer-for-orient-orecordid-not-found/126/15

Thanks

madiganz

@madiganz

@wolf4ood I can confirm that it got rid of the error, thanks!

Isaac Levi Tzab Poot

@isaactzab

Hello, I am looking for a way to make a gremlin query in orient to make math operations, but in some forums said that no have support for it. Is there a way to achieved?

madiganz

@madiganz

Not sure if this is the correct place for this, but does anyone know of a clean way to cast the response from a Gremlin query using Gremlin.Net to a class? I am currently needed to use ValueMap<object, object[]>() and the iterate through a Dictionary to create my class objects.

prog20901

@prog20901

Suggestion of 10 (TEN) crucial items for developing web application 2020

Could someone suggest the best tool/framework for small or medium size or enterprise web application for 2020 - 10 to 1000 users and millions of records

#1 - Best Unit test case framework

#2 - Best NoSQL Database

#3 - Best Relation Database

#4 - Best Synchronous Framework

#5 - Best Asychronous Framework

#6 - Best Front-End Framework (Active Development, Max Support)

#7 - Best Debugging Tool

#8 - Best Performance Tuning Tool

#9 - Best Code Coverage Tool

#10 - Best DB migration tool (ex: flyway)

Thanks.

Dee Nguyen

@DienNM

Hi Everyone, I am a newer to OrientDB. I am creating a graph for tracking online activities using OrientDB. Is it possible to create a Vertex with millions of Edges? In my case, I create a Vertex called UTMSource (i.e Organic Source), from Online User, I create Edges to these UTMSource Vertices with time. I suppose to have millions of edges. I read some articles and I realize this is a super node, and I should avoid. Does anyone has the same problems?

omiadgaonkar

@omiadgaonkar

Hi, how do we get with previous or next row data in Select query. Something like LEAD()/LAG() functions in sql server

madiganz

@madiganz

Is there a way to tell orientdb that there is going to be a massive insert, such as https://orientdb.com/docs/last/Performance-Tuning.html#use-the-massive-insert-intent, from a gremlin query? Or does it explicitly need to be done though OrientDB API? The problem I am having is I say I have three vertices: V1, V2, and V3. I want to create an edge from V2 -> V3. The problem I am having is when I have not much data, I can create many of these edges very fast. After I insert 800k V1s, creating edges between V2 and V3 is now MUCH slower.

Philipp Kraus

@flashpixx

Hello, I'm just starting with OrientDB and I try to build my first graph database:

create class User extends V;
create property User.mail String;

and on this call I get an parsing error. If I run the statements manually sequentially everything works fine, but I would like to create a SQL File, which generates the whole database structure in my Docker container. How can I run multiple statements? And can I build the database on the Docker build?

Philipp Kraus

@flashpixx

Hello, I Try to build a docker container, which generates on building a database and import the schema with some example datasets, I just trie to run

RUN console.sh "create database plocal:/orientdb/databases/orientdb"
RUN console.sh "connect plocal:/orientdb/databases/orientdb root; load script /sqlscripts/all.sql"

But the first command does not create the database and the second one will fail. If I run it manually it will work

madiganz

@madiganz

@flashpixx I have never tried this myself, but I believe that you need to run console.sh from /orientdb/bin/.

prog20901

@prog20901

hi
I have pasted the code in

<https://pastebin.com/z8q5cavm>

I will be having huge list of rows in the datatable and each row will have a specific href or mp3 file link. However the code always opens the serm.mp3 eventhough whatever i pass in the link.

Can someone help me on how to fix this javascript?

Basically want to change the src of the mp3 file when the media player open on clicking the href link in the datatable

PVJ Pavan Kumar

@pvjpavankumar

Hi, I am trying to execute unionall query in server-side function

var db = orient.getDatabase();
var queryStmt = "select expand($d) ";
queryStmt = queryStmt + "\n" + "let $a = (SELECT content_id, description as Description, user_id, 'description' as search_type from Content WHERE SEARCH_FIELDS(['description'],'description:'"+keywords+"'') = true), $b = (SELECT content_id, user_tags as Topic, user_id, 'topic' as search_type from Content WHERE SEARCH_FIELDS(['user_tags'],'user_tags:'"+keywords+"'') = true), $c = (SELECT user_id, username, full_name, in('userFollow').size() as followers, out('userContent').size() as videos, 'hashtags' as search_type from User WHERE SEARCH_CLASS('"+keywords+"'*') = true), $d = unionAll($a,$b,$c)"

var result = db.command('sql',queryStmt);
return result;

But I am getting the below error

{
"errors": [
{
"reason": 400,
"code": 400,
"content": "Error parsing query:\nsql\n ^\nEncountered \" <IDENTIFIER> \"sql \"\" at line 1, column 1.\nWas expecting one of:\n <LET> ...\n <EXPLAIN> ...\n \r\n\tDB name=\"talkiez\"\r\n\tError Code=\"1\""
}
]
}

not sure what is wrong in the above function

can someone help me ?

VikramShityalkar

@VikramShityalkar

try following statement, or you can print the statement in logs and check OrientDB server console log.
var result = db.command(queryStmt);

PVJ Pavan Kumar

@pvjpavankumar

thanks Vikram, it didnt work

Willians Vivanco

@williansvi

Hi, i'm having this error...
com.orientechnologies.orient.core.exception.OSecurityAccessException: User 'app-api-recommendations' does not have permission to execute the operation 'Update' against the resource: ResourceGeneric [name=CLUSTER, legacyName=database.cluster].internal DB name="api-recommendations"

Any suggestion about which permission should i activate ?

PVJ Pavan Kumar

@pvjpavankumar

I guess write permissions for the user "app-api-recommendations"

Naseem Mahasneh

@naseem91

Hi
I have a problem while committing edges in OrientDB version (3.1.2)?? Any help

com.orientechnologies.orient.core.exception.OStorageException: Exception during execution of component operation inside component collections_22.sbc in storage DemoDB

msbomrel2020

@msbomrel2020

Hi All, When I run and stop the scala application as service. I got this error:
"Not more resources available in pool. Requested resource
P.S: I am using orientdb 1.6.6

Paul Agron

@nimzi

Ping

Hi Everyone, investigating the product on a mac but getting "Cannot find default script language for javascript" warning

Javascript is unavailable as an option in the studio

dang3rdud3

@dang3rdud3

Hi all, is there any way in the Java API to monitor the number of

all connections
all available (i.e. free) connections
all currently used connections

stoica-florian

@stoica-florian

Hi all, did anyone else encounter this issue before ? orientechnologies/orientdb#9431

edmonfrank

@EdmondFrank

hi all , when i try to use command "repair database --fix-links" to fix a database error, i got some some java.lang.NullPointerException. does anyone ever met the same problem?

emmanuel-ma

@emmanuel-ma

Hi all, I am trying to upgrade the OrientGo driver so that it supports OrientDB 3.0. Currently, it supports OrientDB 2.1 but I already implemented the support for OrientDB 2.2 and the next step is to implement the support for OrientDB 3.0 version. However, I did not find the documentation related with the binary protocol version 37 (It is used in OrientDB-3.0) in the official documentation (http://orientdb.com/docs/3.1.x/internals/Network-Binary-Protocol.html). Does someone know where I can find that documentation? I only have found in the Java and NodeJS drivers that there have been many changes in the network binary protocol from the Protocol version 37 but I think all is implemented in the code and there is not documentation. Some hints?

3ezdin-debug

@3ezdin-debug

Hi! I'm looking for the documentation of the access token in orient db to use it in application user authetication but can't find it.

Can anyone put the token documentation link please.

Thanks

Ps: rest api usage not binary

3ezdin-debug

@3ezdin-debug

Could not find the documentation on how to set up the /token/<db> but I did activated it by using the configuration 'network.http.useToken' set to 'true' in the bin/server.sh startup file by adding the argument -Dnetwork.http.useToken="true"
now I can authenticate using the /token/<db> endpoint and I receive access token.
I want to use orientdb to authenticate application users and by validating their token afterward in the application. (You think this is possible? scaling problems maybe one day?)
meanwhile to retrieve data from db I will make a technical user that will use the normal basic authentification OsessionId.
any thoughts? Thanks !

Where communities thrive

People

Repo info

Activity