The criteria call, crit.setDistinct();, does not work on SapDB 7.4 when
the underlying table contains 

a long byte column (text blob).  

 

The sql generated by the torque 3.1 query is (synthesized):

SELECT DISTINCT foo.PKEY, foo.USERSID, foo.DESCRIPTION FROM foo ORDER BY
foo.PKEY 

 

Torque throws the following exception:

SQL statement not allowed for column of data type LONG:DESCRIPTION

 

According the SapDB documentation DISTINCT is not supported on long byte
columns. 

 

Is there a work-around with the criteria or something to get this to
work?

 

 

 

Reply via email to