After adding a one to many relationship in the mapping file (from StoreMaster to child PurchaseOrder) I get the following error:

net.sf.hibernate.JDBCException: could not initialize collection: [StoreMaster.purchaseOrders#132680-C]

This is the xml:

<class name="StoreMaster" table="store_master">
<id name="stockNumber" column="stock_number" type="string" unsaved-value="null">
<generator class="hilo"/>
</id>
<property name="description" column="description"/>
<set name="purchaseOrders" cascade="all" inverse="true">
<key column="stock_number"/>
<one-to-many class="PurchaseOrder"/>
</set>
</class>


<class name="PurchaseOrder" table="purchase_order">
<id name="uniqueKey" column="unique_key" type="long" unsaved-value="null">
<generator class="hilo"/>
</id>
<property name="orderNumber" column="order_number"/>
<property name="lineNumber" column="line_number"/>
<property name="subLine" column="sub_line"/>
<property name="stockNumber" column="stock_number"/>
</class>

Anyone know what it could be ?

Jeff.

1. stock_number must be a FK column in purchase_order where Hibernate will set the stockNumber id. Check that your data does not fail this FK link, or better add a constraint in your DB
2. inverse="true" means the link is managed by the other side. But you did not set a many-to-one on the other side. The link won't ever be managed. Read http://www.hibernate.org/Documentation/InsideExplanationOfInverseTrue
3. If the previous fails, show the code generation this exception and the full stacktrace.

I have other one to many mappings working ok, but this one still fails. There is no null values in the foreign key column (of the child table).
I made sure that the table column names and types are correct in the javabean and xml mapping file.

I don't know where to find the code generation, but the stack trace shows:


junit.framework.AssertionFailedError: net.sf.hibernate.JDBCException: could not initialize collection: [StoreMaster.purchaseOrders#132680-C]
at junit.framework.Assert.fail(Assert.java:47)
at DBServiceTest.testGetStoreMaster(DBServiceTest.java:186)
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:392)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:276)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:167)