hi j�rgen, could you please provide the sqls for both cases. the strange thing is that getCollectionByQuery uses getIteratorByQuery.
jakob ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 16, 2002 10:18 AM Subject: problem in getIteratorByQuery > hi! > using ojb 0.9.6 in singlevm mode. the following code returns one element > on mysql (correct) and no elements on mssqlserver (should also be one > element). > > Criteria criteria = new Criteria(); > criteria.addEqualTo( "userAccountOid", user.getOid() ); > Query query = new QueryByCriteria( clazz, criteria ); > final Iterator iterator = persistenceBroker.getIteratorByQuery( > query ); > return iterator; > > when i change the code, to the following example, it works correctly on > both databases. > > Criteria criteria = new Criteria(); > criteria.addEqualTo( "userAccountOid", user.getOid() ); > Query query = new QueryByCriteria( clazz, criteria ); > final Collection collection = > persistenceBroker.getCollectionByQuery( query ); > final Iterator iterator = collection.iterator(); > return iterator; > > any ideas? > > juergen > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
