7 Replies Latest reply on Jun 23, 2005 2:28 AM by nicolas

    jboss-4.0.1 startup slow (Entitybean SQL generation problem)

    helly15

      Hello everybody,

      i am moving from jboss jboss-3.2.1 to jboss-4.0.1. The problem
      I am facing is that it takes jboss-4.0.1 over 10min to start,
      while jboss-3.2.1 started up in under 3min. I noticed that jboss-4.0.1
      uses a large part of the startup time to generate the sql for the
      entity beans (see code snipplet).


      17:43:28,409 DEBUG [DruckStatusEntity] Remove SQL: DELETE FROM TDVB_DRUCK_STATUS WHERE DRUCK_STATUS_ID=?



      The sql-generation is really slow, jboss generates about 1 statement in 15 sec.

      Can somebody give me a hint...what could be my problem?

      Best regards,
      Peter

        • 1. Re: jboss-4.0.1 startup slow (Entitybean SQL generation prob
          helly15

          Hello again,
          I exaggerated a little in my post: the generation of 1 sql
          statement does take less than 15sec.

          But the whole of the sql-generation takes over 8min, that's
          a large part of the total startup time. I will post the log
          statements of the sql-generation below.

          greetings,
          Peter

          2005-03-14 17:40:19,347 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.InternetOfferteEntity] Initializing CMP plugin for InternetOfferteEntity
          2005-03-14 17:40:21,020 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.SequenceEntity] Insert Entity SQL: INSERT INTO TDVB_KEY_INDEX (OBJECT_TYPE, COUNTER) VALUES (?, ?)
          2005-03-14 17:40:21,020 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.SequenceEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_KEY_INDEX WHERE OBJECT_TYPE=?
          2005-03-14 17:40:21,020 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.SequenceEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:40:21,030 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.SequenceEntity] Remove SQL: DELETE FROM TDVB_KEY_INDEX WHERE OBJECT_TYPE=?
          2005-03-14 17:40:38,896 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.SequenceEntity] Table not create as requested: TDVB_KEY_INDEX
          2005-03-14 17:40:38,956 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.SequenceEntity#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.JurPartnerEntity] 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.JurPartnerEntity] 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] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:40:38,976 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.JurPartnerEntity] 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] Table not create as requested: TDVB_JUR_PARTNER
          2005-03-14 17:40:56,811 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.JurPartnerEntity#findByPrimaryKey] SQL: SELECT t0_JurPartnerEntit.Partner_Nr FROM TDVB_JUR_PARTNER t0_JurPartnerEntit WHERE t0_JurPartnerEntit.Partner_Nr=?
          2005-03-14 17:40:56,811 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.JurPartnerEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:40:56,851 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RisikoZusatzEntity] Insert Entity SQL: INSERT INTO TDVB_RISIKO_Z_ATTR (RISIKO_ID, ZUSATZ_NR, ZUSATZ_CODE, ZUSATZ_ATTR_CODE, ZUSATZ_ATTR_WERT, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:40:56,851 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RisikoZusatzEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_RISIKO_Z_ATTR WHERE RISIKO_ID=? AND ZUSATZ_NR=? AND ZUSATZ_CODE=? AND ZUSATZ_ATTR_CODE=?
          2005-03-14 17:40:56,851 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.RisikoZusatzEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:40:56,851 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.RisikoZusatzEntity] Remove SQL: DELETE FROM TDVB_RISIKO_Z_ATTR WHERE RISIKO_ID=? AND ZUSATZ_NR=? AND ZUSATZ_CODE=? AND ZUSATZ_ATTR_CODE=?
          2005-03-14 17:41:14,497 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.RisikoZusatzEntity] Table not create as requested: TDVB_RISIKO_Z_ATTR
          2005-03-14 17:41:14,497 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.RisikoZusatzEntity#findByPrimaryKey] SQL: SELECT t0_RisikoZusatzEnt.RISIKO_ID, t0_RisikoZusatzEnt.ZUSATZ_NR, t0_RisikoZusatzEnt.ZUSATZ_CODE, t0_RisikoZusatzEnt.ZUSATZ_ATTR_CODE, t0_RisikoZusatzEnt.ZUSATZ_ATTR_WERT, t0_RisikoZusatzEnt.ERSTELLUNGSDATUM, t0_RisikoZusatzEnt.ERSTELLUNG_ID, t0_RisikoZusatzEnt.AENDERUNGSDATUM, t0_RisikoZusatzEnt.AENDERUNG_ID FROM TDVB_RISIKO_Z_ATTR t0_RisikoZusatzEnt WHERE t0_RisikoZusatzEnt.RISIKO_ID=? AND t0_RisikoZusatzEnt.ZUSATZ_NR=? AND t0_RisikoZusatzEnt.ZUSATZ_CODE=? AND t0_RisikoZusatzEnt.ZUSATZ_ATTR_CODE=?
          2005-03-14 17:41:14,497 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.RisikoZusatzEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:41:14,537 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.FremdvertragEntity] Insert Entity SQL: INSERT INTO TDVB_FREMDVERTRAG (Fremdvertrag_Nr, Beziehung_Art, Vers_Gesellschaft, Risiko_Art, AblaufDatum, RisikoBeschreibung, Police_Nr, Ownership_Id, Branche, Offerte_Nr, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:41:14,537 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.FremdvertragEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_FREMDVERTRAG WHERE Fremdvertrag_Nr=?
          2005-03-14 17:41:14,537 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.FremdvertragEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:41:14,537 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.FremdvertragEntity] Remove SQL: DELETE FROM TDVB_FREMDVERTRAG WHERE Fremdvertrag_Nr=?
          2005-03-14 17:41:32,863 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.FremdvertragEntity] Table not create as requested: TDVB_FREMDVERTRAG
          2005-03-14 17:41:32,863 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.FremdvertragEntity#findByPrimaryKey] SQL: SELECT t0_FremdvertragEnt.Fremdvertrag_Nr FROM TDVB_FREMDVERTRAG t0_FremdvertragEnt WHERE t0_FremdvertragEnt.Fremdvertrag_Nr=?
          2005-03-14 17:41:32,873 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.FremdvertragEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:41:32,893 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.AntragsfrageEntity] Insert Entity SQL: INSERT INTO TDVB_ANTRAGSFRAGE (ANTRAGSFRAGE_ID, OFFERTE_NR, FRAGE_CODE, KATEGORIE, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:41:32,893 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.AntragsfrageEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_ANTRAGSFRAGE WHERE ANTRAGSFRAGE_ID=?
          2005-03-14 17:41:32,893 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.AntragsfrageEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:41:32,893 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.AntragsfrageEntity] Remove SQL: DELETE FROM TDVB_ANTRAGSFRAGE WHERE ANTRAGSFRAGE_ID=?
          2005-03-14 17:41:50,498 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.AntragsfrageEntity] Table not create as requested: TDVB_ANTRAGSFRAGE
          2005-03-14 17:41:57,989 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.AntragsfrageEntity#findByPrimaryKey] SQL: SELECT t0_AntragsfrageEnt.ANTRAGSFRAGE_ID, t0_AntragsfrageEnt.OFFERTE_NR, t0_AntragsfrageEnt.FRAGE_CODE, t0_AntragsfrageEnt.KATEGORIE, t0_AntragsfrageEnt.ERSTELLUNGSDATUM, t0_AntragsfrageEnt.ERSTELLUNG_ID, t0_AntragsfrageEnt.AENDERUNGSDATUM, t0_AntragsfrageEnt.AENDERUNG_ID FROM TDVB_ANTRAGSFRAGE t0_AntragsfrageEnt WHERE t0_AntragsfrageEnt.ANTRAGSFRAGE_ID=?
          2005-03-14 17:41:58,009 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.AntragsfrageEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:41:58,039 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.KommunikationEntity] Insert Entity SQL: INSERT INTO TDVB_KOMMUNIKATION (Kommunikation_Id, Partner_Nr, VVS_LAUFENDE_NR, Kommunikation_Art, Kommunikation_Nr, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:41:58,059 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.KommunikationEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_KOMMUNIKATION WHERE Kommunikation_Id=?
          2005-03-14 17:41:58,069 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.KommunikationEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:41:58,079 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.KommunikationEntity] Remove SQL: DELETE FROM TDVB_KOMMUNIKATION WHERE Kommunikation_Id=?
          2005-03-14 17:42:15,715 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.KommunikationEntity] Table not create as requested: TDVB_KOMMUNIKATION
          2005-03-14 17:42:15,725 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.KommunikationEntity#findByPrimaryKey] SQL: SELECT t0_KommunikationEn.Kommunikation_Id FROM TDVB_KOMMUNIKATION t0_KommunikationEn WHERE t0_KommunikationEn.Kommunikation_Id=?
          2005-03-14 17:42:15,735 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.KommunikationEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:42:15,765 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.AntwortEntity] Insert Entity SQL: INSERT INTO TDVB_ANTFRAGE_ANTW (ANTWORT_ID, ANTRAGSFRAGE_ID, ANTWORT_ATTR_CODE, ANTWORT_ATTR_WERT, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:42:15,775 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.AntwortEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_ANTFRAGE_ANTW WHERE ANTWORT_ID=? AND ANTRAGSFRAGE_ID=? AND ANTWORT_ATTR_CODE=?
          2005-03-14 17:42:15,785 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.AntwortEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:42:15,805 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.AntwortEntity] Remove SQL: DELETE FROM TDVB_ANTFRAGE_ANTW WHERE ANTWORT_ID=? AND ANTRAGSFRAGE_ID=? AND ANTWORT_ATTR_CODE=?
          2005-03-14 17:42:33,370 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.AntwortEntity] Table not create as requested: TDVB_ANTFRAGE_ANTW
          2005-03-14 17:42:33,380 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.AntwortEntity#findByPrimaryKey] SQL: SELECT t0_AntwortEntity.ANTWORT_ID, t0_AntwortEntity.ANTRAGSFRAGE_ID, t0_AntwortEntity.ANTWORT_ATTR_CODE, t0_AntwortEntity.ANTWORT_ATTR_WERT, t0_AntwortEntity.ERSTELLUNGSDATUM, t0_AntwortEntity.ERSTELLUNG_ID, t0_AntwortEntity.AENDERUNGSDATUM, t0_AntwortEntity.AENDERUNG_ID FROM TDVB_ANTFRAGE_ANTW t0_AntwortEntity WHERE t0_AntwortEntity.ANTWORT_ID=? AND t0_AntwortEntity.ANTRAGSFRAGE_ID=? AND t0_AntwortEntity.ANTWORT_ATTR_CODE=?
          2005-03-14 17:42:33,410 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.AntwortEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:42:33,450 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RisikoAttributEntity] Insert Entity SQL: INSERT INTO TDVB_RISIKO_ATTR (RISIKO_ID, ATTRIBUT_NR, ATTRIBUT_CODE, ATTRIBUT_WERT, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:42:33,470 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RisikoAttributEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_RISIKO_ATTR WHERE RISIKO_ID=? AND ATTRIBUT_NR=?
          2005-03-14 17:42:33,480 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.RisikoAttributEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:42:33,490 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.RisikoAttributEntity] Remove SQL: DELETE FROM TDVB_RISIKO_ATTR WHERE RISIKO_ID=? AND ATTRIBUT_NR=?
          2005-03-14 17:42:51,366 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.RisikoAttributEntity] Table not create as requested: TDVB_RISIKO_ATTR
          2005-03-14 17:42:51,366 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.RisikoAttributEntity#findByPrimaryKey] SQL: SELECT t0_RisikoAttributE.RISIKO_ID, t0_RisikoAttributE.ATTRIBUT_NR, t0_RisikoAttributE.ATTRIBUT_CODE, t0_RisikoAttributE.ATTRIBUT_WERT, t0_RisikoAttributE.ERSTELLUNGSDATUM, t0_RisikoAttributE.ERSTELLUNG_ID, t0_RisikoAttributE.AENDERUNGSDATUM, t0_RisikoAttributE.AENDERUNG_ID FROM TDVB_RISIKO_ATTR t0_RisikoAttributE WHERE t0_RisikoAttributE.RISIKO_ID=? AND t0_RisikoAttributE.ATTRIBUT_NR=?
          2005-03-14 17:42:51,396 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.RisikoAttributEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:42:51,466 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.OfferteEntity] Insert Entity SQL: INSERT INTO TDVB_OFFERTE (OFFERTE_NR, BEZIEHUNG_ART, MANDANT_ID, BRANCHE, MEDIA_CODE, GENERALAGENTUR, HAUPTAGENTUR, AGENT, BEGINNDATUM, ENDDATUM, DAUER, OFFERTE_ART, UNTERSCHRIFTSDATUM, EINGANGSDATUM, VERFALL, VERAENDERUNG_AB, VA_NACHTRAG_NR, VA_KORREKTUR_NR, POLICE_NR, URSPRUNGSOFFERTE, VA_TRANSAKTION, ARCHIV_ART, VERARBEITUNG_CODE, MAN_NACHBEHANDLUNG, ERSATZRECHNUNG, AVB_AUSGABEDATUM, ZAHLUNGSWEISE, AKTION_CODE, SANIERUNG_CODE, ERSETZT_POLICE, TEL_AKZEPT, STOP_CODE, BELASTUNG_KOSTEN, GUTSCHRIFT_KOSTEN, PRAEMIENACHRABATT, PRAEMIENACHBONUS, PRAEMIENACHSTEMPEL, RATENZUSCHLAG, STEMPELGEBUEHR, SVG_ZUSCHLAG, UVB_ZUSCHLAG, STAMM_CODE, ZIELGRUPPE, MUTATIONSGRUND, RATENZUSCHLAG_TYP, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:42:51,516 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.OfferteEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_OFFERTE WHERE OFFERTE_NR=?
          2005-03-14 17:42:51,526 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferteEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:42:51,536 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferteEntity] Remove SQL: DELETE FROM TDVB_OFFERTE WHERE OFFERTE_NR=?
          2005-03-14 17:43:09,192 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferteEntity] Table not create as requested: TDVB_OFFERTE
          2005-03-14 17:43:09,202 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferteEntity#findByPrimaryKey] SQL: SELECT t0_OfferteEntity.OFFERTE_NR, t0_OfferteEntity.BEZIEHUNG_ART, t0_OfferteEntity.MANDANT_ID, t0_OfferteEntity.BRANCHE, t0_OfferteEntity.MEDIA_CODE, t0_OfferteEntity.GENERALAGENTUR, t0_OfferteEntity.HAUPTAGENTUR, t0_OfferteEntity.AGENT, t0_OfferteEntity.BEGINNDATUM, t0_OfferteEntity.ENDDATUM, t0_OfferteEntity.DAUER, t0_OfferteEntity.OFFERTE_ART, t0_OfferteEntity.UNTERSCHRIFTSDATUM, t0_OfferteEntity.EINGANGSDATUM, t0_OfferteEntity.VERFALL, t0_OfferteEntity.VERAENDERUNG_AB, t0_OfferteEntity.VA_NACHTRAG_NR, t0_OfferteEntity.VA_KORREKTUR_NR, t0_OfferteEntity.POLICE_NR, t0_OfferteEntity.URSPRUNGSOFFERTE, t0_OfferteEntity.VA_TRANSAKTION, t0_OfferteEntity.ARCHIV_ART, t0_OfferteEntity.VERARBEITUNG_CODE, t0_OfferteEntity.MAN_NACHBEHANDLUNG, t0_OfferteEntity.ERSATZRECHNUNG, t0_OfferteEntity.AVB_AUSGABEDATUM, t0_OfferteEntity.ZAHLUNGSWEISE, t0_OfferteEntity.AKTION_CODE, t0_OfferteEntity.SANIERUNG_CODE, t0_OfferteEntity.ERSETZT_POLICE, t0_OfferteEntity.TEL_AKZEPT, t0_OfferteEntity.STOP_CODE, t0_OfferteEntity.BELASTUNG_KOSTEN, t0_OfferteEntity.GUTSCHRIFT_KOSTEN, t0_OfferteEntity.PRAEMIENACHRABATT, t0_OfferteEntity.PRAEMIENACHBONUS, t0_OfferteEntity.PRAEMIENACHSTEMPEL, t0_OfferteEntity.RATENZUSCHLAG, t0_OfferteEntity.STEMPELGEBUEHR, t0_OfferteEntity.SVG_ZUSCHLAG, t0_OfferteEntity.UVB_ZUSCHLAG, t0_OfferteEntity.STAMM_CODE, t0_OfferteEntity.ZIELGRUPPE, t0_OfferteEntity.MUTATIONSGRUND, t0_OfferteEntity.RATENZUSCHLAG_TYP, t0_OfferteEntity.ERSTELLUNGSDATUM, t0_OfferteEntity.ERSTELLUNG_ID, t0_OfferteEntity.AENDERUNGSDATUM, t0_OfferteEntity.AENDERUNG_ID FROM TDVB_OFFERTE t0_OfferteEntity WHERE t0_OfferteEntity.OFFERTE_NR=?
          2005-03-14 17:43:09,382 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferteEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:43:09,432 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RisikoEntity] Insert Entity SQL: INSERT INTO TDVB_RISIKO (RISIKO_ID, BEZIEHUNG_ART, RISIKO_NR, OFFERTE_NR, PLAN_NR, PRAEMIENACHRABATT, PRAEMIENACHBONUS, PRAEMIENACHSTEMPEL, RATENZUSCHLAG, STEMPELGEBUEHR, SVG_ZUSCHLAG, UVB_ZUSCHLAG, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:43:09,452 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RisikoEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_RISIKO WHERE RISIKO_ID=?
          2005-03-14 17:43:09,462 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.RisikoEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:43:09,482 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.RisikoEntity] Remove SQL: DELETE FROM TDVB_RISIKO WHERE RISIKO_ID=?
          2005-03-14 17:43:27,097 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.RisikoEntity] Table not create as requested: TDVB_RISIKO
          2005-03-14 17:43:28,319 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.RisikoEntity#findByPrimaryKey] SQL: SELECT t0_RisikoEntity.RISIKO_ID, t0_RisikoEntity.BEZIEHUNG_ART, t0_RisikoEntity.RISIKO_NR, t0_RisikoEntity.OFFERTE_NR, t0_RisikoEntity.PLAN_NR, t0_RisikoEntity.PRAEMIENACHRABATT, t0_RisikoEntity.PRAEMIENACHBONUS, t0_RisikoEntity.PRAEMIENACHSTEMPEL, t0_RisikoEntity.RATENZUSCHLAG, t0_RisikoEntity.STEMPELGEBUEHR, t0_RisikoEntity.SVG_ZUSCHLAG, t0_RisikoEntity.UVB_ZUSCHLAG, t0_RisikoEntity.ERSTELLUNGSDATUM, t0_RisikoEntity.ERSTELLUNG_ID, t0_RisikoEntity.AENDERUNGSDATUM, t0_RisikoEntity.AENDERUNG_ID FROM TDVB_RISIKO t0_RisikoEntity WHERE t0_RisikoEntity.RISIKO_ID=?
          2005-03-14 17:43:28,349 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.RisikoEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:43:28,369 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.DruckStatusEntity] Insert Entity SQL: INSERT INTO TDVB_DRUCK_STATUS (DRUCK_STATUS_ID, DRUCK_STATUS_NR, STATUS_NR, OFFERTE_NR, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:43:28,389 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.DruckStatusEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_DRUCK_STATUS WHERE DRUCK_STATUS_ID=?
          2005-03-14 17:43:28,399 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.DruckStatusEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:43:28,409 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.DruckStatusEntity] Remove SQL: DELETE FROM TDVB_DRUCK_STATUS WHERE DRUCK_STATUS_ID=?
          2005-03-14 17:43:46,035 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.DruckStatusEntity] Table not create as requested: TDVB_DRUCK_STATUS
          2005-03-14 17:43:46,035 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.DruckStatusEntity#findByPrimaryKey] SQL: SELECT t0_DruckStatusEnti.DRUCK_STATUS_ID, t0_DruckStatusEnti.DRUCK_STATUS_NR, t0_DruckStatusEnti.STATUS_NR, t0_DruckStatusEnti.OFFERTE_NR, t0_DruckStatusEnti.ERSTELLUNGSDATUM, t0_DruckStatusEnti.ERSTELLUNG_ID, t0_DruckStatusEnti.AENDERUNGSDATUM, t0_DruckStatusEnti.AENDERUNG_ID FROM TDVB_DRUCK_STATUS t0_DruckStatusEnti WHERE t0_DruckStatusEnti.DRUCK_STATUS_ID=?
          2005-03-14 17:43:46,035 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.DruckStatusEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:43:46,065 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.DeckungKategorieEntity] Insert Entity SQL: INSERT INTO TDVB_DECKUNG_KATEG (RISIKO_ID, DECKUNG_KAT_CODE, PRAEMIENACHRABATT, PRAEMIENACHBONUS, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:43:46,065 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.DeckungKategorieEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_DECKUNG_KATEG WHERE RISIKO_ID=? AND DECKUNG_KAT_CODE=?
          2005-03-14 17:43:46,065 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.DeckungKategorieEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:43:46,065 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.DeckungKategorieEntity] Remove SQL: DELETE FROM TDVB_DECKUNG_KATEG WHERE RISIKO_ID=? AND DECKUNG_KAT_CODE=?
          2005-03-14 17:44:03,660 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.DeckungKategorieEntity] Table not create as requested: TDVB_DECKUNG_KATEG
          2005-03-14 17:44:03,660 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.DeckungKategorieEntity#findByPrimaryKey] SQL: SELECT t0_DeckungKategori.RISIKO_ID, t0_DeckungKategori.DECKUNG_KAT_CODE, t0_DeckungKategori.PRAEMIENACHRABATT, t0_DeckungKategori.PRAEMIENACHBONUS, t0_DeckungKategori.ERSTELLUNGSDATUM, t0_DeckungKategori.ERSTELLUNG_ID, t0_DeckungKategori.AENDERUNGSDATUM, t0_DeckungKategori.AENDERUNG_ID FROM TDVB_DECKUNG_KATEG t0_DeckungKategori WHERE t0_DeckungKategori.RISIKO_ID=? AND t0_DeckungKategori.DECKUNG_KAT_CODE=?
          2005-03-14 17:44:03,660 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.DeckungKategorieEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:44:03,680 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.StatusEntity] Insert Entity SQL: INSERT INTO TDVB_STATUS (OFFERTE_NR, STATUS_NR, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?)
          2005-03-14 17:44:03,680 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.StatusEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_STATUS WHERE OFFERTE_NR=? AND STATUS_NR=?
          2005-03-14 17:44:03,680 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.StatusEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:44:03,680 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.StatusEntity] Remove SQL: DELETE FROM TDVB_STATUS WHERE OFFERTE_NR=? AND STATUS_NR=?
          2005-03-14 17:44:21,205 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.StatusEntity] Table not create as requested: TDVB_STATUS
          2005-03-14 17:44:21,205 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.StatusEntity#findByPrimaryKey] SQL: SELECT t0_StatusEntity.OFFERTE_NR, t0_StatusEntity.STATUS_NR, t0_StatusEntity.ERSTELLUNGSDATUM, t0_StatusEntity.ERSTELLUNG_ID, t0_StatusEntity.AENDERUNGSDATUM, t0_StatusEntity.AENDERUNG_ID FROM TDVB_STATUS t0_StatusEntity WHERE t0_StatusEntity.OFFERTE_NR=? AND t0_StatusEntity.STATUS_NR=?
          2005-03-14 17:44:21,205 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.StatusEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:44:21,215 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.VersicherungsBedingungEntity] Insert Entity SQL: INSERT INTO TDVB_VERS_BED (RISIKO_ID, VERS_BED_CODE, VERS_BED_TYP, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:44:21,215 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.VersicherungsBedingungEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_VERS_BED WHERE RISIKO_ID=? AND VERS_BED_CODE=?
          2005-03-14 17:44:21,215 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.VersicherungsBedingungEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:44:21,215 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.VersicherungsBedingungEntity] Remove SQL: DELETE FROM TDVB_VERS_BED WHERE RISIKO_ID=? AND VERS_BED_CODE=?
          2005-03-14 17:44:42,326 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.VersicherungsBedingungEntity] Table not create as requested: TDVB_VERS_BED
          2005-03-14 17:44:42,326 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.VersicherungsBedingungEntity#findByPrimaryKey] SQL: SELECT t0_VersicherungsBe.RISIKO_ID, t0_VersicherungsBe.VERS_BED_CODE, t0_VersicherungsBe.VERS_BED_TYP, t0_VersicherungsBe.ERSTELLUNGSDATUM, t0_VersicherungsBe.ERSTELLUNG_ID, t0_VersicherungsBe.AENDERUNGSDATUM, t0_VersicherungsBe.AENDERUNG_ID FROM TDVB_VERS_BED t0_VersicherungsBe WHERE t0_VersicherungsBe.RISIKO_ID=? AND t0_VersicherungsBe.VERS_BED_CODE=?
          2005-03-14 17:44:42,326 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.VersicherungsBedingungEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:44:42,366 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.AdresseEntity] Insert Entity SQL: INSERT INTO TDVB_ADRESSE (Adresse_id, Partner_Nr, VVS_LAUFENDE_NR, ADRESSE_ZUSATZ, POSTFACH_WEILER, STRASSE, PHONETIK_SCHL_STR, PLZ, ORT, Kanton, Land, ADRESSE_TYP, ADR_GUELTIG_AB, ADR_GUELTIG_BIS, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:44:42,366 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.AdresseEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_ADRESSE WHERE Adresse_id=?
          2005-03-14 17:44:42,366 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.AdresseEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:44:42,366 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.AdresseEntity] Remove SQL: DELETE FROM TDVB_ADRESSE WHERE Adresse_id=?
          2005-03-14 17:45:00,121 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.AdresseEntity] Table not create as requested: TDVB_ADRESSE
          2005-03-14 17:45:00,131 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.AdresseEntity#findByPrimaryKey] SQL: SELECT t0_AdresseEntity.Adresse_id FROM TDVB_ADRESSE t0_AdresseEntity WHERE t0_AdresseEntity.Adresse_id=?
          2005-03-14 17:45:00,131 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.AdresseEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:45:00,141 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.KontaktEntity] Insert Entity SQL: INSERT INTO TDVB_KONTAKT (KONTAKT_ID, PARTNER_NR, OWNERSHIP_ID, KONTAKT_ART, KONTAKT_AB, KONTAKT_BIS, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:45:00,141 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.KontaktEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_KONTAKT WHERE KONTAKT_ID=?
          2005-03-14 17:45:00,141 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.KontaktEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:45:00,141 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.KontaktEntity] Remove SQL: DELETE FROM TDVB_KONTAKT WHERE KONTAKT_ID=?
          2005-03-14 17:45:17,957 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.KontaktEntity] Table not create as requested: TDVB_KONTAKT
          2005-03-14 17:45:17,957 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.KontaktEntity#findByPrimaryKey] SQL: SELECT t0_KontaktEntity.KONTAKT_ID FROM TDVB_KONTAKT t0_KontaktEntity WHERE t0_KontaktEntity.KONTAKT_ID=?
          2005-03-14 17:45:17,967 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.KontaktEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:45:18,027 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.PendenzEntity] Insert Entity SQL: INSERT INTO TDVB_PENDENZ (PENDENZ_ID, PARTNER_NR, BEZIEHUNG_NR, BEZIEHUNG_ART, KEY, OWNERSHIP_ID, BRANCHE, PENDENZ_STATUS, ZUSTAENDIG_ID, ZUSTAENDIG_TEAM, TERMIN_AB, TERMIN_BIS, VERFAULDATUM, PENDENZ_TYP, PRIORITAET, ERGEBNIS, KOMMENTAR, DATEINAME, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:45:18,047 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.PendenzEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_PENDENZ WHERE PENDENZ_ID=?
          2005-03-14 17:45:18,057 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.PendenzEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:45:18,067 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.PendenzEntity] Remove SQL: DELETE FROM TDVB_PENDENZ WHERE PENDENZ_ID=?
          2005-03-14 17:45:35,873 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.PendenzEntity] Table not create as requested: TDVB_PENDENZ
          2005-03-14 17:45:35,883 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.PendenzEntity#findByPrimaryKey] SQL: SELECT t0_PendenzEntity.PENDENZ_ID FROM TDVB_PENDENZ t0_PendenzEntity WHERE t0_PendenzEntity.PENDENZ_ID=?
          2005-03-14 17:45:35,893 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.PendenzEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:45:35,943 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.PartnerEntity] Insert Entity SQL: INSERT INTO TDVB_PARTNER (Partner_Nr, Beziehung_Art, Partner_Nr_Host, Partner_Art, Partner_Status, Name_1, Name_1_UCASE, PHONETIK_SCHL_NAME, Name_2, Name_2_UCASE, Anrede, SPRACHE, REKU, ABFRAGE_PER, Kommentar, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:45:35,963 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.PartnerEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_PARTNER WHERE Partner_Nr=?
          2005-03-14 17:45:35,963 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.PartnerEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:45:35,983 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.PartnerEntity] Remove SQL: DELETE FROM TDVB_PARTNER WHERE Partner_Nr=?
          2005-03-14 17:45:53,788 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.PartnerEntity] Table not create as requested: TDVB_PARTNER
          2005-03-14 17:45:53,788 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.PartnerEntity#findByPrimaryKey] SQL: SELECT t0_PartnerEntity.Partner_Nr FROM TDVB_PARTNER t0_PartnerEntity WHERE t0_PartnerEntity.Partner_Nr=?
          2005-03-14 17:45:53,808 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.PartnerEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:45:53,818 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.PartnerEntity#findByHostPK] EJB-QL: SELECT OBJECT(p) FROM Partner p WHERE p.partnerNrHost = ?1
          2005-03-14 17:45:54,139 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.PartnerEntity#findByHostPK] SQL: SELECT t0_p.Partner_Nr FROM TDVB_PARTNER t0_p WHERE (t0_p.Partner_Nr_Host = ?)
          2005-03-14 17:45:54,159 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RolleEntity] Insert Entity SQL: INSERT INTO TDVB_ROLLE (Beziehung_Nr, Beziehung_Art, Beteiligter_Nr, Beteiligter_Art, Rolle_Art, Ownership_ID, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:45:54,179 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RolleEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_ROLLE WHERE Beziehung_Nr=? AND Beziehung_Art=? AND Beteiligter_Nr=? AND Beteiligter_Art=? AND Rolle_Art=?
          2005-03-14 17:45:54,189 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.RolleEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:45:54,199 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.RolleEntity] Remove SQL: DELETE FROM TDVB_ROLLE WHERE Beziehung_Nr=? AND Beziehung_Art=? AND Beteiligter_Nr=? AND Beteiligter_Art=? AND Rolle_Art=?
          2005-03-14 17:46:12,065 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.RolleEntity] Table not create as requested: TDVB_ROLLE
          2005-03-14 17:46:12,075 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.RolleEntity#findByPrimaryKey] SQL: SELECT t0_RolleEntity.Beziehung_Nr, t0_RolleEntity.Beziehung_Art, t0_RolleEntity.Beteiligter_Nr, t0_RolleEntity.Beteiligter_Art, t0_RolleEntity.Rolle_Art FROM TDVB_ROLLE t0_RolleEntity WHERE t0_RolleEntity.Beziehung_Nr=? AND t0_RolleEntity.Beziehung_Art=? AND t0_RolleEntity.Beteiligter_Nr=? AND t0_RolleEntity.Beteiligter_Art=? AND t0_RolleEntity.Rolle_Art=?
          2005-03-14 17:46:12,095 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.RolleEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:46:12,245 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.DeckungEntity] Insert Entity SQL: INSERT INTO TDVB_DECKUNG (RISIKO_ID, DECKUNG_KAT_CODE, DECKUNG_CODE, SPEZ_PRAEMIE_JN, BEZIEHUNG_NR, BEZIEHUNG_ART, TARIFDATUM, UMSCHREIBUNG_CODE, SISTIERUNG_JN, SELBSTBEHALTVARIA, BONUSSTUFENSYSTEM, BONUSSTUFE, BONUSSTUFE_INTERN, ENTSCHAEDIGUNG_ART, BASISPRAEMIE_1, BASISPRAEMIE_2, PRAEMIENACHSCORING, PRAEMIENACHRABATT, PRAEMIENACHBONUS, PRAEMIENACHSTEMPEL, VERS_SUMME_CODE, VERS_SUMME_BETRAG, MAN_BASISPRAEMIE, EINHEIT_1, WERT_1, EINHEIT_2, WERT_2, EINHEIT_3, WERT_3, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:46:12,275 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.DeckungEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_DECKUNG WHERE RISIKO_ID=? AND DECKUNG_KAT_CODE=? AND DECKUNG_CODE=?
          2005-03-14 17:46:12,285 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.DeckungEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:46:12,305 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.DeckungEntity] Remove SQL: DELETE FROM TDVB_DECKUNG WHERE RISIKO_ID=? AND DECKUNG_KAT_CODE=? AND DECKUNG_CODE=?
          2005-03-14 17:46:30,241 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.DeckungEntity] Table not create as requested: TDVB_DECKUNG
          2005-03-14 17:46:30,251 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.DeckungEntity#findByPrimaryKey] SQL: SELECT t0_DeckungEntity.RISIKO_ID, t0_DeckungEntity.DECKUNG_KAT_CODE, t0_DeckungEntity.DECKUNG_CODE, t0_DeckungEntity.SPEZ_PRAEMIE_JN, t0_DeckungEntity.BEZIEHUNG_NR, t0_DeckungEntity.BEZIEHUNG_ART, t0_DeckungEntity.TARIFDATUM, t0_DeckungEntity.UMSCHREIBUNG_CODE, t0_DeckungEntity.SISTIERUNG_JN, t0_DeckungEntity.SELBSTBEHALTVARIA, t0_DeckungEntity.BONUSSTUFENSYSTEM, t0_DeckungEntity.BONUSSTUFE, t0_DeckungEntity.BONUSSTUFE_INTERN, t0_DeckungEntity.ENTSCHAEDIGUNG_ART, t0_DeckungEntity.BASISPRAEMIE_1, t0_DeckungEntity.BASISPRAEMIE_2, t0_DeckungEntity.PRAEMIENACHSCORING, t0_DeckungEntity.PRAEMIENACHRABATT, t0_DeckungEntity.PRAEMIENACHBONUS, t0_DeckungEntity.PRAEMIENACHSTEMPEL, t0_DeckungEntity.VERS_SUMME_CODE, t0_DeckungEntity.VERS_SUMME_BETRAG, t0_DeckungEntity.MAN_BASISPRAEMIE, t0_DeckungEntity.EINHEIT_1, t0_DeckungEntity.WERT_1, t0_DeckungEntity.EINHEIT_2, t0_DeckungEntity.WERT_2, t0_DeckungEntity.EINHEIT_3, t0_DeckungEntity.WERT_3, t0_DeckungEntity.ERSTELLUNGSDATUM, t0_DeckungEntity.ERSTELLUNG_ID, t0_DeckungEntity.AENDERUNGSDATUM, t0_DeckungEntity.AENDERUNG_ID FROM TDVB_DECKUNG t0_DeckungEntity WHERE t0_DeckungEntity.RISIKO_ID=? AND t0_DeckungEntity.DECKUNG_KAT_CODE=? AND t0_DeckungEntity.DECKUNG_CODE=?
          2005-03-14 17:46:30,321 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.DeckungEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:46:30,361 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.NatPartnerEntity] Insert Entity SQL: INSERT INTO TDVB_NAT_PARTNER (PARTNER_NR, TITEL, Geschlecht, Geburtsdatum, Zivilstand, Nationalitaet, AUFENTHALTSBEW, IN_CH_SEIT, Beruf) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:46:30,381 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.NatPartnerEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_NAT_PARTNER WHERE PARTNER_NR=?
          2005-03-14 17:46:30,391 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.NatPartnerEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:46:30,401 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.NatPartnerEntity] Remove SQL: DELETE FROM TDVB_NAT_PARTNER WHERE PARTNER_NR=?
          2005-03-14 17:46:48,257 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.NatPartnerEntity] Table not create as requested: TDVB_NAT_PARTNER
          2005-03-14 17:46:48,267 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.NatPartnerEntity#findByPrimaryKey] SQL: SELECT t0_NatPartnerEntit.PARTNER_NR FROM TDVB_NAT_PARTNER t0_NatPartnerEntit WHERE t0_NatPartnerEntit.PARTNER_NR=?
          2005-03-14 17:46:48,277 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.NatPartnerEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:46:48,317 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.FuehrerausweisEntity] Insert Entity SQL: INSERT INTO TDVB_FUEAUSWEIS (Partner_Nr, Kategorie, Ausweis_seit, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:46:48,327 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.FuehrerausweisEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_FUEAUSWEIS WHERE Partner_Nr=? AND Kategorie=?
          2005-03-14 17:46:48,337 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.FuehrerausweisEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:46:48,347 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.FuehrerausweisEntity] Remove SQL: DELETE FROM TDVB_FUEAUSWEIS WHERE Partner_Nr=? AND Kategorie=?
          2005-03-14 17:47:06,182 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.FuehrerausweisEntity] Table not create as requested: TDVB_FUEAUSWEIS
          2005-03-14 17:47:06,182 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.FuehrerausweisEntity#findByPrimaryKey] SQL: SELECT t0_FuehrerausweisE.Partner_Nr, t0_FuehrerausweisE.Kategorie FROM TDVB_FUEAUSWEIS t0_FuehrerausweisE WHERE t0_FuehrerausweisE.Partner_Nr=? AND t0_FuehrerausweisE.Kategorie=?
          2005-03-14 17:47:06,202 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.FuehrerausweisEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:47:06,252 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.NachweisEntity] Insert Entity SQL: INSERT INTO TDVB_NACHWEIS (NACHWEIS_ID, GESELLSCHAFTSCODE, GUELTIG_AB, GUELTIG_BIS, HALTER_ID, HALTER, HALTER_NAT, HALTER_GEBDAT, EMPFAENGER_ID, EMPFAENGER, FAHRZEUGART, FAHRZEUGMARKE, FAHRZEUGTYP, KONTROLLSCHILD, FAHRGESTELL_NR, STAMM_NR, STANDORT_FZG, WECHSELSCHILD_JN, ERSATZFAHRZEUG_JN, SITZPLAETZE, OFFERTE_NR, POLICE_NR, IV_GRUND, NACHWEISSTATUS, OWNERSHIP_ID, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:47:06,283 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.NachweisEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_NACHWEIS WHERE NACHWEIS_ID=?
          2005-03-14 17:47:06,293 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.NachweisEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:47:06,303 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.NachweisEntity] Remove SQL: DELETE FROM TDVB_NACHWEIS WHERE NACHWEIS_ID=?
          2005-03-14 17:47:23,998 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.NachweisEntity] Table not create as requested: TDVB_NACHWEIS
          2005-03-14 17:47:24,008 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.NachweisEntity#findByPrimaryKey] SQL: SELECT t0_NachweisEntity.NACHWEIS_ID FROM TDVB_NACHWEIS t0_NachweisEntity WHERE t0_NachweisEntity.NACHWEIS_ID=?
          2005-03-14 17:47:24,018 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.NachweisEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:47:24,038 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.KontoVerbindungEntity] Insert Entity SQL: INSERT INTO TDVB_BANKVERB (Bankverbindung_Id, Partner_Nr, VVS_LAUFENDE_NR, KONTO_ART, Institutname, Konto_Nr, KREDITKARTE_ART, Clearing_Nr, Postcheck_nr_Bank, GUELTIG_BIS, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:47:24,058 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.KontoVerbindungEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_BANKVERB WHERE Bankverbindung_Id=?
          2005-03-14 17:47:24,068 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.KontoVerbindungEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:47:24,078 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.KontoVerbindungEntity] Remove SQL: DELETE FROM TDVB_BANKVERB WHERE Bankverbindung_Id=?
          2005-03-14 17:47:41,934 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.KontoVerbindungEntity] Table not create as requested: TDVB_BANKVERB
          2005-03-14 17:47:41,944 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.KontoVerbindungEntity#findByPrimaryKey] SQL: SELECT t0_KontoVerbindung.Bankverbindung_Id FROM TDVB_BANKVERB t0_KontoVerbindung WHERE t0_KontoVerbindung.Bankverbindung_Id=?
          2005-03-14 17:47:41,954 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.KontoVerbindungEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:47:42,004 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.InternetOfferteEntity] Insert Entity SQL: INSERT INTO TDVB_INTERNET_OFF (INTERNET_OFF_ID, MANDANT_ID, GENERALAGENTUR, HAUPTAGENTUR, AGENT, BRANCHE, PLAN_NR, REFERENZ_NR, REFERENZFOLGE_NR, INT_OFF_STATUS, NAME, VORNAME, PLZ, ORT, GEBURTSDATUM, SPRACHE, ZUTEILUNG, ZUSTAENDIG_ID, ZUSTAENDIG_TEAM, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID, XML_FILE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:47:42,034 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.InternetOfferteEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_INTERNET_OFF WHERE INTERNET_OFF_ID=?
          2005-03-14 17:47:42,044 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.InternetOfferteEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:47:42,054 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.InternetOfferteEntity] Remove SQL: DELETE FROM TDVB_INTERNET_OFF WHERE INTERNET_OFF_ID=?
          2005-03-14 17:47:46,530 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] run: IdleRemover notifying pools, interval: 450000
          2005-03-14 17:48:00,090 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.InternetOfferteEntity] Table not create as requested: TDVB_INTERNET_OFF
          2005-03-14 17:48:00,100 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.InternetOfferteEntity#findByPrimaryKey] SQL: SELECT t0_InternetOfferte.INTERNET_OFF_ID FROM TDVB_INTERNET_OFF t0_InternetOfferte WHERE t0_InternetOfferte.INTERNET_OFF_ID=?
          2005-03-14 17:48:00,110 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.InternetOfferteEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:48:00,170 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.KontakteintragEntity] Insert Entity SQL: INSERT INTO TDVB_KONTAKTEINTR (KONTAKT_ID, TRANSAKTION_ID, TRANSAKTION, TRANSAKTION_ART, TRANSAKT_BEZ_NR, TRANSAKT_BEZ_ART, TRANSAKTION_AB, TRANSAKTION_BIS, TRANSAKT_ERGEBNIS, TRANSAKT_DAUER, KOMMENTAR, BRANCHE, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:48:00,190 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.KontakteintragEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_KONTAKTEINTR WHERE KONTAKT_ID=? AND TRANSAKTION_ID=?
          2005-03-14 17:48:00,200 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.KontakteintragEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:48:00,210 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.KontakteintragEntity] Remove SQL: DELETE FROM TDVB_KONTAKTEINTR WHERE KONTAKT_ID=? AND TRANSAKTION_ID=?
          2005-03-14 17:48:17,946 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.KontakteintragEntity] Table not create as requested: TDVB_KONTAKTEINTR
          2005-03-14 17:48:17,956 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.KontakteintragEntity#findByPrimaryKey] SQL: SELECT t0_KontakteintragE.KONTAKT_ID, t0_KontakteintragE.TRANSAKTION_ID FROM TDVB_KONTAKTEINTR t0_KontakteintragE WHERE t0_KontakteintragE.KONTAKT_ID=? AND t0_KontakteintragE.TRANSAKTION_ID=?
          2005-03-14 17:48:17,966 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.KontakteintragEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:48:17,996 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.VvsTransaktionEntity] Insert Entity SQL: INSERT INTO TDVB_VVS_TRANSAKT (VVS_TRANSAKTION_ID, POLICE_NR, VA_TRANSAKTION, GRUND, ARCHIV_ART, VERARBEITUNG_CODE, VA_DATUM, PARTNER_NR, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          2005-03-14 17:48:18,006 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.VvsTransaktionEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_VVS_TRANSAKT WHERE VVS_TRANSAKTION_ID=?
          2005-03-14 17:48:18,016 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.VvsTransaktionEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:48:18,026 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.VvsTransaktionEntity] Remove SQL: DELETE FROM TDVB_VVS_TRANSAKT WHERE VVS_TRANSAKTION_ID=?
          2005-03-14 17:48:35,701 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.VvsTransaktionEntity] Table not create as requested: TDVB_VVS_TRANSAKT
          2005-03-14 17:48:35,711 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.VvsTransaktionEntity#findByPrimaryKey] SQL: SELECT t0_VvsTransaktionE.VVS_TRANSAKTION_ID FROM TDVB_VVS_TRANSAKT t0_VvsTransaktionE WHERE t0_VvsTransaktionE.VVS_TRANSAKTION_ID=?
          2005-03-14 17:48:35,721 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.VvsTransaktionEntity] Added findByPrimaryKey query command for local home interface
          2005-03-14 17:48:35,731 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.VvsTransaktionEntity#findByPoliceNr] EJB-QL: SELECT OBJECT(v) from VvsTransaktion v WHERE v.policeNr = ?1
          2005-03-14 17:48:35,741 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.VvsTransaktionEntity#findByPoliceNr] SQL: SELECT t0_v.VVS_TRANSAKTION_ID FROM TDVB_VVS_TRANSAKT t0_v WHERE (t0_v.POLICE_NR = ?)
          2005-03-14 17:48:35,751 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RollenbeziehungEntity] Insert Entity SQL: INSERT INTO TDVB_ROLLENBEZ (Beziehung_Nr, Beziehung_Art) VALUES (?, ?)
          2005-03-14 17:48:35,761 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RollenbeziehungEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_ROLLENBEZ WHERE Beziehung_Nr=? AND Beziehung_Art=?
          2005-03-14 17:48:35,771 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.RollenbeziehungEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
          2005-03-14 17:48:35,781 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.RollenbeziehungEntity] Remove SQL: DELETE FROM TDVB_ROLLENBEZ WHERE Beziehung_Nr=? AND Beziehung_Art=?
          2005-03-14 17:48:53,567 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.RollenbeziehungEntity] Table not create as requested: TDVB_ROLLENBEZ
          2005-03-14 17:48:53,577 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.RollenbeziehungEntity#findByPrimaryKey] SQL: SELECT t0_Rollenbeziehung.Beziehung_Nr, t0_Rollenbeziehung.Beziehung_Art FROM TDVB_ROLLENBEZ t0_Rollenbeziehung WHERE t0_Rollenbeziehung.Beziehung_Nr=? AND t0_Rollenbeziehung.Beziehung_Art=?


          • 2. Re: jboss-4.0.1 startup slow (Entitybean SQL generation prob
            helly15

            Hi,

            and here I post the corresponding log statements generated by
            JBoss-3.2.1 when generating the SQL statements for the entitybeans.
            It takes only 2.5 sec to generate the statements!

            Any help would be very much appreciated,
            best regards,
            peter


            2005-03-15 10:09:47,259 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.InternetOfferteEntity] Initializing CMP plugin for InternetOfferteEntity
            2005-03-15 10:09:48,681 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.SequenceEntity] Insert Entity SQL: INSERT INTO TDVB_KEY_INDEX (OBJECT_TYPE, COUNTER) VALUES (?, ?)
            2005-03-15 10:09:48,681 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.SequenceEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_KEY_INDEX WHERE OBJECT_TYPE=?
            2005-03-15 10:09:48,681 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.SequenceEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:48,691 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.SequenceEntity] Remove SQL: DELETE FROM TDVB_KEY_INDEX WHERE OBJECT_TYPE=?
            2005-03-15 10:09:48,741 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.SequenceEntity] Table not create as requested: TDVB_KEY_INDEX
            2005-03-15 10:09:48,751 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.SequenceEntity.findByPrimaryKey] SQL: SELECT OBJECT_TYPE FROM TDVB_KEY_INDEX WHERE OBJECT_TYPE=?
            2005-03-15 10:09:48,761 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.SequenceEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:48,772 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.JurPartnerEntity] Insert Entity SQL: INSERT INTO TDVB_JUR_PARTNER (Partner_Nr, FIRMA_ZUSATZ) VALUES (?, ?)
            2005-03-15 10:09:48,772 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.JurPartnerEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_JUR_PARTNER WHERE Partner_Nr=?
            2005-03-15 10:09:48,772 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.JurPartnerEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:48,772 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.JurPartnerEntity] Remove SQL: DELETE FROM TDVB_JUR_PARTNER WHERE Partner_Nr=?
            2005-03-15 10:09:48,772 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.JurPartnerEntity] Table not create as requested: TDVB_JUR_PARTNER
            2005-03-15 10:09:48,772 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.JurPartnerEntity.findByPrimaryKey] SQL: SELECT Partner_Nr FROM TDVB_JUR_PARTNER WHERE Partner_Nr=?
            2005-03-15 10:09:48,772 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.JurPartnerEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:48,782 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RisikoZusatzEntity] Insert Entity SQL: INSERT INTO TDVB_RISIKO_Z_ATTR (RISIKO_ID, ZUSATZ_NR, ZUSATZ_CODE, ZUSATZ_ATTR_CODE, ZUSATZ_ATTR_WERT, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:48,782 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RisikoZusatzEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_RISIKO_Z_ATTR WHERE RISIKO_ID=? AND ZUSATZ_NR=? AND ZUSATZ_CODE=? AND ZUSATZ_ATTR_CODE=?
            2005-03-15 10:09:48,782 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.RisikoZusatzEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:48,792 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.RisikoZusatzEntity] Remove SQL: DELETE FROM TDVB_RISIKO_Z_ATTR WHERE RISIKO_ID=? AND ZUSATZ_NR=? AND ZUSATZ_CODE=? AND ZUSATZ_ATTR_CODE=?
            2005-03-15 10:09:48,792 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.RisikoZusatzEntity] Table not create as requested: TDVB_RISIKO_Z_ATTR
            2005-03-15 10:09:48,792 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.RisikoZusatzEntity.findByPrimaryKey] SQL: SELECT RISIKO_ID, ZUSATZ_NR, ZUSATZ_CODE, ZUSATZ_ATTR_CODE, ZUSATZ_ATTR_WERT, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID FROM TDVB_RISIKO_Z_ATTR WHERE RISIKO_ID=? AND ZUSATZ_NR=? AND ZUSATZ_CODE=? AND ZUSATZ_ATTR_CODE=?
            2005-03-15 10:09:48,792 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.RisikoZusatzEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:48,812 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.FremdvertragEntity] Insert Entity SQL: INSERT INTO TDVB_FREMDVERTRAG (Fremdvertrag_Nr, Beziehung_Art, Vers_Gesellschaft, Risiko_Art, AblaufDatum, RisikoBeschreibung, Police_Nr, Ownership_Id, Branche, Offerte_Nr, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:48,822 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.FremdvertragEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_FREMDVERTRAG WHERE Fremdvertrag_Nr=?
            2005-03-15 10:09:48,822 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.FremdvertragEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:48,822 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.FremdvertragEntity] Remove SQL: DELETE FROM TDVB_FREMDVERTRAG WHERE Fremdvertrag_Nr=?
            2005-03-15 10:09:48,822 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.FremdvertragEntity] Table not create as requested: TDVB_FREMDVERTRAG
            2005-03-15 10:09:48,822 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.FremdvertragEntity.findByPrimaryKey] SQL: SELECT Fremdvertrag_Nr FROM TDVB_FREMDVERTRAG WHERE Fremdvertrag_Nr=?
            2005-03-15 10:09:48,822 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.FremdvertragEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:48,832 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.AntragsfrageEntity] Insert Entity SQL: INSERT INTO TDVB_ANTRAGSFRAGE (ANTRAGSFRAGE_ID, OFFERTE_NR, FRAGE_CODE, KATEGORIE, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:48,832 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.AntragsfrageEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_ANTRAGSFRAGE WHERE ANTRAGSFRAGE_ID=?
            2005-03-15 10:09:48,832 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.AntragsfrageEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:48,842 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.AntragsfrageEntity] Remove SQL: DELETE FROM TDVB_ANTRAGSFRAGE WHERE ANTRAGSFRAGE_ID=?
            2005-03-15 10:09:48,842 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.AntragsfrageEntity] Table not create as requested: TDVB_ANTRAGSFRAGE
            2005-03-15 10:09:48,842 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.AntragsfrageEntity.findByPrimaryKey] SQL: SELECT ANTRAGSFRAGE_ID, OFFERTE_NR, FRAGE_CODE, KATEGORIE, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID FROM TDVB_ANTRAGSFRAGE WHERE ANTRAGSFRAGE_ID=?
            2005-03-15 10:09:48,842 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.AntragsfrageEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:48,852 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.KommunikationEntity] Insert Entity SQL: INSERT INTO TDVB_KOMMUNIKATION (Kommunikation_Id, Partner_Nr, VVS_LAUFENDE_NR, Kommunikation_Art, Kommunikation_Nr, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:48,852 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.KommunikationEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_KOMMUNIKATION WHERE Kommunikation_Id=?
            2005-03-15 10:09:48,852 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.KommunikationEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:48,852 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.KommunikationEntity] Remove SQL: DELETE FROM TDVB_KOMMUNIKATION WHERE Kommunikation_Id=?
            2005-03-15 10:09:48,852 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.KommunikationEntity] Table not create as requested: TDVB_KOMMUNIKATION
            2005-03-15 10:09:48,852 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.KommunikationEntity.findByPrimaryKey] SQL: SELECT Kommunikation_Id FROM TDVB_KOMMUNIKATION WHERE Kommunikation_Id=?
            2005-03-15 10:09:48,852 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.KommunikationEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:48,872 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.AntwortEntity] Insert Entity SQL: INSERT INTO TDVB_ANTFRAGE_ANTW (ANTWORT_ID, ANTRAGSFRAGE_ID, ANTWORT_ATTR_CODE, ANTWORT_ATTR_WERT, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:48,872 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.AntwortEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_ANTFRAGE_ANTW WHERE ANTWORT_ID=? AND ANTRAGSFRAGE_ID=? AND ANTWORT_ATTR_CODE=?
            2005-03-15 10:09:48,872 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.AntwortEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:48,872 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.AntwortEntity] Remove SQL: DELETE FROM TDVB_ANTFRAGE_ANTW WHERE ANTWORT_ID=? AND ANTRAGSFRAGE_ID=? AND ANTWORT_ATTR_CODE=?
            2005-03-15 10:09:48,872 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.AntwortEntity] Table not create as requested: TDVB_ANTFRAGE_ANTW
            2005-03-15 10:09:48,872 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.AntwortEntity] Foreign key constraint not added as requested: relationshipRolename=Antragsfrage_hat_Antwort
            2005-03-15 10:09:48,872 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.AntwortEntity.findByPrimaryKey] SQL: SELECT ANTWORT_ID, ANTRAGSFRAGE_ID, ANTWORT_ATTR_CODE, ANTWORT_ATTR_WERT, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID FROM TDVB_ANTFRAGE_ANTW WHERE ANTWORT_ID=? AND ANTRAGSFRAGE_ID=? AND ANTWORT_ATTR_CODE=?
            2005-03-15 10:09:48,872 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.AntwortEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:48,902 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RisikoAttributEntity] Insert Entity SQL: INSERT INTO TDVB_RISIKO_ATTR (RISIKO_ID, ATTRIBUT_NR, ATTRIBUT_CODE, ATTRIBUT_WERT, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:48,902 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RisikoAttributEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_RISIKO_ATTR WHERE RISIKO_ID=? AND ATTRIBUT_NR=?
            2005-03-15 10:09:48,902 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.RisikoAttributEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:48,902 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.RisikoAttributEntity] Remove SQL: DELETE FROM TDVB_RISIKO_ATTR WHERE RISIKO_ID=? AND ATTRIBUT_NR=?
            2005-03-15 10:09:48,902 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.RisikoAttributEntity] Table not create as requested: TDVB_RISIKO_ATTR
            2005-03-15 10:09:48,902 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.RisikoAttributEntity.findByPrimaryKey] SQL: SELECT RISIKO_ID, ATTRIBUT_NR, ATTRIBUT_CODE, ATTRIBUT_WERT, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID FROM TDVB_RISIKO_ATTR WHERE RISIKO_ID=? AND ATTRIBUT_NR=?
            2005-03-15 10:09:48,902 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.RisikoAttributEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:48,952 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.OfferteEntity] Insert Entity SQL: INSERT INTO TDVB_OFFERTE (OFFERTE_NR, BEZIEHUNG_ART, MANDANT_ID, BRANCHE, MEDIA_CODE, GENERALAGENTUR, HAUPTAGENTUR, AGENT, BEGINNDATUM, ENDDATUM, DAUER, OFFERTE_ART, UNTERSCHRIFTSDATUM, EINGANGSDATUM, VERFALL, VERAENDERUNG_AB, VA_NACHTRAG_NR, VA_KORREKTUR_NR, POLICE_NR, URSPRUNGSOFFERTE, VA_TRANSAKTION, ARCHIV_ART, VERARBEITUNG_CODE, MAN_NACHBEHANDLUNG, ERSATZRECHNUNG, AVB_AUSGABEDATUM, ZAHLUNGSWEISE, AKTION_CODE, SANIERUNG_CODE, ERSETZT_POLICE, TEL_AKZEPT, STOP_CODE, BELASTUNG_KOSTEN, GUTSCHRIFT_KOSTEN, PRAEMIENACHRABATT, PRAEMIENACHBONUS, PRAEMIENACHSTEMPEL, RATENZUSCHLAG, STEMPELGEBUEHR, SVG_ZUSCHLAG, UVB_ZUSCHLAG, STAMM_CODE, ZIELGRUPPE, MUTATIONSGRUND, RATENZUSCHLAG_TYP, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:48,952 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.OfferteEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_OFFERTE WHERE OFFERTE_NR=?
            2005-03-15 10:09:48,952 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferteEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:48,952 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferteEntity] Remove SQL: DELETE FROM TDVB_OFFERTE WHERE OFFERTE_NR=?
            2005-03-15 10:09:48,952 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferteEntity] Table not create as requested: TDVB_OFFERTE
            2005-03-15 10:09:48,952 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferteEntity] Foreign key constraint not added as requested: relationshipRolename=Offerte_hat_Antragsfrage
            2005-03-15 10:09:48,952 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferteEntity.findByPrimaryKey] SQL: SELECT OFFERTE_NR, BEZIEHUNG_ART, MANDANT_ID, BRANCHE, MEDIA_CODE, GENERALAGENTUR, HAUPTAGENTUR, AGENT, BEGINNDATUM, ENDDATUM, DAUER, OFFERTE_ART, UNTERSCHRIFTSDATUM, EINGANGSDATUM, VERFALL, VERAENDERUNG_AB, VA_NACHTRAG_NR, VA_KORREKTUR_NR, POLICE_NR, URSPRUNGSOFFERTE, VA_TRANSAKTION, ARCHIV_ART, VERARBEITUNG_CODE, MAN_NACHBEHANDLUNG, ERSATZRECHNUNG, AVB_AUSGABEDATUM, ZAHLUNGSWEISE, AKTION_CODE, SANIERUNG_CODE, ERSETZT_POLICE, TEL_AKZEPT, STOP_CODE, BELASTUNG_KOSTEN, GUTSCHRIFT_KOSTEN, PRAEMIENACHRABATT, PRAEMIENACHBONUS, PRAEMIENACHSTEMPEL, RATENZUSCHLAG, STEMPELGEBUEHR, SVG_ZUSCHLAG, UVB_ZUSCHLAG, STAMM_CODE, ZIELGRUPPE, MUTATIONSGRUND, RATENZUSCHLAG_TYP, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID FROM TDVB_OFFERTE WHERE OFFERTE_NR=?
            2005-03-15 10:09:48,952 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferteEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:48,972 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RisikoEntity] Insert Entity SQL: INSERT INTO TDVB_RISIKO (RISIKO_ID, BEZIEHUNG_ART, RISIKO_NR, OFFERTE_NR, PLAN_NR, PRAEMIENACHRABATT, PRAEMIENACHBONUS, PRAEMIENACHSTEMPEL, RATENZUSCHLAG, STEMPELGEBUEHR, SVG_ZUSCHLAG, UVB_ZUSCHLAG, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:48,972 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RisikoEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_RISIKO WHERE RISIKO_ID=?
            2005-03-15 10:09:48,972 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.RisikoEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:48,972 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.RisikoEntity] Remove SQL: DELETE FROM TDVB_RISIKO WHERE RISIKO_ID=?
            2005-03-15 10:09:48,972 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.RisikoEntity] Table not create as requested: TDVB_RISIKO
            2005-03-15 10:09:48,972 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.RisikoEntity] Foreign key constraint not added as requested: relationshipRolename=Offerte_hat_Risiko
            2005-03-15 10:09:48,972 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.RisikoEntity] Foreign key constraint not added as requested: relationshipRolename=Risiko_hat_RisikoExtension
            2005-03-15 10:09:48,972 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.RisikoEntity] Foreign key constraint not added as requested: relationshipRolename=Risiko_hat_RisikoAttribut
            2005-03-15 10:09:48,972 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.RisikoEntity.findByPrimaryKey] SQL: SELECT RISIKO_ID, BEZIEHUNG_ART, RISIKO_NR, OFFERTE_NR, PLAN_NR, PRAEMIENACHRABATT, PRAEMIENACHBONUS, PRAEMIENACHSTEMPEL, RATENZUSCHLAG, STEMPELGEBUEHR, SVG_ZUSCHLAG, UVB_ZUSCHLAG, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID FROM TDVB_RISIKO WHERE RISIKO_ID=?
            2005-03-15 10:09:48,972 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.RisikoEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:48,982 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.DruckStatusEntity] Insert Entity SQL: INSERT INTO TDVB_DRUCK_STATUS (DRUCK_STATUS_ID, DRUCK_STATUS_NR, STATUS_NR, OFFERTE_NR, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:48,982 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.DruckStatusEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_DRUCK_STATUS WHERE DRUCK_STATUS_ID=?
            2005-03-15 10:09:48,982 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.DruckStatusEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:48,982 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.DruckStatusEntity] Remove SQL: DELETE FROM TDVB_DRUCK_STATUS WHERE DRUCK_STATUS_ID=?
            2005-03-15 10:09:48,982 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.DruckStatusEntity] Table not create as requested: TDVB_DRUCK_STATUS
            2005-03-15 10:09:48,982 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.DruckStatusEntity.findByPrimaryKey] SQL: SELECT DRUCK_STATUS_ID, DRUCK_STATUS_NR, STATUS_NR, OFFERTE_NR, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID FROM TDVB_DRUCK_STATUS WHERE DRUCK_STATUS_ID=?
            2005-03-15 10:09:48,982 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.DruckStatusEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,002 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.DeckungKategorieEntity] Insert Entity SQL: INSERT INTO TDVB_DECKUNG_KATEG (RISIKO_ID, DECKUNG_KAT_CODE, PRAEMIENACHRABATT, PRAEMIENACHBONUS, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:49,002 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.DeckungKategorieEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_DECKUNG_KATEG WHERE RISIKO_ID=? AND DECKUNG_KAT_CODE=?
            2005-03-15 10:09:49,002 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.DeckungKategorieEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,002 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.DeckungKategorieEntity] Remove SQL: DELETE FROM TDVB_DECKUNG_KATEG WHERE RISIKO_ID=? AND DECKUNG_KAT_CODE=?
            2005-03-15 10:09:49,002 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.DeckungKategorieEntity] Table not create as requested: TDVB_DECKUNG_KATEG
            2005-03-15 10:09:49,002 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.DeckungKategorieEntity] Foreign key constraint not added as requested: relationshipRolename=Risiko_hat_DeckungsKategorie
            2005-03-15 10:09:49,002 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.DeckungKategorieEntity.findByPrimaryKey] SQL: SELECT RISIKO_ID, DECKUNG_KAT_CODE, PRAEMIENACHRABATT, PRAEMIENACHBONUS, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID FROM TDVB_DECKUNG_KATEG WHERE RISIKO_ID=? AND DECKUNG_KAT_CODE=?
            2005-03-15 10:09:49,002 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.DeckungKategorieEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,032 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.StatusEntity] Insert Entity SQL: INSERT INTO TDVB_STATUS (OFFERTE_NR, STATUS_NR, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:49,032 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.StatusEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_STATUS WHERE OFFERTE_NR=? AND STATUS_NR=?
            2005-03-15 10:09:49,032 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.StatusEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,032 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.StatusEntity] Remove SQL: DELETE FROM TDVB_STATUS WHERE OFFERTE_NR=? AND STATUS_NR=?
            2005-03-15 10:09:49,032 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.StatusEntity] Table not create as requested: TDVB_STATUS
            2005-03-15 10:09:49,032 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.StatusEntity] Foreign key constraint not added as requested: relationshipRolename=Offerte_hat_Status
            2005-03-15 10:09:49,032 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.StatusEntity] Foreign key constraint not added as requested: relationshipRolename=Status_hat_DruckStatus
            2005-03-15 10:09:49,032 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.StatusEntity.findByPrimaryKey] SQL: SELECT OFFERTE_NR, STATUS_NR, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID FROM TDVB_STATUS WHERE OFFERTE_NR=? AND STATUS_NR=?
            2005-03-15 10:09:49,032 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.StatusEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,042 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.VersicherungsBedingungEntity] Insert Entity SQL: INSERT INTO TDVB_VERS_BED (RISIKO_ID, VERS_BED_CODE, VERS_BED_TYP, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:49,042 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.VersicherungsBedingungEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_VERS_BED WHERE RISIKO_ID=? AND VERS_BED_CODE=?
            2005-03-15 10:09:49,042 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.VersicherungsBedingungEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,042 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.VersicherungsBedingungEntity] Remove SQL: DELETE FROM TDVB_VERS_BED WHERE RISIKO_ID=? AND VERS_BED_CODE=?
            2005-03-15 10:09:49,042 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.VersicherungsBedingungEntity] Table not create as requested: TDVB_VERS_BED
            2005-03-15 10:09:49,042 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.VersicherungsBedingungEntity] Foreign key constraint not added as requested: relationshipRolename=Risiko_hat_VersicherungBedingung
            2005-03-15 10:09:49,042 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.VersicherungsBedingungEntity.findByPrimaryKey] SQL: SELECT RISIKO_ID, VERS_BED_CODE, VERS_BED_TYP, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID FROM TDVB_VERS_BED WHERE RISIKO_ID=? AND VERS_BED_CODE=?
            2005-03-15 10:09:49,042 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.VersicherungsBedingungEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,062 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.AdresseEntity] Insert Entity SQL: INSERT INTO TDVB_ADRESSE (Adresse_id, Partner_Nr, VVS_LAUFENDE_NR, ADRESSE_ZUSATZ, POSTFACH_WEILER, STRASSE, PHONETIK_SCHL_STR, PLZ, ORT, Kanton, Land, ADRESSE_TYP, ADR_GUELTIG_AB, ADR_GUELTIG_BIS, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:49,062 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.AdresseEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_ADRESSE WHERE Adresse_id=?
            2005-03-15 10:09:49,062 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.AdresseEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,062 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.AdresseEntity] Remove SQL: DELETE FROM TDVB_ADRESSE WHERE Adresse_id=?
            2005-03-15 10:09:49,062 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.AdresseEntity] Table not create as requested: TDVB_ADRESSE
            2005-03-15 10:09:49,062 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.AdresseEntity.findByPrimaryKey] SQL: SELECT Adresse_id FROM TDVB_ADRESSE WHERE Adresse_id=?
            2005-03-15 10:09:49,062 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.AdresseEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,082 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.KontaktEntity] Insert Entity SQL: INSERT INTO TDVB_KONTAKT (KONTAKT_ID, PARTNER_NR, OWNERSHIP_ID, KONTAKT_ART, KONTAKT_AB, KONTAKT_BIS, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:49,082 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.KontaktEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_KONTAKT WHERE KONTAKT_ID=?
            2005-03-15 10:09:49,082 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.KontaktEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,082 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.KontaktEntity] Remove SQL: DELETE FROM TDVB_KONTAKT WHERE KONTAKT_ID=?
            2005-03-15 10:09:49,082 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.KontaktEntity] Table not create as requested: TDVB_KONTAKT
            2005-03-15 10:09:49,082 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.KontaktEntity.findByPrimaryKey] SQL: SELECT KONTAKT_ID FROM TDVB_KONTAKT WHERE KONTAKT_ID=?
            2005-03-15 10:09:49,082 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.KontaktEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,112 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.PendenzEntity] Insert Entity SQL: INSERT INTO TDVB_PENDENZ (PENDENZ_ID, PARTNER_NR, BEZIEHUNG_NR, BEZIEHUNG_ART, KEY, OWNERSHIP_ID, BRANCHE, PENDENZ_STATUS, ZUSTAENDIG_ID, ZUSTAENDIG_TEAM, TERMIN_AB, TERMIN_BIS, VERFAULDATUM, PENDENZ_TYP, PRIORITAET, ERGEBNIS, KOMMENTAR, DATEINAME, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:49,112 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.PendenzEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_PENDENZ WHERE PENDENZ_ID=?
            2005-03-15 10:09:49,112 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.PendenzEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,112 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.PendenzEntity] Remove SQL: DELETE FROM TDVB_PENDENZ WHERE PENDENZ_ID=?
            2005-03-15 10:09:49,112 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.PendenzEntity] Table not create as requested: TDVB_PENDENZ
            2005-03-15 10:09:49,122 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.PendenzEntity.findByPrimaryKey] SQL: SELECT PENDENZ_ID FROM TDVB_PENDENZ WHERE PENDENZ_ID=?
            2005-03-15 10:09:49,122 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.PendenzEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,152 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.PartnerEntity] Insert Entity SQL: INSERT INTO TDVB_PARTNER (Partner_Nr, Beziehung_Art, Partner_Nr_Host, Partner_Art, Partner_Status, Name_1, Name_1_UCASE, PHONETIK_SCHL_NAME, Name_2, Name_2_UCASE, Anrede, SPRACHE, REKU, ABFRAGE_PER, Kommentar, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:49,152 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.PartnerEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_PARTNER WHERE Partner_Nr=?
            2005-03-15 10:09:49,152 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.PartnerEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,152 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.PartnerEntity] Remove SQL: DELETE FROM TDVB_PARTNER WHERE Partner_Nr=?
            2005-03-15 10:09:49,152 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.PartnerEntity] Table not create as requested: TDVB_PARTNER
            2005-03-15 10:09:49,152 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.PartnerEntity] Foreign key constraint not added as requested: relationshipRolename=Partner_hat_Kommunikation
            2005-03-15 10:09:49,152 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.PartnerEntity] Foreign key constraint not added as requested: relationshipRolename=Partner_hat_Adressen
            2005-03-15 10:09:49,152 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.PartnerEntity.findByPrimaryKey] SQL: SELECT Partner_Nr FROM TDVB_PARTNER WHERE Partner_Nr=?
            2005-03-15 10:09:49,152 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.PartnerEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,162 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.PartnerEntity.findByHostPK] EJB-QL: SELECT OBJECT(p) FROM Partner p WHERE p.partnerNrHost = ?1
            2005-03-15 10:09:49,442 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.PartnerEntity.findByHostPK] SQL: SELECT t0_p.Partner_Nr FROM TDVB_PARTNER t0_p WHERE t0_p.Partner_Nr_Host = ?
            2005-03-15 10:09:49,452 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RolleEntity] Insert Entity SQL: INSERT INTO TDVB_ROLLE (Beziehung_Nr, Beziehung_Art, Beteiligter_Nr, Beteiligter_Art, Rolle_Art, Ownership_ID, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:49,452 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RolleEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_ROLLE WHERE Beziehung_Nr=? AND Beziehung_Art=? AND Beteiligter_Nr=? AND Beteiligter_Art=? AND Rolle_Art=?
            2005-03-15 10:09:49,452 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.RolleEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,452 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.RolleEntity] Remove SQL: DELETE FROM TDVB_ROLLE WHERE Beziehung_Nr=? AND Beziehung_Art=? AND Beteiligter_Nr=? AND Beteiligter_Art=? AND Rolle_Art=?
            2005-03-15 10:09:49,462 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.RolleEntity] Table not create as requested: TDVB_ROLLE
            2005-03-15 10:09:49,462 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.RolleEntity.findByPrimaryKey] SQL: SELECT Beziehung_Nr, Beziehung_Art, Beteiligter_Nr, Beteiligter_Art, Rolle_Art FROM TDVB_ROLLE WHERE Beziehung_Nr=? AND Beziehung_Art=? AND Beteiligter_Nr=? AND Beteiligter_Art=? AND Rolle_Art=?
            2005-03-15 10:09:49,462 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.RolleEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,523 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.DeckungEntity] Insert Entity SQL: INSERT INTO TDVB_DECKUNG (RISIKO_ID, DECKUNG_KAT_CODE, DECKUNG_CODE, SPEZ_PRAEMIE_JN, BEZIEHUNG_NR, BEZIEHUNG_ART, TARIFDATUM, UMSCHREIBUNG_CODE, SISTIERUNG_JN, SELBSTBEHALTVARIA, BONUSSTUFENSYSTEM, BONUSSTUFE, BONUSSTUFE_INTERN, ENTSCHAEDIGUNG_ART, BASISPRAEMIE_1, BASISPRAEMIE_2, PRAEMIENACHSCORING, PRAEMIENACHRABATT, PRAEMIENACHBONUS, PRAEMIENACHSTEMPEL, VERS_SUMME_CODE, VERS_SUMME_BETRAG, MAN_BASISPRAEMIE, EINHEIT_1, WERT_1, EINHEIT_2, WERT_2, EINHEIT_3, WERT_3, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:49,523 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.DeckungEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_DECKUNG WHERE RISIKO_ID=? AND DECKUNG_KAT_CODE=? AND DECKUNG_CODE=?
            2005-03-15 10:09:49,523 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.DeckungEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,523 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.DeckungEntity] Remove SQL: DELETE FROM TDVB_DECKUNG WHERE RISIKO_ID=? AND DECKUNG_KAT_CODE=? AND DECKUNG_CODE=?
            2005-03-15 10:09:49,523 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.DeckungEntity] Table not create as requested: TDVB_DECKUNG
            2005-03-15 10:09:49,523 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.DeckungEntity] Foreign key constraint not added as requested: relationshipRolename=DeckungsKategorie_hat_Deckung
            2005-03-15 10:09:49,523 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.DeckungEntity.findByPrimaryKey] SQL: SELECT RISIKO_ID, DECKUNG_KAT_CODE, DECKUNG_CODE, SPEZ_PRAEMIE_JN, BEZIEHUNG_NR, BEZIEHUNG_ART, TARIFDATUM, UMSCHREIBUNG_CODE, SISTIERUNG_JN, SELBSTBEHALTVARIA, BONUSSTUFENSYSTEM, BONUSSTUFE, BONUSSTUFE_INTERN, ENTSCHAEDIGUNG_ART, BASISPRAEMIE_1, BASISPRAEMIE_2, PRAEMIENACHSCORING, PRAEMIENACHRABATT, PRAEMIENACHBONUS, PRAEMIENACHSTEMPEL, VERS_SUMME_CODE, VERS_SUMME_BETRAG, MAN_BASISPRAEMIE, EINHEIT_1, WERT_1, EINHEIT_2, WERT_2, EINHEIT_3, WERT_3, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID FROM TDVB_DECKUNG WHERE RISIKO_ID=? AND DECKUNG_KAT_CODE=? AND DECKUNG_CODE=?
            2005-03-15 10:09:49,523 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.DeckungEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,533 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.NatPartnerEntity] Insert Entity SQL: INSERT INTO TDVB_NAT_PARTNER (PARTNER_NR, TITEL, Geschlecht, Geburtsdatum, Zivilstand, Nationalitaet, AUFENTHALTSBEW, IN_CH_SEIT, Beruf) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:49,533 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.NatPartnerEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_NAT_PARTNER WHERE PARTNER_NR=?
            2005-03-15 10:09:49,533 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.NatPartnerEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,533 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.NatPartnerEntity] Remove SQL: DELETE FROM TDVB_NAT_PARTNER WHERE PARTNER_NR=?
            2005-03-15 10:09:49,543 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.NatPartnerEntity] Table not create as requested: TDVB_NAT_PARTNER
            2005-03-15 10:09:49,543 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.NatPartnerEntity.findByPrimaryKey] SQL: SELECT PARTNER_NR FROM TDVB_NAT_PARTNER WHERE PARTNER_NR=?
            2005-03-15 10:09:49,543 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.NatPartnerEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,563 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.FuehrerausweisEntity] Insert Entity SQL: INSERT INTO TDVB_FUEAUSWEIS (Partner_Nr, Kategorie, Ausweis_seit, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:49,563 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.FuehrerausweisEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_FUEAUSWEIS WHERE Partner_Nr=? AND Kategorie=?
            2005-03-15 10:09:49,563 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.FuehrerausweisEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,563 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.FuehrerausweisEntity] Remove SQL: DELETE FROM TDVB_FUEAUSWEIS WHERE Partner_Nr=? AND Kategorie=?
            2005-03-15 10:09:49,563 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.FuehrerausweisEntity] Table not create as requested: TDVB_FUEAUSWEIS
            2005-03-15 10:09:49,563 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.FuehrerausweisEntity] Foreign key constraint not added as requested: relationshipRolename=Partner_hat_Führerausweis
            2005-03-15 10:09:49,563 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.FuehrerausweisEntity.findByPrimaryKey] SQL: SELECT Partner_Nr, Kategorie FROM TDVB_FUEAUSWEIS WHERE Partner_Nr=? AND Kategorie=?
            2005-03-15 10:09:49,563 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.FuehrerausweisEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,593 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.NachweisEntity] Insert Entity SQL: INSERT INTO TDVB_NACHWEIS (NACHWEIS_ID, GESELLSCHAFTSCODE, GUELTIG_AB, GUELTIG_BIS, HALTER_ID, HALTER, HALTER_NAT, HALTER_GEBDAT, EMPFAENGER_ID, EMPFAENGER, FAHRZEUGART, FAHRZEUGMARKE, FAHRZEUGTYP, KONTROLLSCHILD, FAHRGESTELL_NR, STAMM_NR, STANDORT_FZG, WECHSELSCHILD_JN, ERSATZFAHRZEUG_JN, SITZPLAETZE, OFFERTE_NR, POLICE_NR, IV_GRUND, NACHWEISSTATUS, OWNERSHIP_ID, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:49,593 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.NachweisEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_NACHWEIS WHERE NACHWEIS_ID=?
            2005-03-15 10:09:49,593 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.NachweisEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,593 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.NachweisEntity] Remove SQL: DELETE FROM TDVB_NACHWEIS WHERE NACHWEIS_ID=?
            2005-03-15 10:09:49,593 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.NachweisEntity] Table not create as requested: TDVB_NACHWEIS
            2005-03-15 10:09:49,593 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.NachweisEntity.findByPrimaryKey] SQL: SELECT NACHWEIS_ID FROM TDVB_NACHWEIS WHERE NACHWEIS_ID=?
            2005-03-15 10:09:49,593 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.NachweisEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,613 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.KontoVerbindungEntity] Insert Entity SQL: INSERT INTO TDVB_BANKVERB (Bankverbindung_Id, Partner_Nr, VVS_LAUFENDE_NR, KONTO_ART, Institutname, Konto_Nr, KREDITKARTE_ART, Clearing_Nr, Postcheck_nr_Bank, GUELTIG_BIS, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:49,613 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.KontoVerbindungEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_BANKVERB WHERE Bankverbindung_Id=?
            2005-03-15 10:09:49,613 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.KontoVerbindungEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,613 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.KontoVerbindungEntity] Remove SQL: DELETE FROM TDVB_BANKVERB WHERE Bankverbindung_Id=?
            2005-03-15 10:09:49,613 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.KontoVerbindungEntity] Table not create as requested: TDVB_BANKVERB
            2005-03-15 10:09:49,613 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.KontoVerbindungEntity] Foreign key constraint not added as requested: relationshipRolename=Partner_hat_Kontoverbindungen
            2005-03-15 10:09:49,613 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.KontoVerbindungEntity.findByPrimaryKey] SQL: SELECT Bankverbindung_Id FROM TDVB_BANKVERB WHERE Bankverbindung_Id=?
            2005-03-15 10:09:49,613 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.KontoVerbindungEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,633 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.InternetOfferteEntity] Insert Entity SQL: INSERT INTO TDVB_INTERNET_OFF (INTERNET_OFF_ID, MANDANT_ID, GENERALAGENTUR, HAUPTAGENTUR, AGENT, BRANCHE, PLAN_NR, REFERENZ_NR, REFERENZFOLGE_NR, INT_OFF_STATUS, NAME, VORNAME, PLZ, ORT, GEBURTSDATUM, SPRACHE, ZUTEILUNG, ZUSTAENDIG_ID, ZUSTAENDIG_TEAM, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID, XML_FILE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:49,633 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.InternetOfferteEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_INTERNET_OFF WHERE INTERNET_OFF_ID=?
            2005-03-15 10:09:49,643 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.InternetOfferteEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,643 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.InternetOfferteEntity] Remove SQL: DELETE FROM TDVB_INTERNET_OFF WHERE INTERNET_OFF_ID=?
            2005-03-15 10:09:49,643 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.InternetOfferteEntity] Table not create as requested: TDVB_INTERNET_OFF
            2005-03-15 10:09:49,643 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.InternetOfferteEntity.findByPrimaryKey] SQL: SELECT INTERNET_OFF_ID FROM TDVB_INTERNET_OFF WHERE INTERNET_OFF_ID=?
            2005-03-15 10:09:49,643 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.InternetOfferteEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,673 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.KontakteintragEntity] Insert Entity SQL: INSERT INTO TDVB_KONTAKTEINTR (KONTAKT_ID, TRANSAKTION_ID, TRANSAKTION, TRANSAKTION_ART, TRANSAKT_BEZ_NR, TRANSAKT_BEZ_ART, TRANSAKTION_AB, TRANSAKTION_BIS, TRANSAKT_ERGEBNIS, TRANSAKT_DAUER, KOMMENTAR, BRANCHE, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:49,673 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.KontakteintragEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_KONTAKTEINTR WHERE KONTAKT_ID=? AND TRANSAKTION_ID=?
            2005-03-15 10:09:49,673 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.KontakteintragEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,673 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.KontakteintragEntity] Remove SQL: DELETE FROM TDVB_KONTAKTEINTR WHERE KONTAKT_ID=? AND TRANSAKTION_ID=?
            2005-03-15 10:09:49,673 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.KontakteintragEntity] Table not create as requested: TDVB_KONTAKTEINTR
            2005-03-15 10:09:49,673 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.KontakteintragEntity] Foreign key constraint not added as requested: relationshipRolename=Kontakt_hat_Kontakteinträge
            2005-03-15 10:09:49,673 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.KontakteintragEntity.findByPrimaryKey] SQL: SELECT KONTAKT_ID, TRANSAKTION_ID FROM TDVB_KONTAKTEINTR WHERE KONTAKT_ID=? AND TRANSAKTION_ID=?
            2005-03-15 10:09:49,683 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.KontakteintragEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,693 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.VvsTransaktionEntity] Insert Entity SQL: INSERT INTO TDVB_VVS_TRANSAKT (VVS_TRANSAKTION_ID, POLICE_NR, VA_TRANSAKTION, GRUND, ARCHIV_ART, VERARBEITUNG_CODE, VA_DATUM, PARTNER_NR, Erstellungsdatum, Erstellung_Id, Aenderungsdatum, Aenderung_Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            2005-03-15 10:09:49,693 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.VvsTransaktionEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_VVS_TRANSAKT WHERE VVS_TRANSAKTION_ID=?
            2005-03-15 10:09:49,693 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.VvsTransaktionEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,693 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.VvsTransaktionEntity] Remove SQL: DELETE FROM TDVB_VVS_TRANSAKT WHERE VVS_TRANSAKTION_ID=?
            2005-03-15 10:09:49,693 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.VvsTransaktionEntity] Table not create as requested: TDVB_VVS_TRANSAKT
            2005-03-15 10:09:49,693 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.VvsTransaktionEntity.findByPrimaryKey] SQL: SELECT VVS_TRANSAKTION_ID FROM TDVB_VVS_TRANSAKT WHERE VVS_TRANSAKTION_ID=?
            2005-03-15 10:09:49,693 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.VvsTransaktionEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,693 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.VvsTransaktionEntity.findByPoliceNr] EJB-QL: SELECT OBJECT(v) from VvsTransaktion v WHERE v.policeNr = ?1
            2005-03-15 10:09:49,693 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.VvsTransaktionEntity.findByPoliceNr] SQL: SELECT t0_v.VVS_TRANSAKTION_ID FROM TDVB_VVS_TRANSAKT t0_v WHERE t0_v.POLICE_NR = ?
            2005-03-15 10:09:49,693 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RollenbeziehungEntity] Insert Entity SQL: INSERT INTO TDVB_ROLLENBEZ (Beziehung_Nr, Beziehung_Art) VALUES (?, ?)
            2005-03-15 10:09:49,693 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RollenbeziehungEntity] Entity Exists SQL: SELECT COUNT(*) FROM TDVB_ROLLENBEZ WHERE Beziehung_Nr=? AND Beziehung_Art=?
            2005-03-15 10:09:49,693 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.RollenbeziehungEntity] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
            2005-03-15 10:09:49,693 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.RollenbeziehungEntity] Remove SQL: DELETE FROM TDVB_ROLLENBEZ WHERE Beziehung_Nr=? AND Beziehung_Art=?
            2005-03-15 10:09:49,693 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.RollenbeziehungEntity] Table not create as requested: TDVB_ROLLENBEZ
            2005-03-15 10:09:49,693 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.RollenbeziehungEntity.findByPrimaryKey] SQL: SELECT Beziehung_Nr, Beziehung_Art FROM TDVB_ROLLENBEZ WHERE Beziehung_Nr=? AND Beziehung_Art=?
            2005-03-15 10:09:49,693 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.RollenbeziehungEntity] Added findByPrimaryKey query command for local home interface
            2005-03-15 10:09:49,693 INFO [org.jboss.ejb.plugins.EntityInstancePool] Starting
            2005-03-15 10:09:49,693 INFO [org.jboss.ejb.plugins.EntityInstancePool] Started
            
            


            • 3. Re: jboss-4.0.1 startup slow (Entitybean SQL generation prob
              helly15

              Any suggestions? Alexey maybe?

              Thanks,
              Peter

              • 4. Re: jboss-4.0.1 startup slow (Entitybean SQL generation prob
                triathlon98

                Have you tried increasing the amount of memory which is available for your jboss instance (see startup files).

                Joachim

                • 5. Re: jboss-4.0.1 startup slow (Entitybean SQL generation prob
                  helly15


                  Hi Joachim,

                  thank you for your suggestion, I have set the JVM memory allocation pool parameters to -Xms128m and -Xmx768m ( was -Xmx512m before),
                  bit it did not help: startup time 12m:18s


                  15:16:19,470 INFO [Server] JBoss (MX MicroKernel) [4.0.1sp1 (build: CVSTag=JBoss_4_0_1_SP1 date=200502160314)] Started in 12m:18s:662ms


                  Best regards,
                  Peter

                  • 6. Re: jboss-4.0.1 startup slow (Entitybean SQL generation prob
                    starksm64

                    Grab a profiler and create a bug report in jira(http://jira.jboss.com) with the results. Two good profilers:

                    http://www.ej-technologies.com/products/jprofiler/overview.html
                    http://www.yourkit.com/home/index.jsp

                    • 7. Re: jboss-4.0.1 startup slow (Entitybean SQL generation prob
                      nicolas

                      Concerning this issue, a bug report has just been posted, please see:
                      http://jira.jboss.com/jira/browse/JBAS-1941

                      Nicolas