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.mDKey]
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.mDKey]
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.mDKey]
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.business
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.mDKey]
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.mDKey]
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.mDKey]
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.mDKey]
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.mDKey]
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.mDKey]
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.mDKey]
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:
>
> 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 the
read-ahead strategy does not help at all.
>
> 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
cache.
>
> 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
