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