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.