Stream

Join this community to post or comment

Ricardo Memoria

Discussione  - 
 
Hi Community... I'm new to orientDB. Quick question -> I'll start a new nodeJS project. Does the 'oriento' lib cover all the OrientoDB API? Any recommended book? I didn't find much information about that. 
1
Nicolas Embleton's profile photoRicardo Memoria's profile photo
7 comments
 
+Luca Garulli  Congratulations for the great product. It seems OrientDB will fill the gaps I found in other noSQL DBs. Probably you guys should invest a little bit more in disclosure and advertisement. I've searched about noSQL databases around 1 to 2 years ago and I'm  impressed I've not heard about OrientDB. Probably now because I'm focusing on the specific isues, like transactions and joins, I finally found it. I've heard a lot of people that are migrating from RDBMS to noSQL complaining about these limitations in other products like MongoDB.
Add a comment...

Alan Frye

Discussione  - 
 
I am new to orientdb and looking to use on a project. I am using the Java api and was wondering the best way to insert multiple documents with one command. I have a queue of records that I need to save to database.
1
Alan Frye's profile photoLuca Garulli's profile photo
5 comments
Add a comment...

Fede Ramirez

Discussione  - 
OrientDB is an Open Source NoSQL DBMS with the features of both Document and Graph DBMSs. It's written in Java. Supports schema-less, schema-full and schema-mixed modes. OrientDB adheres to the NoSQL movement even though it supports a subset of SQL as query language.
3
Nicolas Embleton's profile photo
 
Oh... Nice... Didn't know Bitnami had an OrientDB stack. Will check if they ported it to Google Cloud too.
Add a comment...

Jett Gamboa

Discussione  - 
 
Is there an example somewhere of using OrientDB as an embedded server from within a Spring application? Thank you. 
1
camilo casadiego's profile photo
 
Hi there, you can mix some concepts from this page http://www.programmazione.it/index.php?entity=eitem&idItem=47585 (as hjow to stratup your connection pool), then you can have the datasource like this..

@Configuration
public class GraphDatabaseConfiguration implements EnvironmentAware{

private final Logger log = LoggerFactory.getLogger(GraphDatabaseConfiguration.class);

    private RelaxedPropertyResolver propertyResolver;

    private Environment env;
    
   @Override
    public void setEnvironment(Environment env) {
        this.env = env;
        this.propertyResolver = new RelaxedPropertyResolver(env, "spring.orientDb.");
    }
    
   @Bean(name="graphFactory")
    public OrientGraphFactory factoryProducer() {
        log.debug("Configuring Orient Datasource");
        if (propertyResolver.getProperty("url") == null || propertyResolver.getProperty("username") == null 
        || propertyResolver.getProperty("password") == null) {
            log.error("Your Orient database connection pool configuration is incorrect! The application" +
                    "cannot start. Please check your Spring profile, current profiles are: {}",
                    Arrays.toString(env.getActiveProfiles()));

            throw new ApplicationContextException("OrientDatabase connection pool is not configured correctly");
        }
        
        OrientGraphFactory orientDbFactory = new OrientGraphFactory(propertyResolver.getProperty("url"), 
        propertyResolver.getProperty("username"), propertyResolver.getProperty("password"));
        orientDbFactory.setupPool(10, 100);
        
        return orientDbFactory;
    }

}
and in the classes just inject this 

@Autowired
private OrientGraphFactory graphFactory;

Keep in mind that in my code I use an external server, just change it using the provided page to start and embebed server instead of connecting to an external server
Add a comment...

Julie Frund

Discussione  - 
 
Another Orient newbie here!  I'm experimenting with my database, still wrapping my head around how to best model my data and realized I should have had one of my classes extend a different superclass.  How do I change it?   I was trying 'ALTER CLASS X extends Y' but that it's doing the trick.   Thanks for any tips!  
1
Luca Garulli's profile photoJulie Frund's profile photo
4 comments
 
Thanks!  
Add a comment...

Shivanandan Gupta

Discussione  - 
 
I am a newbie and using Orientdb from past 4 days. Wanted to know if I have to make some change in setting so that below given query works.


insert into element from (select from S_ELEMENT ) is not working and giving error message 

"com.orientechnologies.orient.core.command.OCommandExecutorNotFoundException: Cannot find a command executor for the command request: sql.( select from S_ELEMENT )"
2
Shivanandan Gupta's profile photo
 
got the solution, parentheses are the problem here , without parentheses  the query works fine. 
Add a comment...

Owen Campbell

Discussione  - 
 
I'm an Orient DB newbie and I've posted a newbie question on stackoverflow. Any help gratefully received!!
2
Add a comment...
 
HI ALL!

I try tunning OrientDB with getting started (Perfomance Tunning).
I use JAVA_OPTS="$JAVA_OPTS -server -Xmx2g -Dstorage.diskCache.bufferSize=8000 -Dstorage.keepOpen=true" and OrientDB start with single mode in server.sh
I use Massive Insertion over 100 000 000 records into class FirstDocument and into class FirstDocumentLayout above 4-5 per one record of FirstDocument.
FirstDocument and FirstDocumentLayout classes has 4-8 various properties such as integer, string, link and linksets and some indexed.

Now OrientDB used 82GB disk space.
CLASSES
--------------------------------------------+----------------------------------+----------+--------------+
 NAME                                         | SUPERCLASS                         | CLUSTERS   | RECORDS        |
--------------------------------------------+----------------------------------+----------+--------------+
 FirstDocument                                |                                    | 10         |       35642095 |
 FirstDocumentLayout                          |                                    | 12         |      142568373 |
--------------------------------------------+----------------------------------+----------+--------------+
 TOTAL = 12                                                                                            178210504 |
--------------------------------------------+----------------------------------+----------+--------------+

But linux kernel periodically killed java process OrientDB!!!
Java process ODB killed if inserted about 30-50 millions records.
Once Java porcess ODB also killed if inserted 30-50 millions as I wanted less records, and ODB work do nothing 1-2 days (without inserting process). Then java process ODB is "died" by kernel.

Java heap mem use normally but off-heap mem uesed abnormally and not limited.

In /var/log/messsages likes

Oct 13 12:25:05 test-cdn01 kernel: Out of memory: Kill process 7643 (java) score 950 or sacrifice child
Oct 13 12:25:05 test-cdn01 kernel: Killed process 7643, UID 0, (java) total-vm:21025600kB, anon-rss:15983144kB, file-rss:1228kB

And I've some questions:

1. Option storage.diskCache.bufferSize don't work?
2. Why OrientDB did allocated all RAM?
3. I trying use file.mmap.useOldManager=true and file.mmap.maxMemory=10000 but it's no effects?

Server has CentOS release 6.5, 4CPU 2000Mhz, 16GB RAM, over 220 GB part /opt/orientdb and jdk1_8_20 x64bit.
1
Add a comment...

Thomas Knoell

Discussione  - 
 
Hi,

We recently upgraded to OrientDB version 1.7.8 and updated our Java application to work with it. On our Windows development platform all works fine, no trouble. Like with the previous application versions, we then deployed it to a Linux system. Like before, the deployment includes the OrientDB related libs. Unlike with previous versions, this one will issue the following exception:

Found interface com.orientechnologies.orient.core.metadata.OMetadata, but class was expected

I checked for the error and found some references to the blueprints-orient-graph lib that should be removed but in this case, we don’t even have that lib present. The libs that are present are: blueprints-core-2.5.0.jar, gremlin-groovy-2.5.0.jar, gremlin-java-2.5.0.jar, orient-commons-1.7.8.jar, orientdb-client-1.7.8.jar, orientdb-core-1.7.8.jar, orientdb-distributed-1.7.8.jar, orientdb-enterprise-1.7.8.jar, orientdb-graphdb-1.7.8.jar, orientdb-nativeos-1.7.8.jar, orientdb-object-1.7.8.jar, orientdb-server-1.7.8.jar and orientdb-tools-1.7.8.jar.

What are we missing here?

Thanks

  Thomas
1
Thomas Knoell's profile photo
6 comments
 
Hi Luca,

Some additional information. 

Here is the code in question that results in the reported error:

if (db.getMetadata().getSchema().existsClass(“C1”))
    db.getMetadata().getSchema().dropClass(“C1”);

OClass object = db.getMetadata().getSchema().getOrCreateClass(“C1”);

The error happens in the check for the class existence. Once this part was commented out, the error no longer appears. 

Thanks

  Thomas
Add a comment...

Luca Garulli
owner

Discussione  - 
 
Looking for a Graph Database? Make sure you pick the best one: http://www.orientechnologies.com/orientdb-vs-neo4j/ #graphdb
OrientDB vs Neo4j OrientDB and Neo4J* share many features, but the engines are fundamentally different. While Neo4j is a pure Graph Database, OrientDB has …
3
1
David Strencsev's profile photo
Add a comment...

About this community

document graph NoSQL DBMS

Jimmy Pannier

Discussione  - 
 
hi orient db community !
Is it possible using the sql syntax to select all fields but except one.

f.e :
select *  except columnname from ...

Thanks !
2
Jimmy Pannier's profile photoNicolas Embleton's profile photo
2 comments
 
Nice... Didn't know that. Thanks for sharing it.
Add a comment...

Vinh Ht

Discussione  - 
 
How to save arrays in orientdb like MongoDB with Embedded
{
id : "1",
profile : {
   name:"abc"
  }
}
1
Ricardo Memoria's profile photo
 
Hi Vinh... Did you find an answer to your question? Could you please share it if so?
Add a comment...

camilo casadiego

Discussione  - 
 
Hi there guy, I just started using orientDB nd I got to say its pretty amazing, I got a question related to the API, is there a chance to create a vertex or an edge defining parent class using the addVertex API method, or should I run the "sql" command "create class V1 extends parentClass"
1
Luca Garulli's profile photocamilo casadiego's profile photo
2 comments
 
exactly what I was looking for! thank u very much!
Add a comment...

David Jung

Discussione  - 
 
I received an email from AWS that OrientDB community edition will not be available. Just wondering if there is any changes in OrientDB offering model.
3
Nicolas Embleton's profile photo
 
Interested in the discussion. 
Add a comment...

Mahesh Wabale

Discussione  - 
 
Hi i am new in orientDb technologies , I want how to setup the orientdb graph database which is distributed and also how to store it in RAM ( in main memory) 
1
Luca Garulli's profile photoMahesh Wabale's profile photo
2 comments
 
ok thanks...
Add a comment...

Joko Wandyatmono

Discussione  - 
 
Aah ...

It's hard to learn OrientDB for PHP user as me. Rather frustation to seek a step by step orientDB implementation with PHP.
1
Diego Falcinelli's profile photoJoko Wandyatmono's profile photo
3 comments
 
+Bademus l. Thanks. For your suggest.
Add a comment...

Diego Falcinelli

Discussione  - 
 
Hibernate OGM
The power and simplicity of JPA for NoSQL datastores. Including support for associations, sub-classes, queries and much more. The ride has just begun, so come and join us!

Wide range of backends
OGM talks to NoSQL backends via store-specific dialects. Currently there is support for

Key/Value: Infinispan, Ehcache

Document: MongoDB

Graph: Neo4j

Your favorite NoSQL store isn’t listed here? We’d love to get your help for adding it.

http://hibernate.org/ogm/

Perchè non aggiungere OrientDB ??? :D :D 
Hibernate OGM. The power and simplicity of JPA for NoSQL datastores. Including support for associations, sub-classes, queries and much more. The ride has just begun, so come and join us! Getting started Download (4.1.0.Beta7) ...
4
Add a comment...
 
Is there any roadmap for Ruby support? All I can find is about jRuby or is outdated
1
Luca Garulli's profile photoJose Alberto Suárez López's profile photo
4 comments
 
yes, but as the project is quite new, I need something to prototype fast as possible, so effort is a big cost too. Another option I'm evaluating, is to use MongoDB, but every option has it's own problems.

Is interesting how Graph and Machine learning tools are so oriented to Java world, Maybe because they born as academic tools?
Add a comment...

OrientDB

Discussione  - 
 
OrientDB: new Documentation online! http://www.orientechnologies.com/docs/1.7.8/index.html. 
4
1
Soft Hai's profile photoRoberto Franchini's profile photo
 
I recognized it yesterday during I was working on my Dart Driver the documentation structure changed every 5 Min. and I had to search new to find the information I required.
But, good work. Looks better than the old Github-Wiki. And the documentation tree on the left hand also helps to find the information you need.
Add a comment...

Luca Garulli
owner

Discussione  - 
 
OrientDB Community Edition available for FREE on Amazon AWS Cloud!@awscloud https://aws.amazon.com/marketplace/pp/B00M07FHAO
3
2
John Firman's profile photoLuca Garulli's profile photoAleksandar Valchev's profile photoCarlo Pradissitto's profile photo
2 comments
 
AWS allows many choices, the SSD disk is the faster solution, but more expensive. We didn't execute a report about different performance against configuration, but this is something we'd like to do.
Add a comment...