hi roger, does it work when you do not and two criteria ? could you please send the sql log ?
jakob ----- Original Message ----- From: "Janssen, Roger" <[EMAIL PROTECTED]> To: "OJB User List (E-mail)" <[EMAIL PROTECTED]> Sent: Thursday, November 14, 2002 4:28 PM Subject: Bug : nested criteria in combination with orderBy fails > Hi, > > i have come across a weird thing. > > I build two criteria objects (C1 an C2) and then 'AND' them like > c1.addAndCriteria(c2). > > Now, when i execute the query, no problem. > But when i set an 'orderBy' on one of the attributes (not necessarily one of > the attributes in the where-clause), the query fails, low-level, the only > error message i could catch was "INFO accesslayer.ConnectionManager - > Rollback was called, do rollback on current connection > org.hsqldb.jdbcConnection@3a9340", in fact it isn't even an error message. > > If i do not 'AND' the criteria together, there is no problem, I do need to > 'AND' them though. > > Can anybody help me out here? > > (using OJB 0.9.7, PersistenceBroker API and HSQL) > > Thanx, > > Roger Janssen > iBanx > > > > ************************************************************************* > The information contained in this communication is confidential and is > intended solely for the use of the individual or entity to whom it is > addressed.You should not copy, disclose or distribute this communication > without the authority of iBanx bv. iBanx bv is neither liable for > the proper and complete transmission of the information has been maintained > nor that the communication is free of viruses, interceptions or interference. > > If you are not the intended recipient of this communication please return > the communication to the sender and delete and destroy all copies. > -- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
