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
