[Hibernate-devel] Is this type of query possible?
Hi,
I've managed to get all of my direct JDBC calls
replaced except for one. I can't figure out how to write this particular
query using the hibernate query language, so I'm not even sure it is
possible. If it's not possible then I'll take the time to implement it,
however I wanted to make sure first.
Below is an example of the resulting SQL that I
want to create:
select foo.id, foo.namefrom foowhere foo.id
in( select foo_attr.id_foo from
foo_attr where (foo_attr.id_attribute = 'attribute1' and
foo_attr.strvalue = 'value1') and id_foo in
( select
foo_attr.id_foo from
foo_attr where (foo_attr.id_attribute =
'attribute2' and foo_attr.strvalue = 'value2')
))
Basically, there is a parent table ("foo" in my
example above) and there is list of attributes for a particular foo object
(called "foo_attr") in my example above. I want to find all Foo's where it
have an attribute "attribute1" equal to "value1" and an attribute "attribute2"
equal to "value2".
So, is this something I will have to implement (and
if so, are there suggestions on the syntax of the query), or does this already
exist?
Thanks,
Jon...
Re: [Hibernate-devel] updating documentation procedure
>What is the status of the SAP dialect? Does it work? I've never actually >tested it myself - I understood it was incomplete. Do the FooBarTests run >on SAP DB? I installed SAP DB + got all the tests running tonight, I needed to make one little change to the dialect to avoid some ugliness. We should document this immediately. Thanks Brad! P.S. It seems that SAP DB has no ANSI-style outerjoins, correct? --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ Hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate-devel] updating documentation procedure
Hi Brad. The html is compiled from the aft files. Aft is an easy-to-use perl program http://www.maplefish.com/todd/aft.html What is the status of the SAP dialect? Does it work? I've never actually tested it myself - I understood it was incomplete. Do the FooBarTests run on SAP DB? > i would like to add the SAP DB dialect to the dialects listed in the > documentation, but am not sure how. the doc directory contains both html > and .aft files (i know nothing about aft). what is the right way to go > about this? --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ Hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
[Hibernate-devel] How to set log level?
Hi! Is there some easy way to change hibernate log level? (sample properties file etc.) I tried to write simplelog.propertis file but I could not make it work as I wish. Thanx, Damijan --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ Hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
