[Hibernate] Hibernate QL: Inner Joins

2003-10-17 Thread William R. Lorenz
All, I'm trying to do an inner join within Hibernate, but I'm having some difficulties and am hoping there's some knowledgeable people on the list. I have two objects: a Session object and an Account object, which can be joined in a query with session.field = account.field4; however, I don't ha

[Hibernate] Re: [Hibernate-issues] Hibernate QL: Inner Joins

2003-10-17 Thread Christian Bauer
On 17 Oct (14:44), William R. Lorenz wrote: > equals a particular value. In SQL, I could do this using something like: > > SELECT * FROM session > LEFT JOIN account ON Session.field1 = account.field4 > WHERE account.field3 = 'value' > > However, I can't seem to get Hibernate t

[Hibernate] Re: [Hibernate-issues] Hibernate QL: Inner Joins

2003-10-17 Thread William R. Lorenz
Christian, Does that mean that I can use HQL to join tables unless there's a mapping that will allow that join to happen implicitly? If I can in fact join them explicity, could you please provide me a bit of syntax example? Thanks for your quick response, Christian! On Fri, 17 Oct 2003, Christi

[Hibernate] XDoclet generated hibernate.cfg.xml

2003-10-17 Thread Brier, Fred - NASHCCON
I thought I saw an email from Gavin saying that XDoclet could generate the hibernate.hbm.xml file. What wasn't clear was whether he was saying that: yes, in a theoretical sense, it can be done. Or whether the feature is in place. I downloaded the latest XDoclet cvs snap shot and cannot find anyt

[Hibernate] Re: [Hibernate-issues] Hibernate QL: Inner Joins

2003-10-17 Thread Christian Bauer
On 17 Oct (14:56), William R. Lorenz wrote: > Does that mean that I can use HQL to join tables unless there's a mapping > that will allow that join to happen implicitly? If I can in fact join > them explicity, could you please provide me a bit of syntax example? You can join them like you did: w

[Hibernate] Problem with order by - SQL

2003-10-17 Thread alejandroariel76
Hello hibernate boys, I'm new with hibernate and i'm having a problem with a SQL formed by it. The SQL formed by hibernate says "Select ent.desc as desc From art as ent Order by ent.desc" And when the program runs it give me and SQL exception with the text "invalid column name" becouse t

RE: [Hibernate] Saving Collections from Multiple Sessions

2003-10-17 Thread Urberg, John
Status Update: We've decided to "punt" for now. We are going to add some code to our domain objects to keep track of changes and manually build the insert/update/delete statements for them. We'll continue to use Hibernate for loading objects since Hibernate's querying capabilities are great (plu