Hi, OrientDB supports JPA partially, what about extending it? Instead if you want to stay with Hibernate, your approach is interesting. The big missing part here is the JOIN: converting any joins as: - dot notation if the link exists - use the graph edge if any - otherwise do a OrientDB join with a sub query
This would allow also BI tool to work better against OrientDB ;-) Lvc@ On 15 February 2014 22:59, Sander Postma <[email protected]> wrote: > > I am exploring a third option now: > https://github.com/spostma73/orientdb-jdbc > > Translating SQL in the JDBC drivers seems to have the lowest impact. This > is the first time I am trying something like this so the code ain't pretty > yet. (It's a bit complex, so not sure if it's ever going to be pretty...) > Let's see how far I get. A basic query "create table table1 (string1 > varchar(10), string2 varchar(20) not null, string3 varchar(20) null, > number1 int, number2 decimal(15, 2), date1 timestamp)" now translates into > CREATE CLASS TABLE1; > CREATE PROPERTY TABLE1.STRING1 STRING; > ALTER PROPERTY TABLE1.STRING1 MAX 10; > CREATE PROPERTY TABLE1.STRING2 STRING; > ALTER PROPERTY TABLE1.STRING2 MAX 20; > ALTER PROPERTY TABLE1.STRING2 NOTNULL=TRUE; > CREATE PROPERTY TABLE1.STRING3 STRING; > ALTER PROPERTY TABLE1.STRING3 MAX 20; > ALTER PROPERTY TABLE1.STRING3 NOTNULL=FALSE; > CREATE PROPERTY TABLE1.NUMBER1 INTEGER; > CREATE PROPERTY TABLE1.NUMBER2 FLOAT; > ALTER PROPERTY TABLE1.NUMBER2 MAX 18; > > This I created in 4 hours. Now the rest. > > On Thursday, May 10, 2012 7:18:29 PM UTC+2, David Williams wrote: > >> How trivial, at this point, would it be to get this working with a >> Hibernate dialect // with Spring-Hibernate? >> >> -- > > --- > 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 [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- --- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
