1 Reply Latest reply on May 22, 2006 3:45 AM by anajavi

    cmp2.x jdbc2 pm SELECT DISTINCT

    anajavi Newbie

      I have a problem changing EJB 2.1 CMP configuration to use cmp2.x jdbc2 pm container configuration.

      cmp2.x jdbc2 pm fetches all fields with single SELECT DISTINCT statement. It works normally, but when there is CLOB in a table some databases throw SQLException.

      I run tests on Sybase, HSQL, Oracle and PostreSQL. Sybase and Oracle do not permit SELECT DISTINCT on CLOB field, HSQL and PostgreSQL do.

      Is there a way to disable SELECT DISTINCT on entities with CLOBs or a way to remove fields from SELECT DISTINCT?

      Thanks in advance..