(post is followup for:
http://sourceforge.net/forum/forum.php?thread_id=741754&forum_id=128638)
OK, I've jumped into Hibernate's source (first in my life). I've added
support into ClauseParser looking for the needed START WITH and CONNECT BY
clauses - that was the easy part.. I see (if I see correctly), that I'll
need two additional Parser-implementing classes working for these two
clauses.
I've checked some another parser classes to take as examples (OrderByParser
and WhereParser), and afair I have to extend the QueryTranslator class with
the Lists and needed methods to insert elements into the lists for these two
clauses. I also seem have to parse up the possible object relations before adding
the clauses to the QueryTranslator. After finishing all these I would have
to add the right lines to QT.renderSQL(), and.. and I'd really throw some
Exception when we're not on top of Oracle (I thought after, but cant think
of any way doing this from plain SQL'92 for the first try).
So.. is that the way I'd go, or I'm horrible mistaken? Also, is anyone
interested adding this feature, or is that only me, myself and I? :)
thanks,
dyn
ps. ofc if this code is already in CVS or will be for tomorrow, I'll be the
happiest dude around :) But if that job waits for me, I'll try and get
through it tomorrow.
--
.Digital.Yearning.for.Networked.Assassination.and.Xenocide
|