Hi,
thank you for this great software product.
Also I#ve studied the hibernate forum and done a lot of reading in your book, I'm facing the problem described by the stacktrace.
I'm unable to do an many-to-many with composite element mapping.
I don't know what's wrong with my mapping, so a hint would be appreciated, and probably you should consider clarifying this in the next version of the book...
Thanks in advance
Mark
Hibernate version:2.1.3
Mapping documents: <?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping> <class name="com.siemens.persistent.Editor" table="Bearbeiter" dynamic-update="false" dynamic-insert="false" >
<id name="id" column="Nr" type="java.lang.Long" > <generator class="increment"> </generator> </id>
<property name="email" type="java.lang.String" update="true" insert="true" column="EmailAdr" length="64" not-null="true" unique="true" />
<property name="firstName" type="java.lang.String" update="true" insert="true" column="Vorname" length="32" not-null="true" />
<property name="lastName" type="java.lang.String" update="true" insert="true" column="Name" length="32" not-null="true" />
<property name="phone" type="java.lang.String" update="true" insert="true" column="Telefon" length="32" />
<property name="password" type="java.lang.String" update="true" insert="true" column="Passwort" length="16" not-null="true" />
<property name="departement" type="java.lang.String" update="true" insert="true" column="Abteilung" length="32" />
<set name="groups" table="EditorGruppeMapping" lazy="false" inverse="false" cascade="none" sort="unsorted" >
<key column="fk_Editor" />
<composite-element class="com.siemens.persistent.usermanagement.EditorToGroup" >
<property name="editorName" type="java.lang.String" update="true" insert="true" column="email" length="64" not-null="true" />
<property name="groupName" type="java.lang.String" update="true" insert="true" column="groupName" not-null="true" />
</composite-element>
</set>
<!-- To add non XDoclet property mappings, create a file named hibernate-properties-Editor.xml containing the additional properties and place it in your merge dir. -->
</class>
</hibernate-mapping>
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping> <class name="com.siemens.persistent.usermanagement.Group" table="Gruppe" dynamic-update="false" dynamic-insert="false" >
<id name="id" column="Nr" type="java.lang.Long" > <generator class="increment"> </generator> </id>
<set name="users" table="EditorGruppeMapping" lazy="false" inverse="true" cascade="none" sort="unsorted" >
<key column="fk_Group" />
<many-to-many class="com.siemens.persistent.Editor" column="fk_Editor" outer-join="auto" />
</set>
<property name="name" type="java.lang.String" update="true" insert="true" column="Name" />
<!-- To add non XDoclet property mappings, create a file named hibernate-properties-Group.xml containing the additional properties and place it in your merge dir. -->
</class>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close(): Session s = HibernateManager.getInstance().getSession(); g= new Group("MyGroup"); e = new Editor("MyEmail@email.org", "MyPassword", "MyForename", "MySurname", "MyPhonenumber", "MyDepartement"); s.save(e); s.save(g); // Need to save the persistent objects before modifying the collections // because the id will be generated o nsave and the id value is taken for haschCode // generation during hibernates storing in the Sets HashSet set = new HashSet(); set.add(g); e.setGroups(set); EditorToGroup etg = new EditorToGroup(e.getEmail(), g.getName()); e.getGroups().add(etg); g.setUsers(new HashSet()); g.getUsers().add(etg); s.update(e); s.update(g); s.flush(); s.close(); // assertTrue(group.getUsers().contains(editor)); // assertTrue(e.getGroups().contains(etg)); } catch (HibernateException e) { e.printStackTrace(); }
Full stack trace of any exception that occurs: et.sf.hibernate.PropertyAccessException: IllegalArgumentException occurred calling getter of com.siemens.persistent.usermanagement.EditorToGroup.editorName at net.sf.hibernate.property.BasicPropertyAccessor$BasicGetter.get(BasicPropertyAccessor.java:110) at net.sf.hibernate.type.ComponentType.getPropertyValue(ComponentType.java:179) at net.sf.hibernate.type.ComponentType.getPropertyValues(ComponentType.java:205) at net.sf.hibernate.type.ComponentType.nullSafeGetValues(ComponentType.java:164) at net.sf.hibernate.type.ComponentType.nullSafeSet(ComponentType.java:151) at net.sf.hibernate.collection.AbstractCollectionPersister.writeElement(AbstractCollectionPersister.java:384) at net.sf.hibernate.collection.Set.writeTo(Set.java:226) at net.sf.hibernate.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:523) at net.sf.hibernate.impl.ScheduledCollectionRecreate.execute(ScheduledCollectionRecreate.java:23) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2407) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2364) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2229) at com.siemens.persistent.usermanagement.TestEditorGroupMapping.testAddUserToGroup(TestEditorGroupMapping.java:64) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at junit.framework.TestCase.runTest(TestCase.java:154) at junit.framework.TestCase.runBare(TestCase.java:127) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:421) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:305) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:186) Caused by: java.lang.IllegalArgumentException: object is not an instance of declaring class at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at net.sf.hibernate.property.BasicPropertyAccessor$BasicGetter.get(BasicPropertyAccessor.java:96) ... 27 more net.sf.hibernate.PropertyAccessException: IllegalArgumentException occurred calling getter of com.siemens.persistent.usermanagement.EditorToGroup.editorName at net.sf.hibernate.property.BasicPropertyAccessor$BasicGetter.get(BasicPropertyAccessor.java:110) at net.sf.hibernate.type.ComponentType.getPropertyValue(ComponentType.java:179) at net.sf.hibernate.type.ComponentType.getPropertyValues(ComponentType.java:205) at net.sf.hibernate.type.ComponentType.nullSafeGetValues(ComponentType.java:164) at net.sf.hibernate.type.ComponentType.nullSafeSet(ComponentType.java:151) at net.sf.hibernate.collection.AbstractCollectionPersister.writeElement(AbstractCollectionPersister.java:384) at net.sf.hibernate.collection.Set.writeTo(Set.java:226) at net.sf.hibernate.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:523) at net.sf.hibernate.impl.ScheduledCollectionRecreate.execute(ScheduledCollectionRecreate.java:23) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2407) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2364) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2229) at com.siemens.persistent.usermanagement.TestEditorGroupMapping.testAddUserToGroup(TestEditorGroupMapping.java:64) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at junit.framework.TestCase.runTest(TestCase.java:154) at junit.framework.TestCase.runBare(TestCase.java:127) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:421) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:305) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:186) Caused by: java.lang.IllegalArgumentException: object is not an instance of declaring class at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at net.sf.hibernate.property.BasicPropertyAccessor$BasicGetter.get(BasicPropertyAccessor.java:96) ... 27 more
Name and version of the database you are using: MySql 4.0.20
The generated SQL (show_sql=true): cfg.Environment 462 ) Hibernate 2.1.3 (cfg.Environment 491 ) hibernate.properties not found (cfg.Environment 519 ) using CGLIB reflection optimizer (cfg.Configuration 872 ) configuring from resource: /hibernate.cfg.xml (cfg.Configuration 844 ) Configuration resource: /hibernate.cfg.xml (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/Category.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.Category -> Kategorie (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/DescribingElement.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.DescribingElement -> GrafikContainer (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/DescribingElementContainer.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.DescribingElementContainer -> SNRGrafikContainerListe (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/Image.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.Image -> Bilder (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/Locale.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.Locale -> Sprache (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/Text.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.Text -> Texte (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/TextValue.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.TextValue -> RohTexte (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/Accessory.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.Accessory -> Sachnummern (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/Editor.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.Editor -> Bearbeiter (cfg.Binder 560 ) Mapping collection: com.siemens.persistent.Editor.groups -> EditorGruppeMapping (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/product/MainPartDefinition.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.product.MainPartDefinition -> AbschnittDefinitionen (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/product/PartType.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.product.PartType -> PartTypen (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/product/Product.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.product.Product -> Produkte (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/product/SubPartDefinition.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.product.SubPartDefinition -> PartDefinitionen (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/product/SubPartListEntries.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.product.SubPartListEntries -> PartAuswahlListen (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/usermanagement/Group.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.usermanagement.Group -> Gruppe (cfg.Binder 560 ) Mapping collection: com.siemens.persistent.usermanagement.Group.users -> EditorGruppeMapping (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/Country.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.Country -> Land (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/Customer.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.Customer -> Kunde (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/Template.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.Template -> Template (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/Status.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.Status -> Status (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/variant/Variant.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.variant.Variant -> Varianten_Definition (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/variant/MainPart.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.variant.MainPart -> Abschnitt (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/variant/SubPartListEntryValue.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.variant.SubPartListEntryValue -> Parts (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/pidocument/PiDocument.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.pidocument.PiDocument -> PiDokument (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/pidocument/PiDocumentElement.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.pidocument.PiDocumentElement -> SNrGenerierFolgen (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/pidocument/GenerationError.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.pidocument.GenerationError -> GenerierFehler (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/report/Report.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.report.Report -> Ansicht (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/report/ReportableAttribute.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.report.ReportableAttribute -> ReportAttribut (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/report/ReportableAttributeFilterValue.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.report.ReportableAttributeFilterValue -> AttributFilterWerte (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/news/NewsEntry.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.news.NewsEntry -> News (cfg.Configuration 328 ) Mapping resource: com/siemens/persistent/report/ReportCategory.hbm.xml (cfg.Binder 229 ) Mapping class: com.siemens.persistent.report.ReportCategory -> ReportKategorie (cfg.Configuration 1030) Configured SessionFactory: null (cfg.Configuration 613 ) processing one-to-many association mappings (cfg.Binder 1168) Mapping collection: com.siemens.persistent.Text.textValues -> RohTexte (cfg.Binder 1168) Mapping collection: com.siemens.persistent.Accessory.describingElementContainers -> SNRGrafikContainerListe (util.ReflectHelper 176 ) reflection optimizer disabled for: com.siemens.persistent.usermanagement.EditorToGroup, IllegalArgumentException: Cannot find matching method/constructor (cfg.Binder 1168) Mapping collection: com.siemens.persistent.product.MainPartDefinition.subPartDefinitions -> PartDefinitionen (cfg.Binder 1168) Mapping collection: com.siemens.persistent.product.Product.mainPartDefinitions -> AbschnittDefinitionen (cfg.Binder 1168) Mapping collection: com.siemens.persistent.product.SubPartDefinition.subPartListEntries -> PartAuswahlListen (cfg.Binder 1168) Mapping collection: com.siemens.persistent.variant.Variant.mainParts -> Abschnitt (cfg.Binder 1168) Mapping collection: com.siemens.persistent.variant.MainPart.subPartListEntryValues -> Parts (cfg.Binder 1168) Mapping collection: com.siemens.persistent.pidocument.PiDocument.errors -> GenerierFehler (cfg.Binder 1168) Mapping collection: com.siemens.persistent.pidocument.PiDocument.piDocumentElements -> SNrGenerierFolgen (cfg.Binder 1168) Mapping collection: com.siemens.persistent.report.Report.reportableAttributeFilterValues -> AttributFilterWerte (cfg.Configuration 622 ) processing one-to-one association property references (cfg.Configuration 647 ) processing foreign key constraints (dialect.Dialect 82 ) Using dialect: net.sf.hibernate.dialect.MySQLDialect (cfg.SettingsFactory 62 ) Use outer join fetching: true (connection.DriverManagerConnectionProvider 42 ) Using Hibernate built-in connection pool (not for production use!) (connection.DriverManagerConnectionProvider 43 ) Hibernate connection pool size: 0 (connection.DriverManagerConnectionProvider 77 ) using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/siemens_vcpi (connection.DriverManagerConnectionProvider 78 ) connection properties: {user=mad, password=mad} (transaction.TransactionFactoryFactory 31 ) Transaction strategy: net.sf.hibernate.transaction.JDBCTransactionFactory (transaction.TransactionManagerLookupFactory 33 ) No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended) (cfg.SettingsFactory 102 ) Use scrollable result sets: true (cfg.SettingsFactory 105 ) Use JDBC3 getGeneratedKeys(): true (cfg.SettingsFactory 108 ) Optimize cache for minimal puts: false (cfg.SettingsFactory 114 ) echoing all SQL to stdout (cfg.SettingsFactory 117 ) Query language substitutions: {true=1, false=0} (cfg.SettingsFactory 128 ) cache provider: net.sf.hibernate.cache.HashtableCacheProvider (cfg.Configuration 1093) instantiating and configuring caches (impl.SessionFactoryImpl 119 ) building session factory (impl.SessionFactoryObjectFactory 82 ) no JNDI name configured (dialect.Dialect 82 ) Using dialect: net.sf.hibernate.dialect.MySQLDialect (connection.DriverManagerConnectionProvider 42 ) Using Hibernate built-in connection pool (not for production use!) (connection.DriverManagerConnectionProvider 43 ) Hibernate connection pool size: 0 (connection.DriverManagerConnectionProvider 77 ) using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/siemens_vcpi (connection.DriverManagerConnectionProvider 78 ) connection properties: {user=mad, password=mad} (hbm2ddl.SchemaUpdate 102 ) Running hbm2ddl schema update (hbm2ddl.SchemaUpdate 110 ) fetching database metadata (hbm2ddl.SchemaUpdate 124 ) updating schema (cfg.Configuration 613 ) processing one-to-many association mappings (cfg.Configuration 622 ) processing one-to-one association property references (cfg.Configuration 647 ) processing foreign key constraints (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table Bilder add index (KategoryNr), add constraint FK769A190C6664E47A foreign key (KategoryNr) references Kategorie (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table PiDokument add index (variantId), add constraint FK6BE2DB4CFB1B0C80 foreign key (variantId) references Varianten_Definition (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table PiDokument add index (ErstellerId), add constraint FK6BE2DB4C34610D1F foreign key (ErstellerId) references Bearbeiter (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table RohTexte add index (TextNr), add constraint FKEC3B81ED951EA3F1 foreign key (TextNr) references Texte (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table RohTexte add index (SpracheNr), add constraint FKEC3B81EDBE63F898 foreign key (SpracheNr) references Sprache (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table GenerierFehler add index (PiDocumentNr), add constraint FK6B1A7929BF8FDB38 foreign key (PiDocumentNr) references PiDokument (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table PartDefinitionen add index (PartTypNr), add constraint FK41B7E0EFB05A15C foreign key (PartTypNr) references PartTypen (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table PartDefinitionen add index (AbschnittsDefinitionId), add constraint FK41B7E0EFDED2B0EF foreign key (AbschnittsDefinitionId) references AbschnittDefinitionen (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table Varianten_Definition add index (ProduktId), add constraint FKACDBEA8438C41942 foreign key (ProduktId) references Produkte (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table Varianten_Definition add index (KundenNr), add constraint FKACDBEA845D970D0D foreign key (KundenNr) references Kunde (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table Varianten_Definition add index (LandNr), add constraint FKACDBEA84873AB92F foreign key (LandNr) references Land (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table Varianten_Definition add index (LocalPmNr), add constraint FKACDBEA842F9A528C foreign key (LocalPmNr) references Bearbeiter (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table Varianten_Definition add index (Aussteller), add constraint FKACDBEA8433462D2 foreign key (Aussteller) references Bearbeiter (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table Varianten_Definition add index (textNr), add constraint FKACDBEA84CBB9B7D1 foreign key (textNr) references Texte (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table Ansicht add index (Kategorie), add constraint FK30AFEA6C76EA791F foreign key (Kategorie) references ReportKategorie (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table Parts add index (PartAuswahlNr), add constraint FK4952AC025AF5C5E foreign key (PartAuswahlNr) references PartAuswahlListen (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table Parts add index (AbschnittNr), add constraint FK4952AC0583C2B96 foreign key (AbschnittNr) references Abschnitt (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table Parts add index (PartDefinitionNr), add constraint FK4952AC041B7DE2A foreign key (PartDefinitionNr) references PartDefinitionen (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table AbschnittDefinitionen add index (ProductNr), add constraint FK4F27B88E38C076F3 foreign key (ProductNr) references Produkte (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table GrafikContainer add index (TextbausteinUntenLinksNr), add constraint FK7C7EA10FF98F2439 foreign key (TextbausteinUntenLinksNr) references Texte (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table GrafikContainer add index (TextbausteinMitteNr), add constraint FK7C7EA10F6F593A0D foreign key (TextbausteinMitteNr) references Texte (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table GrafikContainer add index (TextbausteinObenRechtsNr), add constraint FK7C7EA10F7A1480B7 foreign key (TextbausteinObenRechtsNr) references Texte (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table GrafikContainer add index (TextbausteinObenLinksNr), add constraint FK7C7EA10FACF239A1 foreign key (TextbausteinObenLinksNr) references Texte (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table GrafikContainer add index (BildNr), add constraint FK7C7EA10F769A1643 foreign key (BildNr) references Bilder (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table GrafikContainer add index (TextbausteinUntenRechtsNr), add constraint FK7C7EA10FC114E91F foreign key (TextbausteinUntenRechtsNr) references Texte (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table AttributFilterWerte add index (AnsichtNr), add constraint FK48784174C45F0950 foreign key (AnsichtNr) references Ansicht (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table AttributFilterWerte add index (ReportAttributNr), add constraint FK4878417463DE2B01 foreign key (ReportAttributNr) references ReportAttribut (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table SNRGrafikContainerListe add index (SachnummerNr), add constraint FK9049538F2D9E69CB foreign key (SachnummerNr) references Sachnummern (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table SNRGrafikContainerListe add index (GrafikContainer), add constraint FK9049538F7C7EA10F foreign key (GrafikContainer) references GrafikContainer (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table Produkte add index (LeadPMNr), add constraint FKC806537E60DB7E1D foreign key (LeadPMNr) references Bearbeiter (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table PartAuswahlListen add index (PartDefinitionNr), add constraint FKC81B7F6141B7DE2A foreign key (PartDefinitionNr) references PartDefinitionen (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table Abschnitt add index (Abschnitte), add constraint FKDBDCE6329FBFE073 foreign key (Abschnitte) references Varianten_Definition (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table SNrGenerierFolgen add index (PiDocumentId), add constraint FK50E3081DBF8FDA8F foreign key (PiDocumentId) references PiDokument (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 138 ) Unsuccessful: alter table SNrGenerierFolgen add index (SachNr), add constraint FK50E3081D9327B477 foreign key (SachNr) references Sachnummern (Nr) (hbm2ddl.SchemaUpdate 139 ) Invalid argument value, message from server: "Too many keys specified. Max 32 keys allowed" (hbm2ddl.SchemaUpdate 143 ) schema update complete (connection.DriverManagerConnectionProvider 143 ) cleaning up connection pool: jdbc:mysql://localhost/siemens_vcpi Hibernate: select this.Nr as Nr0_, this.EmailAdr as EmailAdr0_, this.Vorname as Vorname0_, this.Name as Name0_, this.Telefon as Telefon0_, this.Passwort as Passwort0_, this.Abteilung as Abteilung0_ from Bearbeiter this where 1=1 Hibernate: select groups0_.email as email__, groups0_.groupName as groupName__, groups0_.fk_Editor as fk_Editor__ from EditorGruppeMapping groups0_ where groups0_.fk_Editor=? Hibernate: delete from Bearbeiter where Nr=? Hibernate: insert into Bearbeiter (EmailAdr, Vorname, Name, Telefon, Passwort, Abteilung, Nr) values (?, ?, ?, ?, ?, ?, ?) Hibernate: insert into Gruppe (Name, Nr) values (?, ?) Hibernate: insert into EditorGruppeMapping (fk_Editor, email, groupName) values (?, ?, ?)
Debug level Hibernate log excerpt:
|