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
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.
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?
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
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
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;
"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\""
}
]
}
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"
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 !
Hello, I'm having a problem with upgrading orientDB from 3.1.7 to 3.1.9 in a distributed configuration.
What I'm trying to do:
- Stop orientdb
- Delete old orientdb files except for orientdb-server-config.xml, databases and backups (that are being kept in separate folders)
- Unpack new orientdb, add encryption key, correct backup setting, change permissions
- Start OrientDB
But after starting the database, I'm receiving the following error:
Mar 01 16:15:09 xxx server.sh[75199]: 2021-03-01 16:15:09:251 INFO [node1611150122103] Reassignment of clusters for database 'databasename' completed (classes=25) [OHazelcastPlugin][node1611150122103] Error on starting distributed plugin
Mar 01 16:15:09 xxx server.sh[75199]: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer
Mar 01 16:15:09 xxx server.sh[75199]: at com.orientechnologies.orient.server.distributed.ODistributedMomentum.getLSN(ODistributedMomentum.java:59)
Mar 01 16:15:09 xxx server.sh[75199]: at com.orientechnologies.orient.server.distributed.ODistributedSyncConfiguration.load(ODistributedSyncConfiguration.java:101)
Mar 01 16:15:09 xxx server.sh[75199]: at com.orientechnologies.orient.server.distributed.ODistributedSyncConfiguration.<init>(ODistributedSyncConfiguration.java:61)
Mar 01 16:15:09 xxx server.sh[75199]: at com.orientechnologies.orient.server.distributed.impl.ODistributedDatabaseImpl.getSyncConfiguration(ODistributedDatabaseImpl.java:867)
Mar 01 16:15:09 xxx server.sh[75199]: at com.orientechnologies.orient.server.hazelcast.OHazelcastPlugin$4.call(OHazelcastPlugin.java:898)
Mar 01 16:15:09 xxx server.sh[75199]: at com.orientechnologies.orient.server.hazelcast.OHazelcastPlugin$4.call(OHazelcastPlugin.java:875)
Mar 01 16:15:09 xxx server.sh[75199]: at com.orientechnologies.orient.server.distributed.impl.ODistributedAbstractPlugin.executeInDistributedDatabaseLock(ODistributedAbstractPlugin.java:1963)
Mar 01 16:15:09 xxx server.sh[75199]: at com.orientechnologies.orient.server.hazelcast.OHazelcastPlugin.loadLocalDatabases(OHazelcastPlugin.java:871)
Mar 01 16:15:09 xxx server.sh[75199]: at com.orientechnologies.orient.server.hazelcast.OHazelcastPlugin.startup(OHazelcastPlugin.java:317)
Mar 01 16:15:09 xxx server.sh[75199]: at com.orientechnologies.orient.server.OServer.registerPlugins(OServer.java:1258)
Mar 01 16:15:09 xxx server.sh[75199]: at com.orientechnologies.orient.server.OServer.activate(OServer.java:500)
Mar 01 16:15:09 xxx server.sh[75199]: at com.orientechnologies.orient.server.OServerMain$1.run(OServerMain.java:49)
Mar 01 16:15:09 xxx server.sh[75199]: 2021-03-01 16:15:09:256 INFO OrientDB Server is shutting down... [OServer]
Mar 01 16:15:09 xxx server.sh[75199]: 2021-03-01 16:15:09:256 INFO Shutting down listeners: [OServer]Does anyone know what can be the issue here?
Without these files I'm unable to connect to the database to do a repair.
There is a way to remove these file from the database metadata? Or recreate it empty? Or ignore on database connection?
I'm using 3.0.37
OrienrDB V 2.2.0
This is working-> select from #22:0;
But not this -> select from Classname;
Does anybody have any idea?
Error: com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error parsing query:
select from vertex
^
Encountered " <FROM> "from "" at line 1, column 8.
Was expecting one of:
<NULL> ...
"true" ...
"false" ...
"{" ...
<NULL> ...
"{" ...
"true" ...
"false" ...
Can anyone clarify what the future for manual indexes is, as the current state of code/docs is a bit confusing...
We've got an automatic index that we're querying directly , e.g. using SELECT COUNT(*) AS size FROM INDEX: syntax.
This triggers the "Manual indexes are deprecated and will be removed" warning, but this is for an automatic index.
The docs at http://orientdb.com/docs/3.1.x/indexing/Indexes.html are silent on deprecation of any of the direct index queries.
Is the intention that direct query of indexes is also deprecated and will be removed, or just the manual management of indexes?
