0 Replies Latest reply on Dec 7, 2005 5:41 PM by jason1

    Help interpretting CMP plugin cache logging

    jason1 Newbie

      I 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[]]