Hi Dain,
thanks for your reply, but all my methods are marked as transaction required and all that loading stuff happens anyway for a single finder method.
I am confused.
Thanks
Simone
From: Dain Sundstrom <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Optimized CMP loading Date: Thu, 3 Apr 2003 09:58:48 -0600
You need to use a transaction for the access. We can not assume that data read in one transaction is valid in another transaction.
-dain
On Thursday, April 3, 2003, at 08:39 AM, Simone Milani wrote:
I am using read-ahead:
<read-ahead>
<strategy>on-find</strategy>
<page-size>50</page-size>
</read-ahead>
It keeps saying no preload data found while actually before has loaded the
data.
2003-04-03 15:28:44,293 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.MDSDbax] Executing
SQL: SELECT MD_KEY,MD_BUSINESS_AREA, MD_CLASS, MD_CURRENCY, MD_DATEVALUE,
MD_FIELDNAME, MD_FLOATVALUE, MD_INSTANCE, MD_LOCATION, MD_NAME,
MD_STRING_VALUE, MD_TYPEID FROM MDS_DBAX WHERE (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?)
2003-04-03 15:28:44,293 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.MDSDbax.mDK ey]
Set parameter: index=1, jdbcType=NUMERIC, value=4707
....
2003-04-03 15:28:44,293 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.MDSDbax.mDK ey]
Set parameter: index=50, jdbcType=NUMERIC, value=4756
2003-04-03 15:28:44,309 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.MDSDbax.mDK ey]
Get result: index=1, javaType=java.lang.Long, Simple, value=4708
2003-04-03 15:28:44,309 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.MDSDbax.bus iness
Area] Get result: index=2, javaType=java.lang.String, Simple, value=OTC
2003-04-03 15:28:44,309 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.MDSDbax] Add preload data:
entity=MDSDbax pk=4708 field=businessArea
... get and load all results.....
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.MDSDbax] Add preload data:
entity=MDSDbax pk=4756 field=typeId
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.EntityMultiInstanceSynchronizationInterceptor]
register, [EMAIL PROTECTED],
tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=dblon34056//23,
BranchQual=]
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.EntityMultiInstanceSynchronizationInterceptor]
register, [EMAIL PROTECTED],
tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=dblon34056//23,
BranchQual=]
2003-04-03 15:28:44,403 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor]
End invoke, key=4707
2003-04-03 15:28:44,403 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT]
TxInterceptorCMT: In finally
2003-04-03 15:28:44,403 TRACE [org.jboss.ejb.plugins.LogInterceptor] End
method=getMDSDbaxValue
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding is null
in ProxyFactoryFinder
2003-04-03 15:28:44,403 TRACE [org.jboss.ejb.plugins.LogInterceptor] Start
method=getMDSDbaxValue
2003-04-03 15:28:44,403 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT]
Current transaction in MI is TransactionImpl:XidImpl [FormatId=257,
GlobalId=dblon34056//23, BranchQual=]
2003-04-03 15:28:44,403 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT]
TX_REQUIRED for getMDSDbaxValue
2003-04-03 15:28:44,403 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT]
Thread came in with tx TransactionImpl:XidImpl [FormatId=257,
GlobalId=dblon34056//23, BranchQual=]
2003-04-03 15:28:44,403 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor]
Begin invoke, key=4708
2003-04-03 15:28:44,403 TRACE [org.jboss.ejb.plugins.EntityInstancePool] Get
instance [EMAIL PROTECTED]
com.db.jbozz.ejb.entity.mds.MDSDbaxCMP
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.lock.JDBCOptimisticLock] schedule>
method=getMDSDbaxValue; tx=TransactionImpl:XidImpl [FormatId=257,
GlobalId=dblon34056//23, BranchQual=]
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.lock.JDBCOptimisticLock] schedule> other tx came in:
tx=0; ctx.id=4708
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.lock.JDBCOptimisticLock] schedule> modified strategy:
locking all field values
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.MDSDbax] load data:
entity=MDSDbax pk=4708
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.MDSDbax] Preloading data:
entity=MDSDbax pk=4708 cmpField=instance
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.MDSDbax] Preloading data:
entity=MDSDbax pk=4708 cmpField=location
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.MDSDbax] Preloading data:
entity=MDSDbax pk=4708 cmpField=businessArea
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.MDSDbax] Preloading data:
entity=MDSDbax pk=4708 cmpField=stringValue
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.MDSDbax] Preloading data:
entity=MDSDbax pk=4708 cmpField=name
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.MDSDbax] Preloading data:
entity=MDSDbax pk=4708 cmpField=typeId
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.MDSDbax] Preloading data:
entity=MDSDbax pk=4708 cmpField=fieldName
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.MDSDbax] Preloading data:
entity=MDSDbax pk=4708 cmpField=dateValue
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.MDSDbax] Preloading data:
entity=MDSDbax pk=4708 cmpField=currency
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.MDSDbax] Preloading data:
entity=MDSDbax pk=4708 cmpField=floatValue
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.MDSDbax] Preloading data:
entity=MDSDbax pk=4708 cmpField=className
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.lock.JDBCOptimisticLock] lockFieldValue>
field=businessArea; value OTC
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.lock.JDBCOptimisticLock] lockFieldValue>
field=className; value YC
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.lock.JDBCOptimisticLock] lockFieldValue>
field=currency; value GBP
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.lock.JDBCOptimisticLock] lockFieldValue>
field=dateValue; value null
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.lock.JDBCOptimisticLock] lockFieldValue>
field=fieldName; value PRICE_ID
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.lock.JDBCOptimisticLock] lockFieldValue>
field=floatValue; value 1164.0
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.lock.JDBCOptimisticLock] lockFieldValue>
field=instance; value LIBOR
2003-04-03 15:28:44,403 TRACE
[org.jboss.ejb.plugins.lock.JDBCOptimisticLock] lockFieldValue>
field=location; value LDN
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.lock.JDBCOptimisticLock] lockFieldValue> field=name;
value 16Y
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.lock.JDBCOptimisticLock] lockFieldValue>
field=stringValue; value null
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.lock.JDBCOptimisticLock] lockFieldValue>
field=typeId; value 0
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.lock.JDBCOptimisticLock] schedule> ctx.id=4708;
id=4708; method=getMDSDbaxValue; tx=0
2003-04-03 15:28:44,418 TRACE [org.jboss.ejb.plugins.EntityInstancePool] Get
instance [EMAIL PROTECTED]
com.db.jbozz.ejb.entity.mds.MDSDbaxCMP
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.EntityMultiInstanceInterceptor] Begin invoke,
key=4708
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.EntityMultiInstanceSynchronizationInterceptor] invoke
called for ctx [EMAIL PROTECTED],
tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=dblon34056//23,
BranchQual=]
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.MDSDbax] RESET PERSISTENCE
CONTEXT: id=4708
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.MDSDbax] load data:
entity=MDSDbax pk=4708
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.MDSDbax] No preload data
found: entity=MDSDbax pk=4708
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.MDSDbax] Eager-load
for entity: readahead=[JDBCReadAheadMetaData : strategy=on-find,
pageSize=50, eagerLoadGroup=*]
2003-04-03 15:28:44,418 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.MDSDbax] Executing
SQL: SELECT MD_KEY,MD_BUSINESS_AREA, MD_CLASS, MD_CURRENCY, MD_DATEVALUE,
MD_FIELDNAME, MD_FLOATVALUE, MD_INSTANCE, MD_LOCATION, MD_NAME,
MD_STRING_VALUE, MD_TYPEID FROM MDS_DBAX WHERE (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?) OR
(MD_KEY=?) OR (MD_KEY=?) OR (MD_KEY=?)
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.MDSDbax.mDK ey]
Set parameter: index=1, jdbcType=NUMERIC, value=4708
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.MDSDbax.mDK ey]
Set parameter: index=2, jdbcType=NUMERIC, value=4709
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.MDSDbax.mDK ey]
Set parameter: index=3, jdbcType=NUMERIC, value=4710
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.MDSDbax.mDK ey]
Set parameter: index=4, jdbcType=NUMERIC, value=4711
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.MDSDbax.mDK ey]
Set parameter: index=5, jdbcType=NUMERIC, value=4712
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.MDSDbax.mDK ey]
Set parameter: index=6, jdbcType=NUMERIC, value=4713
2003-04-03 15:28:44,418 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.MDSDbax.mDK ey]
Set parameter: index=7, jdbcType=NUMERIC, value=4714
And all like this....
Thanks!
Simone
----- Original Message ----- From: "Alex Loubyansky" <[EMAIL PROTECTED]> To: "Simone Milani" <[EMAIL PROTECTED]> Sent: Thursday, April 03, 2003 2:17 PM Subject: Re: [JBoss-user] Optimized CMP loading
Thursday, April 03, 2003, 3:35:05 PM, you wrote:read-ahead strategy does not help at all.
SM> Hi,
SM> Is it possible to preload all the entities returned from a finder?
Yes, with read-ahead.
SM> I have a finder method that returns many rows (around 100) and thecache.
Does not help or does not work?
alex
SM> Also I am SM> using Optimistic locking with 3.2.0 so there is no global entity
SM> Thanks
SM> Simone
------------------------------------------------------- This SF.net email is sponsored by: ValueWeb: Dedicated Hosting for just $79/mo with 500 GB of bandwidth! No other company gives more support or power for your dedicated server http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
------------------------------------------------------- This SF.net email is sponsored by: ValueWeb: Dedicated Hosting for just $79/mo with 500 GB of bandwidth! No other company gives more support or power for your dedicated server http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
-------------------------------------------------------
This SF.net email is sponsored by: ValueWeb: Dedicated Hosting for just $79/mo with 500 GB of bandwidth! No other company gives more support or power for your dedicated server
http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
_________________________________________________________________
-------------------------------------------------------
This SF.net email is sponsored by: ValueWeb: Dedicated Hosting for just $79/mo with 500 GB of bandwidth! No other company gives more support or power for your dedicated server
http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
