Re: [Hibernate] Java-based query evaluator

[Juozas B. <ba...@ce...>]

<snip>
> I'm curious how feasible it would be to write a Java-based evaluator of
> Hibernate queries, or at least leverage the existing parser code to gain
> access to the abstract syntax tree.
>
> One possibility is that certain subsets of queries (most filters, I
> think) could be run within the JVM, saving a db query.
possible it can be a good optimization, I am not sure:
 if   "SELECT * FROM TABLE" was executed in current session and all objects
are in cache , execute query on session cache.
It is possible to implement "If  current query result will be subset of some
query executed before ... ".
But it is not trivial.
Not all databases support standard sql, "NULL==NULL" can evalute to true on
databases, possible it can be more problems.

>
> Also, a translator could allow Hibernate query language to be used with
> other persistence engines (ok, this is not so compelling since Hibernate
> is the best :)
>
<snip>
> Thanks,
> Chris
>
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> hibernate-devel mailing list
> hib...@li...
> https://lists.sourceforge.net/lists/listinfo/hibernate-devel