I'm running JBoss 3.2.0beta with Dain's Unidirectional performance patch, Sun JDK 
1.3.1_03 on both Win2K and RedHat Linux 7.3, plus XDoclet 1.2.0beta.

I have two local CMP entity beans with this relationship:

SelectedBowComponent (M) -> (1) BowComponent

When I create a new SelectedBowComponent, the read ahead cache adds the
relation SelectedBowComponent_bowComponent.  Then, that BowComponent tries to
load up all SelectedBowComponents that's it's related to.  Since this is a
unidirectional relationship, that relationship will never be traversed, so why
is the data put in the cache or is that a bug?  I wouldn't have noticed this
problem except for the BowComponent the new SelectedBowComponent points to is
also pointed to by 300000 rows!  So, depending on memory settings, the read
ahead cache insertion process either runs out of memory or the transaction
times out.  I've attached code snippets below.

Thanks.

--
Chris Bonham
President/CEO
Third Eye Consulting, Inc.
[EMAIL PROTECTED]
http://www.thirdeyeconsulting.com
317.823.3686
317.823.0353 (FAX)



SelectedBowComponentBean.java:

    /**
     * @ejb.interface-method
     * @ejb.relation
     *     name="bowComponent-selectedBowComponent"
     *     role-name="SelectedBowComponentRelationshipRole"
     *     cascade-delete="no"
     *     target-ejb="BowComponent"
     *     target-role-name="BowComponentRelationshipRole"
     *     target-cascade-delete="no"
     *     target-multiple="yes"
     *
     * @jboss.relation
     *     related-pk-field="bowComponentEjbId"
     *     fk-column="BOWCOMPONENTEJB_ID"
     *
     * @weblogic.column-map
     *     foreign-key-column="BOWCOMPONENTEJB_ID"
     *     key-column="BOWCOMPONENTEJB_ID"
     */
    public abstract BowComponentLocal getBowComponent();

    /**
     * @ejb.interface-method
     */
    public abstract void setBowComponent(BowComponentLocal bowComponent);
    ...

ejb-jar.xml:

    ...
    <ejb-relation >
         <ejb-relation-name>bowComponent-selectedBowComponent</ejb-relation-name>

         <ejb-relationship-role >
            
<ejb-relationship-role-name>SelectedBowComponentRelationshipRole</ejb-relationship-role-name>
            <multiplicity>Many</multiplicity>
            <relationship-role-source >
               <ejb-name>SelectedBowComponent</ejb-name>
            </relationship-role-source>
            <cmr-field >
               <cmr-field-name>bowComponent</cmr-field-name>
            </cmr-field>
         </ejb-relationship-role>

         <ejb-relationship-role >
            
<ejb-relationship-role-name>BowComponentRelationshipRole</ejb-relationship-role-name>
            <multiplicity>One</multiplicity>
            <relationship-role-source >
               <ejb-name>BowComponent</ejb-name>
            </relationship-role-source>
         </ejb-relationship-role>

      </ejb-relation>
      ...

jbosscmp-jdbc.xml:

    ... 
    <ejb-relation>
      <ejb-relation-name>bowComponent-selectedBowComponent</ejb-relation-name>

      <foreign-key-mapping/>

      <ejb-relationship-role>
          
<ejb-relationship-role-name>SelectedBowComponentRelationshipRole</ejb-relationship-role-name>
                  <key-fields/>
      </ejb-relationship-role>
      <ejb-relationship-role>
          
<ejb-relationship-role-name>BowComponentRelationshipRole</ejb-relationship-role-name>
          <key-fields>
             <key-field>
               <field-name>bowComponentEjbId</field-name>
               <column-name>BOWCOMPONENTEJB_ID</column-name>
             </key-field>
          </key-fields>
      </ejb-relationship-role>
    </ejb-relation>
    ...

Log:

...
2002-10-31 15:26:30,391 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.SelectedBowComponent] 
Executing SQL: INSERT INTO SELECTEDBOWCOMPONENTEJB (SELECTEDBOWCOMPONENTEJB_ID, 
XPOSITION, YPOSITION, ZINDEX, PIXELTOPX, PIXELTOPY, PIXELBOTTOMX, PIXELBOTTOMY, 
HEIGHT, WIDTH, NAME, BOWCOMPONENTEJB_ID, LIFEPAGEEJB_ID) VALUES (?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?)
2002-10-31 15:26:30,391 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.selectedBowComponentEjbId]
 Set parameter: index=1, jdbcType=INTEGER, value=632304
2002-10-31 15:26:30,411 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.xPosition]
 Set parameter: index=2, jdbcType=INTEGER, value=300
2002-10-31 15:26:30,411 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.yPosition]
 Set parameter: index=3, jdbcType=INTEGER, value=10
2002-10-31 15:26:30,411 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.zIndex]
 Set parameter: index=4, jdbcType=INTEGER, value=-1
2002-10-31 15:26:30,411 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.pixelTopX]
 Set parameter: index=5, jdbcType=INTEGER, value=-1
2002-10-31 15:26:30,411 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.pixelTopY]
 Set parameter: index=6, jdbcType=INTEGER, value=-1
2002-10-31 15:26:30,411 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.pixelBottomX]
 Set parameter: index=7, jdbcType=INTEGER, value=-1
2002-10-31 15:26:30,411 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.pixelBottomY]
 Set parameter: index=8, jdbcType=INTEGER, value=-1
2002-10-31 15:26:30,411 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.height]
 Set parameter: index=9, jdbcType=INTEGER, value=330
2002-10-31 15:26:30,411 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.width]
 Set parameter: index=10, jdbcType=INTEGER, value=375
2002-10-31 15:26:30,411 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.name] 
Set parameter: index=11, jdbcType=VARCHAR, value=Yahoo Financial News
2002-10-31 15:26:30,411 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=12, jdbcType=INTEGER, value=NULL
2002-10-31 15:26:30,411 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.lifepageEjbId]
 Set parameter: index=13, jdbcType=INTEGER, value=NULL
2002-10-31 15:26:31,292 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.SelectedBowComponent] Rows 
affected = 1
2002-10-31 15:26:31,302 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] 
register, ctx=org.jboss.ejb.EntityEnterpriseContext@62da7a, tx=TransactionImpl:XidImpl 
[FormatId=257, GlobalId=3frt2o0t//69, BranchQual=]
2002-10-31 15:26:31,302 TRACE [org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] 
entryAdded, entry=key: 632304, object: 62da7a, entry: 75831e
2002-10-31 15:26:31,302 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor] Begin 
invoke, key=632304
2002-10-31 15:26:31,302 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor] Begin 
invoke, key=632304
2002-10-31 15:26:31,302 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] 
invoke called for ctx org.jboss.ejb.EntityEnterpriseContext@62da7a, 
tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=3frt2o0t//69, BranchQual=]
2002-10-31 15:26:31,302 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] 
register, ctx=org.jboss.ejb.EntityEnterpriseContext@62da7a, tx=TransactionImpl:XidImpl 
[FormatId=257, GlobalId=3frt2o0t//69, BranchQual=]
2002-10-31 15:26:31,312 DEBUG [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] 
invokerBInding is null in ProxyFactoryFinder
2002-10-31 15:26:31,312 TRACE [org.jboss.ejb.plugins.LogInterceptor] Start method=<no 
method>
2002-10-31 15:26:31,312 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Current 
transaction in MI is TransactionImpl:XidImpl [FormatId=257, GlobalId=3frt2o0t//69, 
BranchQual=]
2002-10-31 15:26:31,312 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TX_SUPPORTS for 
<no method>
2002-10-31 15:26:31,312 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Thread came in 
with tx TransactionImpl:XidImpl [FormatId=257, GlobalId=3frt2o0t//69, BranchQual=]
2002-10-31 15:26:31,312 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor] Begin 
invoke, key=3
2002-10-31 15:26:31,312 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor] Begin 
invoke, key=3
2002-10-31 15:26:31,312 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] 
invoke called for ctx org.jboss.ejb.EntityEnterpriseContext@11890d, 
tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=3frt2o0t//69, BranchQual=]
2002-10-31 15:26:31,312 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] 
register, ctx=org.jboss.ejb.EntityEnterpriseContext@11890d, tx=TransactionImpl:XidImpl 
[FormatId=257, GlobalId=3frt2o0t//69, BranchQual=]
2002-10-31 15:26:31,312 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCRelationInterceptor.BowComponent] Add relation: 
field=SelectedBowComponent_bowComponent id=3 relatedId=632304
2002-10-31 15:26:31,312 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMRFieldBridge.BowComponent.SelectedBowComponent_bowComponent]
 Read ahead cahce load: cmrField=SelectedBowComponent_bowComponent pk=3
2002-10-31 15:26:31,322 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.BowComponent] load data: 
entity=BowComponent pk=3
2002-10-31 15:26:31,322 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.BowComponent] No preload data found: 
entity=BowComponent pk=3
2002-10-31 15:26:31,322 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.BowComponent] Executing SQL: 
SELECT BOWCOMPONENTEJB_ID, SELECTEDBOWCOMPONENTEJB_ID FROM SELECTEDBOWCOMPONENTEJB 
WHERE (BOWCOMPONENTEJB_ID=?) OR (BOWCOMPONENTEJB_ID=?) OR (BOWCOMPONENTEJB_ID=?) OR 
(BOWCOMPONENTEJB_ID=?) OR (BOWCOMPONENTEJB_ID=?) OR (BOWCOMPONENTEJB_ID=?) OR 
(BOWCOMPONENTEJB_ID=?) OR (BOWCOMPONENTEJB_ID=?) OR (BOWCOMPONENTEJB_ID=?) OR 
(BOWCOMPONENTEJB_ID=?) OR (BOWCOMPONENTEJB_ID=?) OR (BOWCOMPONENTEJB_ID=?) OR 
(BOWCOMPONENTEJB_ID=?) OR (BOWCOMPONENTEJB_ID=?) OR (BOWCOMPONENTEJB_ID=?) OR 
(BOWCOMPONENTEJB_ID=?) OR (BOWCOMPONENTEJB_ID=?)
2002-10-31 15:26:31,322 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=1, jdbcType=INTEGER, value=3
2002-10-31 15:26:31,322 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=2, jdbcType=INTEGER, value=4
2002-10-31 15:26:31,322 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=3, jdbcType=INTEGER, value=52
2002-10-31 15:26:31,322 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=4, jdbcType=INTEGER, value=5
2002-10-31 15:26:31,322 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=5, jdbcType=INTEGER, value=6
2002-10-31 15:26:31,322 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=6, jdbcType=INTEGER, value=7
2002-10-31 15:26:31,322 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=7, jdbcType=INTEGER, value=8
2002-10-31 15:26:31,332 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=8, jdbcType=INTEGER, value=51
2002-10-31 15:26:31,332 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=9, jdbcType=INTEGER, value=2
2002-10-31 15:26:31,332 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=10, jdbcType=INTEGER, value=9
2002-10-31 15:26:31,332 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=11, jdbcType=INTEGER, value=10
2002-10-31 15:26:31,332 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=12, jdbcType=INTEGER, value=12
2002-10-31 15:26:31,332 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=13, jdbcType=INTEGER, value=13
2002-10-31 15:26:31,332 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=14, jdbcType=INTEGER, value=46
2002-10-31 15:26:31,332 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=15, jdbcType=INTEGER, value=14
2002-10-31 15:26:31,332 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=16, jdbcType=INTEGER, value=209
2002-10-31 15:26:31,332 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Set parameter: index=17, jdbcType=INTEGER, value=28
2002-10-31 15:26:31,793 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Get result: index=1, javaType=java.lang.Integer, Simple, value=9
2002-10-31 15:26:31,793 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.selectedBowComponentEjbId]
 Get result: index=2, javaType=java.lang.Integer, Simple, value=10942
2002-10-31 15:26:31,803 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.SelectedBowComponent] Add preload data: 
entity=SelectedBowComponent pk=10942 field=bowComponent

....

2002-10-31 15:47:38,374 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.SelectedBowComponent] Add preload data: 
entity=SelectedBowComponent pk=477987 field=bowComponent
2002-10-31 15:47:38,384 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Get result: index=1, javaType=java.lang.Integer, Simple, value=52
2002-10-31 15:47:38,384 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.selectedBowComponentEjbId]
 Get result: index=2, javaType=java.lang.Integer, Simple, value=477988
2002-10-31 15:47:38,384 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.SelectedBowComponent] Add preload data: 
entity=SelectedBowComponent pk=477988 field=bowComponent
2002-10-31 15:47:38,384 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.bowComponentEjbId]
 Get result: index=1, javaType=java.lang.Integer, Simple, value=9
2002-10-31 15:47:38,384 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SelectedBowComponent.selectedBowComponentEjbId]
 Get result: index=2, javaType=java.lang.Integer, Simple, value=477989
2002-10-31 15:47:45,004 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor] End 
invoke, key=3, ctx=org.jboss.ejb.EntityEnterpriseContext@11890d
2002-10-31 15:47:45,004 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor] End 
invoke, key=3
2002-10-31 15:47:45,124 ERROR [org.jboss.ejb.plugins.LogInterceptor] 
TransactionRolledbackLocalException, causedBy:
javax.ejb.EJBException: Unexpected Error
java.lang.OutOfMemoryError
        <<no stack trace available>>

        at 
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:206)
        at 
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:214)
        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:66)
        at 
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
        at 
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:154)
        at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:481)
        at 
org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMRFieldBridge.invokeAddRelation(JDBCCMRFieldBridge.java:678)
        at 
org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMRFieldBridge.createRelationLinks(JDBCCMRFieldBridge.java:589)
        at 
org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMRFieldBridge.setInstanceValue(JDBCCMRFieldBridge.java:553)
        at 
org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMRFieldBridge.setValue(JDBCCMRFieldBridge.java:485)
        at 
org.jboss.ejb.plugins.cmp.bridge.EntityBridgeInvocationHandler.invoke(EntityBridgeInvocationHandler.java:125)
        at org.jboss.proxy.compiler.Runtime.invoke(Runtime.java:59)

Quoting Stephen Coy ([EMAIL PROTECTED]):
> I don't think you are missing anything. Please see  [  
> jboss-Patches-608221 ] Unidirectional CMR performance patch.
> 
> This patch works for us, but Dain says he has found a better way to fix  
> it which is in Branch_3_2 as of Friday or  thereabouts.
> 
> No need to dig deeper, I've been down there already :-)
> 
> Steve Coy
> 
> On Monday, September 30, 2002, at 11:08  AM, bobby abraham wrote:
> 
> >
> > Recently while creating several tens of thousands of entities I  
> > noticed a general increase in the time taken to add an entity.  The  
> > time is roughly proportional to the number of rows in the table.
> >
> > The offending code, less the comments and logging, looks as follows :
> >
> > AttributeLocal attribute =  
> > attributeHome.findByNameAndType(attributeData.getName(), "ld");
> > AttributeInstanceLocal attributeInstance =  
> > attributeInstanceHome.create(attributeInstanceData);
> > attributeInstance.setAttribute(attribute);
> > parcel.getAttributeInstances().add(attributeInstance);
> >
> > The relationships involved are
> > Attribute (1) <- (M) AttributeInstance [ via foreign key on the  
> > attributeinstance table called attribute_id]
> > Parcel (1) -> (M) AttributeInstance [ via a link table ]
> >
> > Now the jboss server log included below shows the sql query "SELECT  
> > AttributeInstance_id FROM ATTRIBUTEINSTANCE WHERE (attribute_id=?)".  
> > In this case it takes 210 ms but this time is proportional to the  
> > number of attributeinstances already related to this attribute.  This  
> > query does in fact typically return thousands of rows.
> >
> > I can see no good reason for this select to be executed at all - or  
> > have I missed something ?
> >
> > 2002-09-27 16:32:02,360 DEBUG  
> > [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Sequence.find 
> > ByPrimaryKey] Executing SQL: SELECT name FROM SEQUENCE WHERE name=?
> > 2002-09-27 16:32:02,370 DEBUG  
> > [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Sequence]  
> > Executing SQL: SELECT nextVal FROM SEQUENCE WHERE (name=?)
> > 2002-09-27 16:32:02,370 DEBUG  
> > [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Sequence]  
> > Executing SQL: SELECT nextVal FROM SEQUENCE WHERE (name=?)
> > 2002-09-27 16:32:02,380 DEBUG  
> > [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.Sequence]  
> > Executing SQL: UPDATE SEQUENCE SET nextVal=? WHERE name=?
> > 2002-09-27 16:32:02,380 DEBUG  
> > [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.Sequence] Rows  
> > affected = 1
> > 2002-09-27 16:32:02,380 DEBUG  
> > [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.AttributeInstan 
> > ce] Create: pk=80936
> > 2002-09-27 16:32:02,380 DEBUG  
> > [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.AttributeInstan 
> > ce] Executing SQL: SELECT COUNT(*) FROM ATTRIBUTEINSTANCE WHERE  
> > AttributeInstance_id=?
> > 2002-09-27 16:32:02,380 DEBUG  
> > [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.AttributeInstan 
> > ce] Executing SQL: INSERT INTO ATTRIBUTEINSTANCE  
> > (AttributeInstance_id, value, deprecated, userstamp, timestamp,  
> > attribute_id) VALUES (?, ?, ?, ?, ?, ?)
> > 2002-09-27 16:32:02,390 DEBUG  
> > [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.AttributeInstan 
> > ce] Rows affected = 1
> > 2002-09-27 16:32:02,390 DEBUG  
> > [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Attribute]  
> > Executing SQL: SELECT type, unit, data_type, description, name,  
> > deprecated, userstamp, timestamp FROM ATTRIBUTE WHERE (attribute_id=?)
> > 2002-09-27 16:32:02,390 DEBUG  
> > [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.Attribute]  
> > Executing SQL: SELECT AttributeInstance_id FROM ATTRIBUTEINSTANCE  
> > WHERE (attribute_id=?)
> > 2002-09-27 16:32:02,600 INFO  [STDOUT] LOAD--2 attribute instance add  
> > 240 milliseconds
> > 2002-09-27 16:32:02,600 DEBUG  
> > [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.AttributeInstanc 
> > e] Executing SQL: UPDATE ATTRIBUTEINSTANCE SET attribute_id=? WHERE  
> > AttributeInstance_id=?
> > 2002-09-27 16:32:02,600 DEBUG  
> > [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.AttributeInstanc 
> > e] Rows affected = 1
> >
> >
> > I'm happy to dig deeper into this problem but am hoping that someone  
> > can give me a few pointers as to what might be going on here.
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user


-------------------------------------------------------
This sf.net email is sponsored by: See the NEW Palm 
Tungsten T handheld. Power & Color in a compact size!
http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to