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]

Reply via email to