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...