0 Replies Latest reply on Dec 27, 2002 3:38 AM by Xuebin Liu

    The method of findByPrimaryKey works unconventionally

    Xuebin Liu Newbie

      The following is the info of one business processing created by JBoss 3.0.4:
      [************************************
      2002-12-27 15:32:18,256 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.AdminInfo.findByPrimaryKey] Executing SQL: SELECT ID FROM ADMIN_INFO WHERE ID=?
      2002-12-27 15:32:18,413 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.AdminInfo] Executing SQL: SELECT PASSWD, ADMIN_NAME, STATUS FROM ADMIN_INFO WHERE (ID=?)
      2002-12-27 15:32:18,459 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.AdminIp.findByAdminId] Executing SQL: SELECT t0_o.ADMININFO_ID, t0_o.IP FROM ADMIN_IP t0_o WHERE t0_o.ADMININFO_ID = ?
      2002-12-27 15:32:18,475 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.AdminOrgRightLink.findByAdmininfoId] Executing SQL: SELECT t0_o.ADMININFO_ID, t0_o.ORG_ID, t0_o.RIGHT_ID FROM ADMIN_ORG_RIGHT_LINK t0_o WHERE t0_o.ADMININFO_ID = ?
      2002-12-27 15:32:18,616 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.AdminOrgRightLink] Executing SQL: SELECT ADMININFO_ID, ORG_ID, RIGHT_ID,CREATE_TIME FROM ADMIN_ORG_RIGHT_LINK WHERE (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?) OR (ADMININFO_ID=? AND ORG_ID=? AND RIGHT_ID=?)
      2002-12-27 15:32:18,709 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,741 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Organization] Executing SQL: SELECT NAME, MEMO FROM ORGANIZATION WHERE (ID=?)
      2002-12-27 15:32:18,741 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,756 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,772 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,772 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,788 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,803 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,803 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,819 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,819 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,834 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,834 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,850 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,850 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,866 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,881 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,881 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,897 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,897 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,913 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,913 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,928 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,928 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,944 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,944 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,944 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,959 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,959 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Organization] Executing SQL: SELECT NAME, MEMO FROM ORGANIZATION WHERE (ID=?)
      2002-12-27 15:32:18,975 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,975 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,975 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:18,991 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,006 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,006 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,022 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,022 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,038 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,053 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,069 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,069 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,069 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,084 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,084 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,100 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,100 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,100 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,116 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,131 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,131 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,147 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,147 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,163 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,163 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?
      2002-12-27 15:32:19,178 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Organization.findByPrimaryKey] Executing SQL: SELECT ID FROM ORGANIZATION WHERE ID=?

      ************************************]
      This cause the poor performance of the application.
      The question is why this occur and how to avoid them?