cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave Lamy <davel...@gmail.com>
Subject First time inheritance attempt
Date Thu, 24 Sep 2009 17:10:33 GMT
Hey guys--

I'm attempting to model some inheritance for the first time and it's not
working yet.  Here's my situation:

My model is to have a non-abstract parent class->table and then
subclass->tables like so:

First I should doublecheck to make sure my mapping XML looks OK:

    <db-entity name="ASSET_CONTENT">
        ...
        <db-attribute name="CONTENT_TYPE" type="VARCHAR" length="50"/>
        <db-attribute name="ID" type="INTEGER" isPrimaryKey="true"
isGenerated="true" isMandatory="true"/>
        ...
    </db-entity>
    <db-entity name="IMAGE_ASSET_CONTENT">
        <db-attribute name="HEIGHT" type="INTEGER"/>
        <db-attribute name="ID" type="INTEGER" isPrimaryKey="true"
isMandatory="true"/>
        <db-attribute name="WIDTH" type="INTEGER"/>
    </db-entity>
    <obj-entity name="AssetContent"
className="com.routeto1.asset.filesystem.AssetContent"
lock-type="optimistic" dbEntityName="ASSET_CONTENT"
superClassName="com.routeto1.data.impl.DynamicDataObject">
        <obj-attribute name="contentType" type="java.lang.String"
db-attribute-path="CONTENT_TYPE"/>
         ...
        <pre-persist method-name="prePersist"/>
    </obj-entity>
    <obj-entity name="ImageAssetContent" superEntityName="AssetContent"
className="com.routeto1.asset.filesystem.ImageAssetContent"
lock-type="optimistic" dbEntityName="IMAGE_ASSET_CONTENT">
        <qualifier><![CDATA[contentType = "IMAGE"]]></qualifier>
        <obj-attribute name="height" type="java.lang.Integer"
db-attribute-path="HEIGHT"/>
        <obj-attribute name="width" type="java.lang.Integer"
db-attribute-path="WIDTH"/>
    </obj-entity>

Not sure if I need to provide you any more than that.  Cayenne accepts the
config fine, but when I create a new ImageAssetContent and save it, Cayenne
only saves to the IMAGE_ASSET_CONTENT  table:

2009-09-24 10:30:53,602 INFO [org.apache.cayenne.access.QueryLogger] -
<INSERT INTO IMAGE_ASSET_CONTENT (HEIGHT, ID, WIDTH) VALUES (?, ?, ?)>
2009-09-24 10:30:53,656 INFO [org.apache.cayenne.access.QueryLogger] -
<[batch bind: 1->HEIGHT:440, 2->ID:220, 3->WIDTH:495]>

I've confirmed that there is data in the object that should be getting saved
to the ASSET_CONTENT table but is not.

What's also interesting is that it is pulling an auto PK value (this is
running on a Derby DB for testing):

2009-09-24 10:30:53,258 INFO [org.apache.cayenne.access.QueryLogger] -
<SELECT NEXT_ID FROM AUTO_PK_SUPPORT WHERE TABLE_NAME = ? FOR UPDATE [bind:
1:'IMAGE_ASSET_CONTENT']>

Not so interesting that it's pulling one, but for IMAGE_ASSET_CONTENT?   I'd
assume it would be pulling for ASSET_CONTENT and reusing that ID in both the
parent and child tables.

Am I missing something really basic?

I've tested this on 3.0 M5 and M6 with same results.

Dave

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message