Primary keys of concerned tables are not text, ntext or image as the Exception message says...
It's just INTEGERS ! I've avoided the problem with a really bad solution in order to give me more time to find a good one : deleting doubled item in my result list ... Frederic. -----Message d'origine----- De : Thomas Fischer [mailto:[EMAIL PROTECTED] Envoyé : mercredi 2 mars 2005 11:50 À : Apache Torque Users List Objet : RE: Problem with setDistinct() Hi, its just as it says: some datasets do not support DISTINCT with some datatypes. No problem of Torque, but of the database. I got no clean solution, only if your content is short enough then you can use VARCHAR instead of whatever datatype you use and it should work then. Thomas "KERNEUZET FREDERIC" <[EMAIL PROTECTED]> schrieb am 01.03.2005 14:17:48: > Hi everyone, > > I've got a problem with something quite "easy", and besides, already > used in another place in my application ... > > The source code is : > ==================== > ArrayList listRole = new ArrayList(); > listRole.add("Correspondant"); > > criteria.addJoin( SalariePeer.USER_ID, TurbineUserGroupRolePeer.USER_ID ); > criteria.addJoin(TurbineRolePeer.ROLE_ID, TurbineUserGroupRolePeer. > ROLE_ID); > criteria.addNotIn(TurbineRolePeer.ROLE_NAME,listRole); > > criteria.setDistinct(); > > List lstSalarie = SalariePeer.doSelect(criteria); > ==================== > > It gives me an sql request without any column selected : > SELECT DISTINCT FROM TURBINE_ROLE, SALARIE, TURBINE_USER_GROUP_ROLE > WHERE TURBINE_ROLE.ROLE_NAME NOT IN ('Correspondant') AND SALARIE. > USER_ID=TURBINE_USER_GROUP_ROLE.USER_ID AND TURBINE_ROLE. > ROLE_ID=TURBINE_USER_GROUP_ROLE.ROLE_ID > > And an java.sql.Exception in thrown : > java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC] > [SQLServer]Data type like text, ntext or image cannot be selected asDISTINCT. > > (error message translated from french) > > As someone got an idea ? > > > Thanks ! > ================================== > Frédéric Kerneuzet > ================================== > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]