We are attempting to use Apache Torque 3.1 (java persistence layer) with MaxDb 7.5.
Torque generated select distinct queries to the database to get a list of objects for manipulation look like: SELECT DISTINCT foo.PKEY, foo.USERSID, foo.DESCRIPTION FROM foo ORDER BY foo.PKEY Torque propagates an exception from the database: SQL statement not allowed for column of data type LONG:DESCRIPTION According the SapDB documentation DISTINCT is not supported on long byte / longtext columns. I am sort of curious why this is the case - what if it were required? Is there a work-around? In our case the DESCRIPTION field is varies in size from 0 to ~2K bytes. (Note that the data was created through maxdbproxy from a previously existing MySqlMaxNt database, and that the longtext column type was created from the mysql text type. )
