-
1. Re: jboss-4.0.1 startup slow (Entitybean SQL generation prob
helly15 Mar 14, 2005 12:58 PM (in response to 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,
Peter2005-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 Mar 15, 2005 4:48 AM (in response to 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,
peter2005-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 Mar 16, 2005 8:54 AM (in response to helly15)Any suggestions? Alexey maybe?
Thanks,
Peter -
4. Re: jboss-4.0.1 startup slow (Entitybean SQL generation prob
triathlon98 Mar 17, 2005 8:00 AM (in response to helly15)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 Mar 17, 2005 9:29 AM (in response to 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:18s15: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 Mar 17, 2005 10:43 AM (in response to helly15)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 Jun 23, 2005 2:28 AM (in response to helly15)Concerning this issue, a bug report has just been posted, please see:
http://jira.jboss.com/jira/browse/JBAS-1941
Nicolas