8 Replies Latest reply on May 10, 2004 2:44 PM by sesques

    a strange error of SQL generated by CMP

    cold_lin Newbie

      When I try to do a single loadAll CMP finder query, the sql generated is very strange like: (and the second one is too long to be executed)

      2004-05-10 10:29:28,365 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.MyPicklist#findAll] Executing SQL: SELECT t0_b.SCU_NO FROM syscomu t0_b

      2004-05-10 10:29:29,086 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.MyPicklist] Executing SQL: SELECT SCU_NO, SCU_CODE, SCU_DET FROM syscomu WHERE (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR (SCU_NO=?) OR ..... (looks never end:( )