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