db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ed Bagdonas" <ebagdo...@epropshop.com>
Subject Criteria Bug - Torque 3.1 / SapDB 7.4 : crit.setDistinct() (Workaround Requested)
Date Tue, 27 Jan 2004 16:29:49 GMT
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?

 

 

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message