How to get a recordid from OrientDB on insert?

Question

OrientDB question...

Does anyone know how I can get the recordId after an insert:

db.save(person)

I tried below on the Person POJO:

@Id
private Object id;

but the id field was null after the save. I've googled and googled to no avail. I just need to insert an object, then get the recordid that orientdb generates.

Answer 1

Define field in pojo:

@Id
private Object rid;

public Object getRid() {
    return rid;
}

When save:

YourClass proxy = db.save(yourClassInstance);
Object rid = proxy.getRid();

Answer 2

I got it to work using ODocuments instead of POJOs (which works for my project). Code sample:

    ODatabaseDocumentTx db  = null;
    ODocument           doc = null;

    db = new ODatabaseDocumentTx("local:" + System.getProperty("user.home") + "/testDB");
    db.create();
    doc = new ODocument("Person");
    doc.field("name", "Peter");
    doc.save();
    String rid = doc.getIdentity().toString();
    List<ODocument> results = db.query(new OSQLSynchQuery<ODocument>("select from " + rid));
    for (ODocument aDoc : results) {
        System.out.println(aDoc.field("name"));
    }
    db.close();

Answer 3

It's just simple here is the code:

//insertquery will be the sql statement you want to insert

    ODocument result=db.command(new OCommandSQL(insertquery)).execute();

    System.out.println(result.field("@rid"));

Answer 4

Alternatively you can make use of getRecordByUserObject() of OObjectDatabaseTx,

OObjectDatabaseTx db = new OObjectDatabaseTx("local:" + System.getProperty("user.home") + "/testDB");

ODocument oDocument = db.getRecordByUserObject( person, true );
oDocument.save();

String rid = oDocument.getIdentity().toString();