We can control our own code to use Orient, but the software we want to incorporate is JBoss jBPM6 which is an elephant and Hibernate is in there all the way. Not looking to rip Hiberate out of there. Even if I did I would have to do it again next version. My new plan now is to take the Parser.java from the H2 db project, strip it, and call the OrientDB Java API directly. What's the point of outputting SQL which has to be parsed again after...
On Sunday, February 16, 2014 2:56:39 AM UTC+1, Lvc@ wrote: > > 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] > <javascript:>>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] <javascript:>. >> 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.
