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.. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3944455#3944455 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3944455 ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
