0 Replies Latest reply on Mar 16, 2005 12:47 PM by helly15

    4 times longer startup time after migrating to jboss-4.0.1

    helly15

      Hello,

      I am trying to migrate our application to JBoss-4.0.1, but I am facing
      a problem: The startup time with JBoss-3.2.1 was around 2.5 min and
      now it is over 10 min! I noticed that JBoss-4.0.1 uses the major part oft the startup time to create the SQL statements for the entitybeans (see code below).

      
      2005-03-14 17:40:38,956 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.SequenceEnti
      ty#findByPrimaryKey] SQL: SELECT t0_SequenceEntity.OBJECT_TYPE FROM TDVB_KEY_INDEX t0_SequenceEntity
       WHERE t0_SequenceEntity.OBJECT_TYPE=?
      2005-03-14 17:40:38,966 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.SequenceEntity] Added
       findByPrimaryKey query command for local home interface
      2005-03-14 17:40:38,976 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.JurPartnerEnti
      ty] Insert Entity SQL: INSERT INTO TDVB_JUR_PARTNER (Partner_Nr, FIRMA_ZUSATZ) VALUES (?, ?)
      2005-03-14 17:40:38,976 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.JurPartnerEnti
      ty] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_JUR_PARTNER WHERE Partner_Nr=?
      2005-03-14 17:40:38,976 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.JurPartnerEntity] e
      ntity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEnti
      tyCommand,attributes={}]
      2005-03-14 17:40:38,976 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.JurPartnerEnti
      ty] Remove SQL: DELETE FROM TDVB_JUR_PARTNER WHERE Partner_Nr=?
      2005-03-14 17:40:56,811 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.JurPartnerEntity] Tab
      le not create as requested: TDVB_JUR_PARTNER
      
      etc, etc...
      




      Has anyone an explanation for this?

      Regards, Peter