Help interpretting CMP plugin cache logging
jason1 Dec 7, 2005 5:41 PMI have a Read-Only EJB. It has a finder that finds by a "findByDeviceID", expecting many entities returned. It is configured with <read-only>true</read-only> and <read-timeout>300000</read-timeout> (e.g., 5 minutes)
I ran a finder four times to study caching behavior, but the logs confused me.
I did the following:
- Ran finder 1 and 2 time, close to each other
- waited over 5 minutes for cache to expire
- Ran finder again 3 and 4 time, close to each other
Looking for input on whether or not it is really getting cached entity beans the second time around since it is hard to decipher the logs.
PROCESS REQUEST 1 HERE: Looks like it goes to DB and then preloads internal cache 2005-12-07 15:08:15,116 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.DeviceExtRO#findByDeviceId] Executing SQL: SELECT t0_o.DEVICE_EXT_ID, t0_o.NAME_TXT, t0_o.VALUE_TXT, t0_o.DEVICE_ID, t0_o.TYPE_DEVICE_CD, t0_o.TYPE_DATATYPE_CD, t0_o.CREATE_DT, t0_o.CREATE_USER_TXT, t0_o.LAST_UPDATE_DT, t0_o.UPDATE_USER_TXT FROM DEVICE_EXT t0_o WHERE t0_o.DEVICE_ID = ? 2005-12-07 15:08:15,116 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.DeviceExtRO#findByDeviceId] param: i=1, type=DECIMAL, value=1665 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceExtId] result: i=1, type=java.math.BigDecimal, value=1 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#nameTxt] result: i=2, type=java.lang.String, value=ROUTE_NEXT_POST_TIME_DT 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=nameTxt 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#valueTxt] result: i=3, type=java.lang.String, value=1 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=valueTxt 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceId] result: i=4, type=java.math.BigDecimal, value=1665 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=deviceId 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDeviceCd] result: i=5, type=java.math.BigDecimal, value=1 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=typeDeviceCd 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDatatypeCd] result: i=6, type=java.math.BigDecimal, value=12 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=typeDatatypeCd 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createDt] result: i=7, type=java.sql.Timestamp, value=2005-11-30 14:54:08.26 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=createDt 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createUserTxt] result: i=8, type=java.lang.String, value=GUEST 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=createUserTxt 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#lastUpdateDt] result: i=9, type=java.sql.Timestamp, value=2005-11-30 14:54:08.26 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=lastUpdateDt 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#updateUserTxt] result: i=10, type=java.lang.String, value=GUEST 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=updateUserTxt 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceExtId] result: i=1, type=java.math.BigDecimal, value=2 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#nameTxt] result: i=2, type=java.lang.String, value=ROUTE_AUTO_EXP_INTERVAL_NUM 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=nameTxt 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#valueTxt] result: i=3, type=java.lang.String, value=5 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=valueTxt 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceId] result: i=4, type=java.math.BigDecimal, value=1665 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=deviceId 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDeviceCd] result: i=5, type=java.math.BigDecimal, value=1 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=typeDeviceCd 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDatatypeCd] result: i=6, type=java.math.BigDecimal, value=8 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=typeDatatypeCd 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createDt] result: i=7, type=java.sql.Timestamp, value=2005-11-30 14:54:11.994 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=createDt 2005-12-07 15:08:15,148 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createUserTxt] result: i=8, type=java.lang.String, value=GUEST 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=createUserTxt 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#lastUpdateDt] result: i=9, type=java.sql.Timestamp, value=2005-11-30 14:54:11.994 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=lastUpdateDt 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#updateUserTxt] result: i=10, type=java.lang.String, value=GUEST 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=updateUserTxt 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceExtId] result: i=1, type=java.math.BigDecimal, value=3 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#nameTxt] result: i=2, type=java.lang.String, value=TYPE_ROUTE_MSG_FORMAT_CD 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=nameTxt 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#valueTxt] result: i=3, type=java.lang.String, value=1 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=valueTxt 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceId] result: i=4, type=java.math.BigDecimal, value=1665 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=deviceId 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDeviceCd] result: i=5, type=java.math.BigDecimal, value=1 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=typeDeviceCd 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDatatypeCd] result: i=6, type=java.math.BigDecimal, value=5 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=typeDatatypeCd 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createDt] result: i=7, type=java.sql.Timestamp, value=2005-11-30 14:54:47.041 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=createDt 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createUserTxt] result: i=8, type=java.lang.String, value=GUEST 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=createUserTxt 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#lastUpdateDt] result: i=9, type=java.sql.Timestamp, value=2005-11-30 14:54:47.041 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=lastUpdateDt 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#updateUserTxt] result: i=10, type=java.lang.String, value=GUEST 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=updateUserTxt 2005-12-07 15:08:15,163 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add finder results: entity=DeviceExtRO results=[1, 2, 3] readahead=[JDBCReadAheadMetaData : strategy=on-find, pageSize=255, eagerLoadGroup=*, left-join[]] 2005-12-07 15:08:15,194 DEBUG [cdot.ctms.layer.services.comm.data.device.DeviceExtBean$Proxy] ejbActivate: 1 2005-12-07 15:08:15,194 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.DeviceExtRO] RESET PERSISTENCE CONTEXT: id=1 2005-12-07 15:08:15,194 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] load data: entity=DeviceExtRO pk=1 2005-12-07 15:08:15,194 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=createUserTxt 2005-12-07 15:08:15,194 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=deviceId 2005-12-07 15:08:15,194 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=updateUserTxt 2005-12-07 15:08:15,194 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=lastUpdateDt 2005-12-07 15:08:15,194 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=typeDatatypeCd 2005-12-07 15:08:15,194 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=nameTxt 2005-12-07 15:08:15,194 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=valueTxt 2005-12-07 15:08:15,194 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=createDt 2005-12-07 15:08:15,194 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=typeDeviceCd 2005-12-07 15:08:15,194 DEBUG [cdot.ctms.layer.services.comm.data.device.DeviceExtBean$Proxy] ejbLoad: 1 2005-12-07 15:08:15,210 DEBUG [cdot.ctms.layer.services.comm.data.device.DeviceExtBean$Proxy] ejbActivate: 2 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.DeviceExtRO] RESET PERSISTENCE CONTEXT: id=2 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] load data: entity=DeviceExtRO pk=2 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=createUserTxt 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=deviceId 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=updateUserTxt 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=lastUpdateDt 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=typeDatatypeCd 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=nameTxt 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=valueTxt 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=createDt 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=typeDeviceCd 2005-12-07 15:08:15,210 DEBUG [cdot.ctms.layer.services.comm.data.device.DeviceExtBean$Proxy] ejbLoad: 2 2005-12-07 15:08:15,210 DEBUG [cdot.ctms.layer.services.comm.data.device.DeviceExtBean$Proxy] ejbActivate: 3 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.DeviceExtRO] RESET PERSISTENCE CONTEXT: id=3 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] load data: entity=DeviceExtRO pk=3 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=createUserTxt 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=deviceId 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=updateUserTxt 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=lastUpdateDt 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=typeDatatypeCd 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=nameTxt 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=valueTxt 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=createDt 2005-12-07 15:08:15,210 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=typeDeviceCd 2005-12-07 15:08:15,210 DEBUG [cdot.ctms.layer.services.comm.data.device.DeviceExtBean$Proxy] ejbLoad: 3 PROCESS REQUEST 2 HERE: Looks like it goes to internal cache. So why the "Executing SQL:" logging then? 2005-12-07 15:08:33,460 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.DeviceExtRO#findByDeviceId] Executing SQL: SELECT t0_o.DEVICE_EXT_ID, t0_o.NAME_TXT, t0_o.VALUE_TXT, t0_o.DEVICE_ID, t0_o.TYPE_DEVICE_CD, t0_o.TYPE_DATATYPE_CD, t0_o.CREATE_DT, t0_o.CREATE_USER_TXT, t0_o.LAST_UPDATE_DT, t0_o.UPDATE_USER_TXT FROM DEVICE_EXT t0_o WHERE t0_o.DEVICE_ID = ? 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.DeviceExtRO#findByDeviceId] param: i=1, type=DECIMAL, value=1665 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceExtId] result: i=1, type=java.math.BigDecimal, value=1 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#nameTxt] result: i=2, type=java.lang.String, value=ROUTE_NEXT_POST_TIME_DT 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=nameTxt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#valueTxt] result: i=3, type=java.lang.String, value=1 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=valueTxt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceId] result: i=4, type=java.math.BigDecimal, value=1665 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=deviceId 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDeviceCd] result: i=5, type=java.math.BigDecimal, value=1 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=typeDeviceCd 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDatatypeCd] result: i=6, type=java.math.BigDecimal, value=12 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=typeDatatypeCd 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createDt] result: i=7, type=java.sql.Timestamp, value=2005-11-30 14:54:08.26 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=createDt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createUserTxt] result: i=8, type=java.lang.String, value=GUEST 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=createUserTxt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#lastUpdateDt] result: i=9, type=java.sql.Timestamp, value=2005-11-30 14:54:08.26 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=lastUpdateDt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#updateUserTxt] result: i=10, type=java.lang.String, value=GUEST 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=updateUserTxt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceExtId] result: i=1, type=java.math.BigDecimal, value=2 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#nameTxt] result: i=2, type=java.lang.String, value=ROUTE_AUTO_EXP_INTERVAL_NUM 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=nameTxt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#valueTxt] result: i=3, type=java.lang.String, value=5 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=valueTxt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceId] result: i=4, type=java.math.BigDecimal, value=1665 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=deviceId 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDeviceCd] result: i=5, type=java.math.BigDecimal, value=1 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=typeDeviceCd 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDatatypeCd] result: i=6, type=java.math.BigDecimal, value=8 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=typeDatatypeCd 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createDt] result: i=7, type=java.sql.Timestamp, value=2005-11-30 14:54:11.994 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=createDt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createUserTxt] result: i=8, type=java.lang.String, value=GUEST 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=createUserTxt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#lastUpdateDt] result: i=9, type=java.sql.Timestamp, value=2005-11-30 14:54:11.994 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=lastUpdateDt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#updateUserTxt] result: i=10, type=java.lang.String, value=GUEST 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=updateUserTxt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceExtId] result: i=1, type=java.math.BigDecimal, value=3 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#nameTxt] result: i=2, type=java.lang.String, value=TYPE_ROUTE_MSG_FORMAT_CD 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=nameTxt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#valueTxt] result: i=3, type=java.lang.String, value=1 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=valueTxt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceId] result: i=4, type=java.math.BigDecimal, value=1665 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=deviceId 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDeviceCd] result: i=5, type=java.math.BigDecimal, value=1 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=typeDeviceCd 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDatatypeCd] result: i=6, type=java.math.BigDecimal, value=5 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=typeDatatypeCd 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createDt] result: i=7, type=java.sql.Timestamp, value=2005-11-30 14:54:47.041 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=createDt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createUserTxt] result: i=8, type=java.lang.String, value=GUEST 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=createUserTxt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#lastUpdateDt] result: i=9, type=java.sql.Timestamp, value=2005-11-30 14:54:47.041 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=lastUpdateDt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#updateUserTxt] result: i=10, type=java.lang.String, value=GUEST 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=updateUserTxt 2005-12-07 15:08:33,460 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add finder results: entity=DeviceExtRO results=[1, 2, 3] readahead=[JDBCReadAheadMetaData : strategy=on-find, pageSize=255, eagerLoadGroup=*, left-join[]] PROCESS REQUEST 3 HERE: Looks like it goes to DB and then preloads internal cache 2005-12-07 15:23:12,619 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.DeviceExtRO#findByDeviceId] Executing SQL: SELECT t0_o.DEVICE_EXT_ID, t0_o.NAME_TXT, t0_o.VALUE_TXT, t0_o.DEVICE_ID, t0_o.TYPE_DEVICE_CD, t0_o.TYPE_DATATYPE_CD, t0_o.CREATE_DT, t0_o.CREATE_USER_TXT, t0_o.LAST_UPDATE_DT, t0_o.UPDATE_USER_TXT FROM DEVICE_EXT t0_o WHERE t0_o.DEVICE_ID = ? 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.DeviceExtRO#findByDeviceId] param: i=1, type=DECIMAL, value=1665 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceExtId] result: i=1, type=java.math.BigDecimal, value=1 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#nameTxt] result: i=2, type=java.lang.String, value=ROUTE_NEXT_POST_TIME_DT 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=nameTxt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#valueTxt] result: i=3, type=java.lang.String, value=1 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=valueTxt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceId] result: i=4, type=java.math.BigDecimal, value=1665 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=deviceId 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDeviceCd] result: i=5, type=java.math.BigDecimal, value=1 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=typeDeviceCd 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDatatypeCd] result: i=6, type=java.math.BigDecimal, value=12 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=typeDatatypeCd 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createDt] result: i=7, type=java.sql.Timestamp, value=2005-11-30 14:54:08.26 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=createDt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createUserTxt] result: i=8, type=java.lang.String, value=GUEST 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=createUserTxt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#lastUpdateDt] result: i=9, type=java.sql.Timestamp, value=2005-11-30 14:54:08.26 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=lastUpdateDt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#updateUserTxt] result: i=10, type=java.lang.String, value=GUEST 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=updateUserTxt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceExtId] result: i=1, type=java.math.BigDecimal, value=2 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#nameTxt] result: i=2, type=java.lang.String, value=ROUTE_AUTO_EXP_INTERVAL_NUM 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=nameTxt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#valueTxt] result: i=3, type=java.lang.String, value=5 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=valueTxt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceId] result: i=4, type=java.math.BigDecimal, value=1665 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=deviceId 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDeviceCd] result: i=5, type=java.math.BigDecimal, value=1 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=typeDeviceCd 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDatatypeCd] result: i=6, type=java.math.BigDecimal, value=8 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=typeDatatypeCd 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createDt] result: i=7, type=java.sql.Timestamp, value=2005-11-30 14:54:11.994 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=createDt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createUserTxt] result: i=8, type=java.lang.String, value=GUEST 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=createUserTxt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#lastUpdateDt] result: i=9, type=java.sql.Timestamp, value=2005-11-30 14:54:11.994 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=lastUpdateDt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#updateUserTxt] result: i=10, type=java.lang.String, value=GUEST 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=updateUserTxt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceExtId] result: i=1, type=java.math.BigDecimal, value=3 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#nameTxt] result: i=2, type=java.lang.String, value=TYPE_ROUTE_MSG_FORMAT_CD 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=nameTxt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#valueTxt] result: i=3, type=java.lang.String, value=1 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=valueTxt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceId] result: i=4, type=java.math.BigDecimal, value=1665 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=deviceId 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDeviceCd] result: i=5, type=java.math.BigDecimal, value=1 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=typeDeviceCd 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDatatypeCd] result: i=6, type=java.math.BigDecimal, value=5 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=typeDatatypeCd 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createDt] result: i=7, type=java.sql.Timestamp, value=2005-11-30 14:54:47.041 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=createDt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createUserTxt] result: i=8, type=java.lang.String, value=GUEST 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=createUserTxt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#lastUpdateDt] result: i=9, type=java.sql.Timestamp, value=2005-11-30 14:54:47.041 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=lastUpdateDt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#updateUserTxt] result: i=10, type=java.lang.String, value=GUEST 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=updateUserTxt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add finder results: entity=DeviceExtRO results=[1, 2, 3] readahead=[JDBCReadAheadMetaData : strategy=on-find, pageSize=255, eagerLoadGroup=*, left-join[]] 2005-12-07 15:23:12,635 DEBUG [cdot.ctms.layer.services.comm.data.device.DeviceExtBean$Proxy] ejbActivate: 1 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.DeviceExtRO] RESET PERSISTENCE CONTEXT: id=1 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] load data: entity=DeviceExtRO pk=1 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=createUserTxt 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=deviceId 2005-12-07 15:23:12,635 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=updateUserTxt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=lastUpdateDt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=typeDatatypeCd 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=nameTxt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=valueTxt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=createDt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=1 cmpField=typeDeviceCd 2005-12-07 15:23:12,650 DEBUG [cdot.ctms.layer.services.comm.data.device.DeviceExtBean$Proxy] ejbLoad: 1 2005-12-07 15:23:12,650 DEBUG [cdot.ctms.layer.services.comm.data.device.DeviceExtBean$Proxy] ejbActivate: 2 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.DeviceExtRO] RESET PERSISTENCE CONTEXT: id=2 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] load data: entity=DeviceExtRO pk=2 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=createUserTxt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=deviceId 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=updateUserTxt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=lastUpdateDt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=typeDatatypeCd 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=nameTxt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=valueTxt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=createDt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=2 cmpField=typeDeviceCd 2005-12-07 15:23:12,650 DEBUG [cdot.ctms.layer.services.comm.data.device.DeviceExtBean$Proxy] ejbLoad: 2 2005-12-07 15:23:12,650 DEBUG [cdot.ctms.layer.services.comm.data.device.DeviceExtBean$Proxy] ejbActivate: 3 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.DeviceExtRO] RESET PERSISTENCE CONTEXT: id=3 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] load data: entity=DeviceExtRO pk=3 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=createUserTxt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=deviceId 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=updateUserTxt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=lastUpdateDt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=typeDatatypeCd 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=nameTxt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=valueTxt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=createDt 2005-12-07 15:23:12,650 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Preloading data: entity=DeviceExtRO pk=3 cmpField=typeDeviceCd PROCESS REQUEST 4 HERE: Looks like it goes to internal cache, but why the "Executing SQL:..." logging then?? 2005-12-07 15:23:54,071 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.DeviceExtRO#findByDeviceId] Executing SQL: SELECT t0_o.DEVICE_EXT_ID, t0_o.NAME_TXT, t0_o.VALUE_TXT, t0_o.DEVICE_ID, t0_o.TYPE_DEVICE_CD, t0_o.TYPE_DATATYPE_CD, t0_o.CREATE_DT, t0_o.CREATE_USER_TXT, t0_o.LAST_UPDATE_DT, t0_o.UPDATE_USER_TXT FROM DEVICE_EXT t0_o WHERE t0_o.DEVICE_ID = ? 2005-12-07 15:23:54,071 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.DeviceExtRO#findByDeviceId] param: i=1, type=DECIMAL, value=1665 2005-12-07 15:23:54,071 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceExtId] result: i=1, type=java.math.BigDecimal, value=1 2005-12-07 15:23:54,071 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#nameTxt] result: i=2, type=java.lang.String, value=ROUTE_NEXT_POST_TIME_DT 2005-12-07 15:23:54,071 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=nameTxt 2005-12-07 15:23:54,071 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#valueTxt] result: i=3, type=java.lang.String, value=1 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=valueTxt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceId] result: i=4, type=java.math.BigDecimal, value=1665 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=deviceId 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDeviceCd] result: i=5, type=java.math.BigDecimal, value=1 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=typeDeviceCd 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDatatypeCd] result: i=6, type=java.math.BigDecimal, value=12 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=typeDatatypeCd 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createDt] result: i=7, type=java.sql.Timestamp, value=2005-11-30 14:54:08.26 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=createDt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createUserTxt] result: i=8, type=java.lang.String, value=GUEST 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=createUserTxt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#lastUpdateDt] result: i=9, type=java.sql.Timestamp, value=2005-11-30 14:54:08.26 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=lastUpdateDt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#updateUserTxt] result: i=10, type=java.lang.String, value=GUEST 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=1 field=updateUserTxt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceExtId] result: i=1, type=java.math.BigDecimal, value=2 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#nameTxt] result: i=2, type=java.lang.String, value=ROUTE_AUTO_EXP_INTERVAL_NUM 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=nameTxt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#valueTxt] result: i=3, type=java.lang.String, value=5 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=valueTxt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceId] result: i=4, type=java.math.BigDecimal, value=1665 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=deviceId 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDeviceCd] result: i=5, type=java.math.BigDecimal, value=1 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=typeDeviceCd 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDatatypeCd] result: i=6, type=java.math.BigDecimal, value=8 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=typeDatatypeCd 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createDt] result: i=7, type=java.sql.Timestamp, value=2005-11-30 14:54:11.994 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=createDt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createUserTxt] result: i=8, type=java.lang.String, value=GUEST 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=createUserTxt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#lastUpdateDt] result: i=9, type=java.sql.Timestamp, value=2005-11-30 14:54:11.994 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=lastUpdateDt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#updateUserTxt] result: i=10, type=java.lang.String, value=GUEST 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=2 field=updateUserTxt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceExtId] result: i=1, type=java.math.BigDecimal, value=3 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#nameTxt] result: i=2, type=java.lang.String, value=TYPE_ROUTE_MSG_FORMAT_CD 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=nameTxt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#valueTxt] result: i=3, type=java.lang.String, value=1 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=valueTxt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#deviceId] result: i=4, type=java.math.BigDecimal, value=1665 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=deviceId 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDeviceCd] result: i=5, type=java.math.BigDecimal, value=1 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=typeDeviceCd 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#typeDatatypeCd] result: i=6, type=java.math.BigDecimal, value=5 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=typeDatatypeCd 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createDt] result: i=7, type=java.sql.Timestamp, value=2005-11-30 14:54:47.041 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=createDt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#createUserTxt] result: i=8, type=java.lang.String, value=GUEST 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=createUserTxt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#lastUpdateDt] result: i=9, type=java.sql.Timestamp, value=2005-11-30 14:54:47.041 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=lastUpdateDt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.DeviceExtRO#updateUserTxt] result: i=10, type=java.lang.String, value=GUEST 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add preload data: entity=DeviceExtRO pk=3 field=updateUserTxt 2005-12-07 15:23:54,086 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.DeviceExtRO] Add finder results: entity=DeviceExtRO results=[1, 2, 3] readahead=[JDBCReadAheadMetaData : strategy=on-find, pageSize=255, eagerLoadGroup=*, left-join[]]