-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 8 posts ] 
Author Message
 Post subject: Why oscache can't cache object?
PostPosted: Tue Aug 31, 2004 11:23 pm 
Senior
Senior

Joined: Wed Dec 17, 2003 4:24 am
Posts: 188
2.1.6



<hibernate-mapping>
<class name="lyo.test.bean.Trade" table="tradetest">
<cache usage="read-write"/>
<id name="trade_id" column="trade_id" type="int">
<generator class="native"/>
</id>
<property name="trade_name" column="trade_name"/>
<property name="trade_desc" column="trade_desc"/>
</class>
</hibernate-mapping>



Session s=HibernateUtil.currentSession();
Transaction t=s.beginTransaction();
List list=s.find("from Trade");
t.commit();
HibernateUtil.closeSession();
return list;


Full stack trace of any exception that occurs: NO



3.23.56


info

I want to use OSCache with Hibernate. I set the
Code:
hibernate.cache.provider_class net.sf.hibernate.cache.OSCacheProvider
.
But hibernate will query database everytime when I refresh the jsp page.
I mean that console will output:
Code:

Hibernate: select trade0_.trade_id as trade_id, trade0_.trade_name as trade_name
, trade0_.trade_desc as trade_desc from tradetest trade0_


If I refresh my view.jsp
Code:
<body bgcolor="#663300">

TestingHiber<table align="right"><tr><td><a href="test.jsp">post newTopic</a></td><td><a href="/HibernateTest/view">View DB</a></td></tr></table>
<hr/>
<display:table name="tradeList" export="true"/>
</body>

</html>


My servlet code is:
Code:
public void doGet(HttpServletRequest req,HttpServletResponse resp)throws ServletException,IOException{
      doPost(req,resp);
   }
   public void doPost(HttpServletRequest req,HttpServletResponse resp)throws ServletException,IOException{

      List list=null;
      try{
         TradeDAO tdao=DAOFactory.getTradeDAOInstance();

          list=tdao.getTrades();
       }catch(Exception e){
          e.printStackTrace();
       }
       req.setAttribute("tradeList",list);
       req.getRequestDispatcher("/view.jsp").forward(req,resp);

The first time I execute the servlet . Console output:
Code:

10:53:50,343  INFO SettingsFactory:129 - cache provider: net.sf.hibernate.cache.
OSCacheProvider
10:53:50,390  INFO SettingsFactory:141 - query cache factory: net.sf.hibernate.c
ache.StandardQueryCacheFactory
10:53:50,406  INFO Configuration:1116 - instantiating and configuring caches
10:53:50,671  INFO SessionFactoryImpl:118 - building session factory
10:53:51,218  INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI,
no JNDI name configured
10:53:51,218  INFO UpdateTimestampsCache:35 - starting update timestamps cache a
t region: net.sf.hibernate.cache.UpdateTimestampsCache
10:53:51,218  INFO StandardQueryCache:41 - starting query cache at region: net.s
f.hibernate.cache.StandardQueryCache
Hibernate: select trade0_.trade_id as trade_id, trade0_.trade_name as trade_name
, trade0_.trade_desc as trade_desc from tradetest trade0_

Why OSCache don't work ? help!

_________________
You are not alone...


Top
 Profile  
 
 Post subject: RE: Why OSCache won't cache objects
PostPosted: Tue Sep 21, 2004 12:39 pm 
Regular
Regular

Joined: Tue Jun 22, 2004 8:01 pm
Posts: 106
Location: PowderTown, Utah, USA
One important thing to remember is that OSCache is the second level cache, which means that it's not going to cache objects anyway, it caches "raw" data. Hibernate has two caches, the first level and the second level. The first level caches objects used in an individual hibernate session. The second level cache caches data only, not objects.

But, I'm sure you're still wondering why you're not getting hits in your cache. One possible reason is that you're using an HQL query to load the objects. The cache is used most often for relationships and lazy collections where objects can be loaded by ID. Think about it though, if you use an HQL query, there's no way Hibernate can know what kind of ID's will be returned util AFTER the query is executed. At that point, if possible, the cached ID data can be used.

I really see most of the benefit from cacheing with my related objects and lazily related collections. That's where it really shines.

But, to find out what's REALLY going on, you should enable DEBUG level logging on Hibernate. For example, put the following line in your log4j.properties file:

log4j.category.net.sf.hibernate=DEBUG

You'll get a deluge of logging statements, but you can trace exactly what hibernate is doing.

And, if all else fails, get the source code and fire up your debugger. Nothing explains how Hibernate works like digging in to the source code.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Sep 21, 2004 1:06 pm 
Regular
Regular

Joined: Tue Oct 28, 2003 8:25 am
Posts: 72
Location: Belgium
This is not totally correct. There is also the query cache that can cache HQL queries result (http://www.hibernate.org/hib_docs/refer ... querycache).

Showing us the code of the TradeDAO.getTrades() method could help us answer your question.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Sep 21, 2004 1:08 pm 
Hibernate Team
Hibernate Team

Joined: Thu Dec 18, 2003 9:55 am
Posts: 1977
Location: France
try query.iterate() instead of query.list()...

_________________
Anthony,
Get value thanks to your skills: http://www.redhat.com/certification


Top
 Profile  
 
 Post subject:
PostPosted: Tue Sep 21, 2004 1:10 pm 
Hibernate Team
Hibernate Team

Joined: Thu Dec 18, 2003 9:55 am
Posts: 1977
Location: France
oh, cardsharp is right with
Quote:
But, I'm sure you're still wondering why you're not getting hits in your cache. One possible reason is that you're using an HQL query to load the objects.


that's why you should use iterate, it gets only the id's, the cache is hit then to retrieve full objects...

_________________
Anthony,
Get value thanks to your skills: http://www.redhat.com/certification


Top
 Profile  
 
 Post subject: :-)
PostPosted: Wed Sep 22, 2004 9:44 pm 
Senior
Senior

Joined: Wed Dec 17, 2003 4:24 am
Posts: 188
Quote:
I'm sure you're still wondering why you're not getting hits in your cache. One possible reason is that you're using an HQL query to load the objects.


what? It can't be cached if I use the HQL query? But the hibernate docs says that it should be cached if I use find or iterator. The following is my code :
Code:
Session s=HibernateUtil.currentSession();
      Transaction t=s.beginTransaction();
      List list=s.find("from Trade t");
      t.commit();
      HibernateUtil.closeSession();
      return list;


Is there any problem? You mean that the
Code:
from Trade
is a kind of HQL query,So it couldn't be cached?

_________________
You are not alone...


Top
 Profile  
 
 Post subject:
PostPosted: Thu Sep 23, 2004 1:55 am 
Hibernate Team
Hibernate Team

Joined: Thu Dec 18, 2003 9:55 am
Posts: 1977
Location: France
no i mean that you should change
List list=s.find("from Trade t");
to
Iterator it=s.iterate("from Trade t");


then you can fill a list from the iterator if you want

or better: cache also the query (using a query of course)

_________________
Anthony,
Get value thanks to your skills: http://www.redhat.com/certification


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 14, 2004 1:44 pm 
Beginner
Beginner

Joined: Fri Aug 13, 2004 3:07 pm
Posts: 44
I am also facing a problem in caching of objects using OSCache. As per your suggestions. I have changed my code to use query.iterate() from query.list()

My hibernate.cfg.xml looks has the following conf:

Code:
<property name="hibernate.cache.provider_class">net.sf.hibernate.cache.OSCacheProvider</property>
      <property name="hibernate.cache.use_query_cache">true</property>


and my code is as follows:

Code:
         Query query = session.getNamedQuery("incidents.all");
         String statusName = (status == null) ? "%" : status.getName();
         query.setString("iStatus", statusName);
         query.setCacheable(true);
         Iterator qIter = query.iterate();
         logger.debug("Iterator class is " + qIter.getClass().getName());
         // Add all the elements from the iterator to the list
         for(; qIter.hasNext(); incidents.add(qIter.next()));
         //incidents.addAll(query.list());



Here is the debug log from Tomcat:
[code]
2004-10-14 13:36:12,666 [com.waypoint.tripwire.rs.servlet.IncidentServlet.doGet] DEBUG - Processing the user request
2004-10-14 13:36:12,666 [com.waypoint.rs.incident.IncidentManager.getIncidents] DEBUG - Retrieving incidents with status Pending
2004-10-14 13:36:12,666 [com.waypoint.rs.incident.IncidentManager.getIncidents] DEBUG - Getting URL for /local.cfg.xml
2004-10-14 13:36:12,666 [com.waypoint.rs.incident.IncidentManager.getIncidents] DEBUG - Got url file:C:/Tomcat5.0/common/classes/local.cfg.xml
2004-10-14 13:36:12,976 [com.opensymphony.oscache.base.Config.<init>] DEBUG - Config() called
2004-10-14 13:36:12,976 [com.opensymphony.oscache.base.Config.loadProps] DEBUG - Getting Config
2004-10-14 13:36:12,976 [com.opensymphony.oscache.base.Config.loadProps] INFO - Properties {cache.blocking=true, cache.capacity=10000}
2004-10-14 13:36:12,976 [com.opensymphony.oscache.base.AbstractCacheAdministrator.<init>] DEBUG - Constructed AbstractCacheAdministrator()
2004-10-14 13:36:12,976 [com.opensymphony.oscache.general.GeneralCacheAdministrator.<init>] INFO - Constructed GeneralCacheAdministrator()
2004-10-14 13:36:12,976 [com.opensymphony.oscache.general.GeneralCacheAdministrator.createCache] INFO - Creating new cache
2004-10-14 13:36:13,056 [com.opensymphony.oscache.base.Config.<init>] DEBUG - Config() called
2004-10-14 13:36:13,056 [com.opensymphony.oscache.base.Config.loadProps] DEBUG - Getting Config
2004-10-14 13:36:13,137 [com.opensymphony.oscache.base.Config.loadProps] INFO - Properties {cache.blocking=true, cache.capacity=10000}
2004-10-14 13:36:13,137 [com.opensymphony.oscache.base.AbstractCacheAdministrator.<init>] DEBUG - Constructed AbstractCacheAdministrator()
2004-10-14 13:36:13,137 [com.opensymphony.oscache.general.GeneralCacheAdministrator.<init>] INFO - Constructed GeneralCacheAdministrator()
2004-10-14 13:36:13,137 [com.opensymphony.oscache.general.GeneralCacheAdministrator.createCache] INFO - Creating new cache
2004-10-14 13:36:13,137 [com.opensymphony.oscache.base.Config.<init>] DEBUG - Config() called
2004-10-14 13:36:13,137 [com.opensymphony.oscache.base.Config.loadProps] DEBUG - Getting Config
2004-10-14 13:36:13,157 [com.opensymphony.oscache.base.Config.loadProps] INFO - Properties {cache.blocking=true, cache.capacity=10000}
2004-10-14 13:36:13,157 [com.opensymphony.oscache.base.AbstractCacheAdministrator.<init>] DEBUG - Constructed AbstractCacheAdministrator()
2004-10-14 13:36:13,157 [com.opensymphony.oscache.general.GeneralCacheAdministrator.<init>] INFO - Constructed GeneralCacheAdministrator()
2004-10-14 13:36:13,157 [com.opensymphony.oscache.general.GeneralCacheAdministrator.createCache] INFO - Creating new cache
2004-10-14 13:36:13,157 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select incident0_.INCIDENT_ID as x0_0_ from RS_INCIDENT incident0_ where (incident0_.STATUS like ? )
2004-10-14 13:36:13,197 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=2.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,197 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=2.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,197 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='2.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:13,197 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select incident0_.INCIDENT_ID as INCIDENT1_1_, case when incident0__1_.INCIDENT_ID is not null then 1 when incident0_.INCIDENT_ID is not null then 0 end as clazz_1_, incident0_.NAME as NAME113_1_, incident0_.TIMESTAMP as TIMESTAMP113_1_, incident0_.MOD_TIMESTAMP as MOD_TIME4_113_1_, incident0_.STATUS as STATUS113_1_, incident0_.HOST_ID as HOST_ID113_1_, incident0__1_.STARTPOINT as STARTPOINT114_1_, incident0__1_.TICKET_NO as TICKET_NO114_1_, incident0__1_.COMMENTS as COMMENTS114_1_, incident0__1_.CONTACT as CONTACT114_1_, incident0__1_.SEVERITY as SEVERITY114_1_, incident0__1_.ON_VIOLATION as ON_VIOLA7_114_1_, incident0__1_.MATCH as MATCH114_1_, incident0__1_.VIOLATIONCOUNT as VIOLATIO9_114_1_, incident0__1_.ADDEDCOUNT as ADDEDCOUNT114_1_, incident0__1_.CHANGEDCOUNT as CHANGED11_114_1_, incident0__1_.REMOVEDCOUNT as REMOVED12_114_1_, incidentho1_.HOST_ID as HOST_ID0_, incidentho1_.HOSTNAME as HOSTNAME0_, incidentho1_.IPADDRESS as IPADDRESS0_ from RS_INCIDENT incident0_ left outer join RS_TW_INCDT incident0__1_ on incident0_.INCIDENT_ID=incident0__1_.INCIDENT_ID left outer join RS_INCDT_HOST incidentho1_ on incident0_.HOST_ID=incidentho1_.HOST_ID where incident0_.INCIDENT_ID=?
2004-10-14 13:36:13,377 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=2.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,377 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=2.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,377 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='2.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:13,377 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=2.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,377 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=2.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,377 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='2.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:13,377 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistStore] DEBUG - persistStore called (key=2.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,387 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select removed0_.ID as ID__, removed0_.INCIDENT_ID as INCIDENT4___, removed0_.ID as ID0_, removed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT removed0_ where removed0_.INCIDENT_ID=? and removed0_.OBJECT_TYPE='REMOVED'
2004-10-14 13:36:13,437 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select changed0_.ID as ID__, changed0_.INCIDENT_ID as INCIDENT4___, changed0_.ID as ID0_, changed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT changed0_ where changed0_.INCIDENT_ID=? and changed0_.OBJECT_TYPE='CHANGED'
2004-10-14 13:36:13,487 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select added0_.ID as ID__, added0_.INCIDENT_ID as INCIDENT4___, added0_.ID as ID0_, added0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT added0_ where added0_.INCIDENT_ID=? and added0_.OBJECT_TYPE='ADDED'
2004-10-14 13:36:13,547 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select errors0_.error as error__, errors0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_ERRORS errors0_ where errors0_.INCIDENT_ID=?
2004-10-14 13:36:13,547 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select emailaddre0_.email as email__, emailaddre0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_EMAIL emailaddre0_ where emailaddre0_.INCIDENT_ID=?
2004-10-14 13:36:13,547 [com.waypoint.rs.incident.IncidentManager.getIncidents] DEBUG - Iterator class is net.sf.hibernate.impl.IteratorImpl
2004-10-14 13:36:13,547 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=864.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,547 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=864.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,547 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='864.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:13,557 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select incident0_.INCIDENT_ID as INCIDENT1_1_, case when incident0__1_.INCIDENT_ID is not null then 1 when incident0_.INCIDENT_ID is not null then 0 end as clazz_1_, incident0_.NAME as NAME113_1_, incident0_.TIMESTAMP as TIMESTAMP113_1_, incident0_.MOD_TIMESTAMP as MOD_TIME4_113_1_, incident0_.STATUS as STATUS113_1_, incident0_.HOST_ID as HOST_ID113_1_, incident0__1_.STARTPOINT as STARTPOINT114_1_, incident0__1_.TICKET_NO as TICKET_NO114_1_, incident0__1_.COMMENTS as COMMENTS114_1_, incident0__1_.CONTACT as CONTACT114_1_, incident0__1_.SEVERITY as SEVERITY114_1_, incident0__1_.ON_VIOLATION as ON_VIOLA7_114_1_, incident0__1_.MATCH as MATCH114_1_, incident0__1_.VIOLATIONCOUNT as VIOLATIO9_114_1_, incident0__1_.ADDEDCOUNT as ADDEDCOUNT114_1_, incident0__1_.CHANGEDCOUNT as CHANGED11_114_1_, incident0__1_.REMOVEDCOUNT as REMOVED12_114_1_, incidentho1_.HOST_ID as HOST_ID0_, incidentho1_.HOSTNAME as HOSTNAME0_, incidentho1_.IPADDRESS as IPADDRESS0_ from RS_INCIDENT incident0_ left outer join RS_TW_INCDT incident0__1_ on incident0_.INCIDENT_ID=incident0__1_.INCIDENT_ID left outer join RS_INCDT_HOST incidentho1_ on incident0_.HOST_ID=incidentho1_.HOST_ID where incident0_.INCIDENT_ID=?
2004-10-14 13:36:13,557 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=864.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,557 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=864.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,557 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='864.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:13,557 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=864.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,567 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=864.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,567 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='864.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:13,567 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistStore] DEBUG - persistStore called (key=864.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,567 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select removed0_.ID as ID__, removed0_.INCIDENT_ID as INCIDENT4___, removed0_.ID as ID0_, removed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT removed0_ where removed0_.INCIDENT_ID=? and removed0_.OBJECT_TYPE='REMOVED'
2004-10-14 13:36:13,617 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select changed0_.ID as ID__, changed0_.INCIDENT_ID as INCIDENT4___, changed0_.ID as ID0_, changed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT changed0_ where changed0_.INCIDENT_ID=? and changed0_.OBJECT_TYPE='CHANGED'
2004-10-14 13:36:13,697 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select added0_.ID as ID__, added0_.INCIDENT_ID as INCIDENT4___, added0_.ID as ID0_, added0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT added0_ where added0_.INCIDENT_ID=? and added0_.OBJECT_TYPE='ADDED'
2004-10-14 13:36:13,747 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select errors0_.error as error__, errors0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_ERRORS errors0_ where errors0_.INCIDENT_ID=?
2004-10-14 13:36:13,747 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select emailaddre0_.email as email__, emailaddre0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_EMAIL emailaddre0_ where emailaddre0_.INCIDENT_ID=?
2004-10-14 13:36:13,747 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=1033.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,757 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=1033.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,757 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='1033.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:13,757 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select incident0_.INCIDENT_ID as INCIDENT1_1_, case when incident0__1_.INCIDENT_ID is not null then 1 when incident0_.INCIDENT_ID is not null then 0 end as clazz_1_, incident0_.NAME as NAME113_1_, incident0_.TIMESTAMP as TIMESTAMP113_1_, incident0_.MOD_TIMESTAMP as MOD_TIME4_113_1_, incident0_.STATUS as STATUS113_1_, incident0_.HOST_ID as HOST_ID113_1_, incident0__1_.STARTPOINT as STARTPOINT114_1_, incident0__1_.TICKET_NO as TICKET_NO114_1_, incident0__1_.COMMENTS as COMMENTS114_1_, incident0__1_.CONTACT as CONTACT114_1_, incident0__1_.SEVERITY as SEVERITY114_1_, incident0__1_.ON_VIOLATION as ON_VIOLA7_114_1_, incident0__1_.MATCH as MATCH114_1_, incident0__1_.VIOLATIONCOUNT as VIOLATIO9_114_1_, incident0__1_.ADDEDCOUNT as ADDEDCOUNT114_1_, incident0__1_.CHANGEDCOUNT as CHANGED11_114_1_, incident0__1_.REMOVEDCOUNT as REMOVED12_114_1_, incidentho1_.HOST_ID as HOST_ID0_, incidentho1_.HOSTNAME as HOSTNAME0_, incidentho1_.IPADDRESS as IPADDRESS0_ from RS_INCIDENT incident0_ left outer join RS_TW_INCDT incident0__1_ on incident0_.INCIDENT_ID=incident0__1_.INCIDENT_ID left outer join RS_INCDT_HOST incidentho1_ on incident0_.HOST_ID=incidentho1_.HOST_ID where incident0_.INCIDENT_ID=?
2004-10-14 13:36:13,757 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=1033.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,757 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=1033.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,768 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='1033.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:13,768 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=1033.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,768 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=1033.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,768 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='1033.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:13,768 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistStore] DEBUG - persistStore called (key=1033.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,768 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select removed0_.ID as ID__, removed0_.INCIDENT_ID as INCIDENT4___, removed0_.ID as ID0_, removed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT removed0_ where removed0_.INCIDENT_ID=? and removed0_.OBJECT_TYPE='REMOVED'
2004-10-14 13:36:13,828 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select changed0_.ID as ID__, changed0_.INCIDENT_ID as INCIDENT4___, changed0_.ID as ID0_, changed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT changed0_ where changed0_.INCIDENT_ID=? and changed0_.OBJECT_TYPE='CHANGED'
2004-10-14 13:36:13,878 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select added0_.ID as ID__, added0_.INCIDENT_ID as INCIDENT4___, added0_.ID as ID0_, added0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT added0_ where added0_.INCIDENT_ID=? and added0_.OBJECT_TYPE='ADDED'
2004-10-14 13:36:13,928 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select errors0_.error as error__, errors0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_ERRORS errors0_ where errors0_.INCIDENT_ID=?
2004-10-14 13:36:13,928 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select emailaddre0_.email as email__, emailaddre0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_EMAIL emailaddre0_ where emailaddre0_.INCIDENT_ID=?
2004-10-14 13:36:13,928 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=11224.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,928 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=11224.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,928 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='11224.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:13,928 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select incident0_.INCIDENT_ID as INCIDENT1_1_, case when incident0__1_.INCIDENT_ID is not null then 1 when incident0_.INCIDENT_ID is not null then 0 end as clazz_1_, incident0_.NAME as NAME113_1_, incident0_.TIMESTAMP as TIMESTAMP113_1_, incident0_.MOD_TIMESTAMP as MOD_TIME4_113_1_, incident0_.STATUS as STATUS113_1_, incident0_.HOST_ID as HOST_ID113_1_, incident0__1_.STARTPOINT as STARTPOINT114_1_, incident0__1_.TICKET_NO as TICKET_NO114_1_, incident0__1_.COMMENTS as COMMENTS114_1_, incident0__1_.CONTACT as CONTACT114_1_, incident0__1_.SEVERITY as SEVERITY114_1_, incident0__1_.ON_VIOLATION as ON_VIOLA7_114_1_, incident0__1_.MATCH as MATCH114_1_, incident0__1_.VIOLATIONCOUNT as VIOLATIO9_114_1_, incident0__1_.ADDEDCOUNT as ADDEDCOUNT114_1_, incident0__1_.CHANGEDCOUNT as CHANGED11_114_1_, incident0__1_.REMOVEDCOUNT as REMOVED12_114_1_, incidentho1_.HOST_ID as HOST_ID0_, incidentho1_.HOSTNAME as HOSTNAME0_, incidentho1_.IPADDRESS as IPADDRESS0_ from RS_INCIDENT incident0_ left outer join RS_TW_INCDT incident0__1_ on incident0_.INCIDENT_ID=incident0__1_.INCIDENT_ID left outer join RS_INCDT_HOST incidentho1_ on incident0_.HOST_ID=incidentho1_.HOST_ID where incident0_.INCIDENT_ID=?
2004-10-14 13:36:13,938 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=11224.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,938 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=11224.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,938 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='11224.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:13,938 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=11224.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,938 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=11224.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,938 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='11224.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:13,948 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistStore] DEBUG - persistStore called (key=11224.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:13,948 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select removed0_.ID as ID__, removed0_.INCIDENT_ID as INCIDENT4___, removed0_.ID as ID0_, removed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT removed0_ where removed0_.INCIDENT_ID=? and removed0_.OBJECT_TYPE='REMOVED'
2004-10-14 13:36:13,998 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select changed0_.ID as ID__, changed0_.INCIDENT_ID as INCIDENT4___, changed0_.ID as ID0_, changed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT changed0_ where changed0_.INCIDENT_ID=? and changed0_.OBJECT_TYPE='CHANGED'
2004-10-14 13:36:14,048 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select added0_.ID as ID__, added0_.INCIDENT_ID as INCIDENT4___, added0_.ID as ID0_, added0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT added0_ where added0_.INCIDENT_ID=? and added0_.OBJECT_TYPE='ADDED'
2004-10-14 13:36:14,098 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select errors0_.error as error__, errors0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_ERRORS errors0_ where errors0_.INCIDENT_ID=?
2004-10-14 13:36:14,098 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select emailaddre0_.email as email__, emailaddre0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_EMAIL emailaddre0_ where emailaddre0_.INCIDENT_ID=?
2004-10-14 13:36:14,108 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=11231.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,108 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=11231.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,108 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='11231.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:14,108 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select incident0_.INCIDENT_ID as INCIDENT1_1_, case when incident0__1_.INCIDENT_ID is not null then 1 when incident0_.INCIDENT_ID is not null then 0 end as clazz_1_, incident0_.NAME as NAME113_1_, incident0_.TIMESTAMP as TIMESTAMP113_1_, incident0_.MOD_TIMESTAMP as MOD_TIME4_113_1_, incident0_.STATUS as STATUS113_1_, incident0_.HOST_ID as HOST_ID113_1_, incident0__1_.STARTPOINT as STARTPOINT114_1_, incident0__1_.TICKET_NO as TICKET_NO114_1_, incident0__1_.COMMENTS as COMMENTS114_1_, incident0__1_.CONTACT as CONTACT114_1_, incident0__1_.SEVERITY as SEVERITY114_1_, incident0__1_.ON_VIOLATION as ON_VIOLA7_114_1_, incident0__1_.MATCH as MATCH114_1_, incident0__1_.VIOLATIONCOUNT as VIOLATIO9_114_1_, incident0__1_.ADDEDCOUNT as ADDEDCOUNT114_1_, incident0__1_.CHANGEDCOUNT as CHANGED11_114_1_, incident0__1_.REMOVEDCOUNT as REMOVED12_114_1_, incidentho1_.HOST_ID as HOST_ID0_, incidentho1_.HOSTNAME as HOSTNAME0_, incidentho1_.IPADDRESS as IPADDRESS0_ from RS_INCIDENT incident0_ left outer join RS_TW_INCDT incident0__1_ on incident0_.INCIDENT_ID=incident0__1_.INCIDENT_ID left outer join RS_INCDT_HOST incidentho1_ on incident0_.HOST_ID=incidentho1_.HOST_ID where incident0_.INCIDENT_ID=?
2004-10-14 13:36:14,108 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=11231.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,108 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=11231.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,108 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='11231.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:14,108 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=11231.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,108 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=11231.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,108 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='11231.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:14,108 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistStore] DEBUG - persistStore called (key=11231.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,108 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select removed0_.ID as ID__, removed0_.INCIDENT_ID as INCIDENT4___, removed0_.ID as ID0_, removed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT removed0_ where removed0_.INCIDENT_ID=? and removed0_.OBJECT_TYPE='REMOVED'
2004-10-14 13:36:14,168 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select changed0_.ID as ID__, changed0_.INCIDENT_ID as INCIDENT4___, changed0_.ID as ID0_, changed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT changed0_ where changed0_.INCIDENT_ID=? and changed0_.OBJECT_TYPE='CHANGED'
2004-10-14 13:36:14,218 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select added0_.ID as ID__, added0_.INCIDENT_ID as INCIDENT4___, added0_.ID as ID0_, added0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT added0_ where added0_.INCIDENT_ID=? and added0_.OBJECT_TYPE='ADDED'
2004-10-14 13:36:14,268 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select errors0_.error as error__, errors0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_ERRORS errors0_ where errors0_.INCIDENT_ID=?
2004-10-14 13:36:14,278 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select emailaddre0_.email as email__, emailaddre0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_EMAIL emailaddre0_ where emailaddre0_.INCIDENT_ID=?
2004-10-14 13:36:14,278 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=11234.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,278 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=11234.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,288 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='11234.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:14,288 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select incident0_.INCIDENT_ID as INCIDENT1_1_, case when incident0__1_.INCIDENT_ID is not null then 1 when incident0_.INCIDENT_ID is not null then 0 end as clazz_1_, incident0_.NAME as NAME113_1_, incident0_.TIMESTAMP as TIMESTAMP113_1_, incident0_.MOD_TIMESTAMP as MOD_TIME4_113_1_, incident0_.STATUS as STATUS113_1_, incident0_.HOST_ID as HOST_ID113_1_, incident0__1_.STARTPOINT as STARTPOINT114_1_, incident0__1_.TICKET_NO as TICKET_NO114_1_, incident0__1_.COMMENTS as COMMENTS114_1_, incident0__1_.CONTACT as CONTACT114_1_, incident0__1_.SEVERITY as SEVERITY114_1_, incident0__1_.ON_VIOLATION as ON_VIOLA7_114_1_, incident0__1_.MATCH as MATCH114_1_, incident0__1_.VIOLATIONCOUNT as VIOLATIO9_114_1_, incident0__1_.ADDEDCOUNT as ADDEDCOUNT114_1_, incident0__1_.CHANGEDCOUNT as CHANGED11_114_1_, incident0__1_.REMOVEDCOUNT as REMOVED12_114_1_, incidentho1_.HOST_ID as HOST_ID0_, incidentho1_.HOSTNAME as HOSTNAME0_, incidentho1_.IPADDRESS as IPADDRESS0_ from RS_INCIDENT incident0_ left outer join RS_TW_INCDT incident0__1_ on incident0_.INCIDENT_ID=incident0__1_.INCIDENT_ID left outer join RS_INCDT_HOST incidentho1_ on incident0_.HOST_ID=incidentho1_.HOST_ID where incident0_.INCIDENT_ID=?
2004-10-14 13:36:14,298 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=11234.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,298 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=11234.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,298 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='11234.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:14,298 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=11234.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,298 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=11234.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,298 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='11234.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:14,298 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistStore] DEBUG - persistStore called (key=11234.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,298 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select removed0_.ID as ID__, removed0_.INCIDENT_ID as INCIDENT4___, removed0_.ID as ID0_, removed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT removed0_ where removed0_.INCIDENT_ID=? and removed0_.OBJECT_TYPE='REMOVED'
2004-10-14 13:36:14,348 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select changed0_.ID as ID__, changed0_.INCIDENT_ID as INCIDENT4___, changed0_.ID as ID0_, changed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT changed0_ where changed0_.INCIDENT_ID=? and changed0_.OBJECT_TYPE='CHANGED'
2004-10-14 13:36:14,419 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select added0_.ID as ID__, added0_.INCIDENT_ID as INCIDENT4___, added0_.ID as ID0_, added0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT added0_ where added0_.INCIDENT_ID=? and added0_.OBJECT_TYPE='ADDED'
2004-10-14 13:36:14,469 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select errors0_.error as error__, errors0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_ERRORS errors0_ where errors0_.INCIDENT_ID=?
2004-10-14 13:36:14,469 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select emailaddre0_.email as email__, emailaddre0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_EMAIL emailaddre0_ where emailaddre0_.INCIDENT_ID=?
2004-10-14 13:36:14,479 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=12073.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,479 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=12073.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,479 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='12073.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:14,479 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select incident0_.INCIDENT_ID as INCIDENT1_1_, case when incident0__1_.INCIDENT_ID is not null then 1 when incident0_.INCIDENT_ID is not null then 0 end as clazz_1_, incident0_.NAME as NAME113_1_, incident0_.TIMESTAMP as TIMESTAMP113_1_, incident0_.MOD_TIMESTAMP as MOD_TIME4_113_1_, incident0_.STATUS as STATUS113_1_, incident0_.HOST_ID as HOST_ID113_1_, incident0__1_.STARTPOINT as STARTPOINT114_1_, incident0__1_.TICKET_NO as TICKET_NO114_1_, incident0__1_.COMMENTS as COMMENTS114_1_, incident0__1_.CONTACT as CONTACT114_1_, incident0__1_.SEVERITY as SEVERITY114_1_, incident0__1_.ON_VIOLATION as ON_VIOLA7_114_1_, incident0__1_.MATCH as MATCH114_1_, incident0__1_.VIOLATIONCOUNT as VIOLATIO9_114_1_, incident0__1_.ADDEDCOUNT as ADDEDCOUNT114_1_, incident0__1_.CHANGEDCOUNT as CHANGED11_114_1_, incident0__1_.REMOVEDCOUNT as REMOVED12_114_1_, incidentho1_.HOST_ID as HOST_ID0_, incidentho1_.HOSTNAME as HOSTNAME0_, incidentho1_.IPADDRESS as IPADDRESS0_ from RS_INCIDENT incident0_ left outer join RS_TW_INCDT incident0__1_ on incident0_.INCIDENT_ID=incident0__1_.INCIDENT_ID left outer join RS_INCDT_HOST incidentho1_ on incident0_.HOST_ID=incidentho1_.HOST_ID where incident0_.INCIDENT_ID=?
2004-10-14 13:36:14,479 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=12073.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,479 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=12073.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,479 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='12073.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:14,489 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=12073.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,489 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=12073.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,489 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='12073.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:14,489 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistStore] DEBUG - persistStore called (key=12073.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,489 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select removed0_.ID as ID__, removed0_.INCIDENT_ID as INCIDENT4___, removed0_.ID as ID0_, removed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT removed0_ where removed0_.INCIDENT_ID=? and removed0_.OBJECT_TYPE='REMOVED'
2004-10-14 13:36:14,539 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select changed0_.ID as ID__, changed0_.INCIDENT_ID as INCIDENT4___, changed0_.ID as ID0_, changed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT changed0_ where changed0_.INCIDENT_ID=? and changed0_.OBJECT_TYPE='CHANGED'
2004-10-14 13:36:14,589 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select added0_.ID as ID__, added0_.INCIDENT_ID as INCIDENT4___, added0_.ID as ID0_, added0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT added0_ where added0_.INCIDENT_ID=? and added0_.OBJECT_TYPE='ADDED'
2004-10-14 13:36:14,649 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select errors0_.error as error__, errors0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_ERRORS errors0_ where errors0_.INCIDENT_ID=?
2004-10-14 13:36:14,649 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select emailaddre0_.email as email__, emailaddre0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_EMAIL emailaddre0_ where emailaddre0_.INCIDENT_ID=?
2004-10-14 13:36:14,649 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=12242.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,649 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=12242.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,649 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='12242.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:14,649 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select incident0_.INCIDENT_ID as INCIDENT1_1_, case when incident0__1_.INCIDENT_ID is not null then 1 when incident0_.INCIDENT_ID is not null then 0 end as clazz_1_, incident0_.NAME as NAME113_1_, incident0_.TIMESTAMP as TIMESTAMP113_1_, incident0_.MOD_TIMESTAMP as MOD_TIME4_113_1_, incident0_.STATUS as STATUS113_1_, incident0_.HOST_ID as HOST_ID113_1_, incident0__1_.STARTPOINT as STARTPOINT114_1_, incident0__1_.TICKET_NO as TICKET_NO114_1_, incident0__1_.COMMENTS as COMMENTS114_1_, incident0__1_.CONTACT as CONTACT114_1_, incident0__1_.SEVERITY as SEVERITY114_1_, incident0__1_.ON_VIOLATION as ON_VIOLA7_114_1_, incident0__1_.MATCH as MATCH114_1_, incident0__1_.VIOLATIONCOUNT as VIOLATIO9_114_1_, incident0__1_.ADDEDCOUNT as ADDEDCOUNT114_1_, incident0__1_.CHANGEDCOUNT as CHANGED11_114_1_, incident0__1_.REMOVEDCOUNT as REMOVED12_114_1_, incidentho1_.HOST_ID as HOST_ID0_, incidentho1_.HOSTNAME as HOSTNAME0_, incidentho1_.IPADDRESS as IPADDRESS0_ from RS_INCIDENT incident0_ left outer join RS_TW_INCDT incident0__1_ on incident0_.INCIDENT_ID=incident0__1_.INCIDENT_ID left outer join RS_INCDT_HOST incidentho1_ on incident0_.HOST_ID=incidentho1_.HOST_ID where incident0_.INCIDENT_ID=?
2004-10-14 13:36:14,659 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=12242.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,659 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=12242.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,659 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='12242.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:14,659 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=12242.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,659 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=12242.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,659 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='12242.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:14,669 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistStore] DEBUG - persistStore called (key=12242.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,669 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select removed0_.ID as ID__, removed0_.INCIDENT_ID as INCIDENT4___, removed0_.ID as ID0_, removed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT removed0_ where removed0_.INCIDENT_ID=? and removed0_.OBJECT_TYPE='REMOVED'
2004-10-14 13:36:14,719 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select changed0_.ID as ID__, changed0_.INCIDENT_ID as INCIDENT4___, changed0_.ID as ID0_, changed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT changed0_ where changed0_.INCIDENT_ID=? and changed0_.OBJECT_TYPE='CHANGED'
2004-10-14 13:36:14,769 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select added0_.ID as ID__, added0_.INCIDENT_ID as INCIDENT4___, added0_.ID as ID0_, added0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT added0_ where added0_.INCIDENT_ID=? and added0_.OBJECT_TYPE='ADDED'
2004-10-14 13:36:14,819 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select errors0_.error as error__, errors0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_ERRORS errors0_ where errors0_.INCIDENT_ID=?
2004-10-14 13:36:14,819 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select emailaddre0_.email as email__, emailaddre0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_EMAIL emailaddre0_ where emailaddre0_.INCIDENT_ID=?
2004-10-14 13:36:14,819 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=12260.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,819 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=12260.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,819 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='12260.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:14,819 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select incident0_.INCIDENT_ID as INCIDENT1_1_, case when incident0__1_.INCIDENT_ID is not null then 1 when incident0_.INCIDENT_ID is not null then 0 end as clazz_1_, incident0_.NAME as NAME113_1_, incident0_.TIMESTAMP as TIMESTAMP113_1_, incident0_.MOD_TIMESTAMP as MOD_TIME4_113_1_, incident0_.STATUS as STATUS113_1_, incident0_.HOST_ID as HOST_ID113_1_, incident0__1_.STARTPOINT as STARTPOINT114_1_, incident0__1_.TICKET_NO as TICKET_NO114_1_, incident0__1_.COMMENTS as COMMENTS114_1_, incident0__1_.CONTACT as CONTACT114_1_, incident0__1_.SEVERITY as SEVERITY114_1_, incident0__1_.ON_VIOLATION as ON_VIOLA7_114_1_, incident0__1_.MATCH as MATCH114_1_, incident0__1_.VIOLATIONCOUNT as VIOLATIO9_114_1_, incident0__1_.ADDEDCOUNT as ADDEDCOUNT114_1_, incident0__1_.CHANGEDCOUNT as CHANGED11_114_1_, incident0__1_.REMOVEDCOUNT as REMOVED12_114_1_, incidentho1_.HOST_ID as HOST_ID0_, incidentho1_.HOSTNAME as HOSTNAME0_, incidentho1_.IPADDRESS as IPADDRESS0_ from RS_INCIDENT incident0_ left outer join RS_TW_INCDT incident0__1_ on incident0_.INCIDENT_ID=incident0__1_.INCIDENT_ID left outer join RS_INCDT_HOST incidentho1_ on incident0_.HOST_ID=incidentho1_.HOST_ID where incident0_.INCIDENT_ID=?
2004-10-14 13:36:14,829 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=12260.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,829 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=12260.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,829 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='12260.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:14,829 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=12260.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,829 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=12260.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,829 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='12260.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:14,839 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistStore] DEBUG - persistStore called (key=12260.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:14,839 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select removed0_.ID as ID__, removed0_.INCIDENT_ID as INCIDENT4___, removed0_.ID as ID0_, removed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT removed0_ where removed0_.INCIDENT_ID=? and removed0_.OBJECT_TYPE='REMOVED'
2004-10-14 13:36:14,889 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select changed0_.ID as ID__, changed0_.INCIDENT_ID as INCIDENT4___, changed0_.ID as ID0_, changed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT changed0_ where changed0_.INCIDENT_ID=? and changed0_.OBJECT_TYPE='CHANGED'
2004-10-14 13:36:15,530 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select added0_.ID as ID__, added0_.INCIDENT_ID as INCIDENT4___, added0_.ID as ID0_, added0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT added0_ where added0_.INCIDENT_ID=? and added0_.OBJECT_TYPE='ADDED'
2004-10-14 13:36:15,590 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select errors0_.error as error__, errors0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_ERRORS errors0_ where errors0_.INCIDENT_ID=?
2004-10-14 13:36:15,590 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select emailaddre0_.email as email__, emailaddre0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_EMAIL emailaddre0_ where emailaddre0_.INCIDENT_ID=?
2004-10-14 13:36:15,590 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=22413.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,590 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=22413.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,590 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='22413.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:15,590 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select incident0_.INCIDENT_ID as INCIDENT1_1_, case when incident0__1_.INCIDENT_ID is not null then 1 when incident0_.INCIDENT_ID is not null then 0 end as clazz_1_, incident0_.NAME as NAME113_1_, incident0_.TIMESTAMP as TIMESTAMP113_1_, incident0_.MOD_TIMESTAMP as MOD_TIME4_113_1_, incident0_.STATUS as STATUS113_1_, incident0_.HOST_ID as HOST_ID113_1_, incident0__1_.STARTPOINT as STARTPOINT114_1_, incident0__1_.TICKET_NO as TICKET_NO114_1_, incident0__1_.COMMENTS as COMMENTS114_1_, incident0__1_.CONTACT as CONTACT114_1_, incident0__1_.SEVERITY as SEVERITY114_1_, incident0__1_.ON_VIOLATION as ON_VIOLA7_114_1_, incident0__1_.MATCH as MATCH114_1_, incident0__1_.VIOLATIONCOUNT as VIOLATIO9_114_1_, incident0__1_.ADDEDCOUNT as ADDEDCOUNT114_1_, incident0__1_.CHANGEDCOUNT as CHANGED11_114_1_, incident0__1_.REMOVEDCOUNT as REMOVED12_114_1_, incidentho1_.HOST_ID as HOST_ID0_, incidentho1_.HOSTNAME as HOSTNAME0_, incidentho1_.IPADDRESS as IPADDRESS0_ from RS_INCIDENT incident0_ left outer join RS_TW_INCDT incident0__1_ on incident0_.INCIDENT_ID=incident0__1_.INCIDENT_ID left outer join RS_INCDT_HOST incidentho1_ on incident0_.HOST_ID=incidentho1_.HOST_ID where incident0_.INCIDENT_ID=?
2004-10-14 13:36:15,600 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=22413.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,600 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=22413.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,600 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='22413.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:15,600 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=22413.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,600 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=22413.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,600 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='22413.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:15,600 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistStore] DEBUG - persistStore called (key=22413.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,600 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select removed0_.ID as ID__, removed0_.INCIDENT_ID as INCIDENT4___, removed0_.ID as ID0_, removed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT removed0_ where removed0_.INCIDENT_ID=? and removed0_.OBJECT_TYPE='REMOVED'
2004-10-14 13:36:15,650 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select changed0_.ID as ID__, changed0_.INCIDENT_ID as INCIDENT4___, changed0_.ID as ID0_, changed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT changed0_ where changed0_.INCIDENT_ID=? and changed0_.OBJECT_TYPE='CHANGED'
2004-10-14 13:36:15,701 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select added0_.ID as ID__, added0_.INCIDENT_ID as INCIDENT4___, added0_.ID as ID0_, added0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT added0_ where added0_.INCIDENT_ID=? and added0_.OBJECT_TYPE='ADDED'
2004-10-14 13:36:15,751 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select errors0_.error as error__, errors0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_ERRORS errors0_ where errors0_.INCIDENT_ID=?
2004-10-14 13:36:15,751 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select emailaddre0_.email as email__, emailaddre0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_EMAIL emailaddre0_ where emailaddre0_.INCIDENT_ID=?
2004-10-14 13:36:15,761 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=22419.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,761 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=22419.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,761 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='22419.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:15,761 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select incident0_.INCIDENT_ID as INCIDENT1_1_, case when incident0__1_.INCIDENT_ID is not null then 1 when incident0_.INCIDENT_ID is not null then 0 end as clazz_1_, incident0_.NAME as NAME113_1_, incident0_.TIMESTAMP as TIMESTAMP113_1_, incident0_.MOD_TIMESTAMP as MOD_TIME4_113_1_, incident0_.STATUS as STATUS113_1_, incident0_.HOST_ID as HOST_ID113_1_, incident0__1_.STARTPOINT as STARTPOINT114_1_, incident0__1_.TICKET_NO as TICKET_NO114_1_, incident0__1_.COMMENTS as COMMENTS114_1_, incident0__1_.CONTACT as CONTACT114_1_, incident0__1_.SEVERITY as SEVERITY114_1_, incident0__1_.ON_VIOLATION as ON_VIOLA7_114_1_, incident0__1_.MATCH as MATCH114_1_, incident0__1_.VIOLATIONCOUNT as VIOLATIO9_114_1_, incident0__1_.ADDEDCOUNT as ADDEDCOUNT114_1_, incident0__1_.CHANGEDCOUNT as CHANGED11_114_1_, incident0__1_.REMOVEDCOUNT as REMOVED12_114_1_, incidentho1_.HOST_ID as HOST_ID0_, incidentho1_.HOSTNAME as HOSTNAME0_, incidentho1_.IPADDRESS as IPADDRESS0_ from RS_INCIDENT incident0_ left outer join RS_TW_INCDT incident0__1_ on incident0_.INCIDENT_ID=incident0__1_.INCIDENT_ID left outer join RS_INCDT_HOST incidentho1_ on incident0_.HOST_ID=incidentho1_.HOST_ID where incident0_.INCIDENT_ID=?
2004-10-14 13:36:15,761 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=22419.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,761 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=22419.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,761 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='22419.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:15,761 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=22419.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,761 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=22419.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,771 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='22419.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:15,781 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistStore] DEBUG - persistStore called (key=22419.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,781 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select removed0_.ID as ID__, removed0_.INCIDENT_ID as INCIDENT4___, removed0_.ID as ID0_, removed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT removed0_ where removed0_.INCIDENT_ID=? and removed0_.OBJECT_TYPE='REMOVED'
2004-10-14 13:36:15,821 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select changed0_.ID as ID__, changed0_.INCIDENT_ID as INCIDENT4___, changed0_.ID as ID0_, changed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT changed0_ where changed0_.INCIDENT_ID=? and changed0_.OBJECT_TYPE='CHANGED'
2004-10-14 13:36:15,881 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select added0_.ID as ID__, added0_.INCIDENT_ID as INCIDENT4___, added0_.ID as ID0_, added0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT added0_ where added0_.INCIDENT_ID=? and added0_.OBJECT_TYPE='ADDED'
2004-10-14 13:36:15,921 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select errors0_.error as error__, errors0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_ERRORS errors0_ where errors0_.INCIDENT_ID=?
2004-10-14 13:36:15,931 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select emailaddre0_.email as email__, emailaddre0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_EMAIL emailaddre0_ where emailaddre0_.INCIDENT_ID=?
2004-10-14 13:36:15,931 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=22432.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,931 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=22432.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,931 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='22432.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:15,931 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select incident0_.INCIDENT_ID as INCIDENT1_1_, case when incident0__1_.INCIDENT_ID is not null then 1 when incident0_.INCIDENT_ID is not null then 0 end as clazz_1_, incident0_.NAME as NAME113_1_, incident0_.TIMESTAMP as TIMESTAMP113_1_, incident0_.MOD_TIMESTAMP as MOD_TIME4_113_1_, incident0_.STATUS as STATUS113_1_, incident0_.HOST_ID as HOST_ID113_1_, incident0__1_.STARTPOINT as STARTPOINT114_1_, incident0__1_.TICKET_NO as TICKET_NO114_1_, incident0__1_.COMMENTS as COMMENTS114_1_, incident0__1_.CONTACT as CONTACT114_1_, incident0__1_.SEVERITY as SEVERITY114_1_, incident0__1_.ON_VIOLATION as ON_VIOLA7_114_1_, incident0__1_.MATCH as MATCH114_1_, incident0__1_.VIOLATIONCOUNT as VIOLATIO9_114_1_, incident0__1_.ADDEDCOUNT as ADDEDCOUNT114_1_, incident0__1_.CHANGEDCOUNT as CHANGED11_114_1_, incident0__1_.REMOVEDCOUNT as REMOVED12_114_1_, incidentho1_.HOST_ID as HOST_ID0_, incidentho1_.HOSTNAME as HOSTNAME0_, incidentho1_.IPADDRESS as IPADDRESS0_ from RS_INCIDENT incident0_ left outer join RS_TW_INCDT incident0__1_ on incident0_.INCIDENT_ID=incident0__1_.INCIDENT_ID left outer join RS_INCDT_HOST incidentho1_ on incident0_.HOST_ID=incidentho1_.HOST_ID where incident0_.INCIDENT_ID=?
2004-10-14 13:36:15,931 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=22432.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,931 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=22432.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,931 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='22432.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:15,931 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=22432.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,931 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=22432.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,941 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='22432.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:15,941 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistStore] DEBUG - persistStore called (key=22432.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:15,941 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select removed0_.ID as ID__, removed0_.INCIDENT_ID as INCIDENT4___, removed0_.ID as ID0_, removed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT removed0_ where removed0_.INCIDENT_ID=? and removed0_.OBJECT_TYPE='REMOVED'
2004-10-14 13:36:15,991 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select changed0_.ID as ID__, changed0_.INCIDENT_ID as INCIDENT4___, changed0_.ID as ID0_, changed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT changed0_ where changed0_.INCIDENT_ID=? and changed0_.OBJECT_TYPE='CHANGED'
2004-10-14 13:36:16,041 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select added0_.ID as ID__, added0_.INCIDENT_ID as INCIDENT4___, added0_.ID as ID0_, added0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT added0_ where added0_.INCIDENT_ID=? and added0_.OBJECT_TYPE='ADDED'
2004-10-14 13:36:16,091 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select errors0_.error as error__, errors0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_ERRORS errors0_ where errors0_.INCIDENT_ID=?
2004-10-14 13:36:16,091 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select emailaddre0_.email as email__, emailaddre0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_EMAIL emailaddre0_ where emailaddre0_.INCIDENT_ID=?
2004-10-14 13:36:16,091 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=22434.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:16,091 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=22434.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:16,091 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='22434.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:16,091 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select incident0_.INCIDENT_ID as INCIDENT1_1_, case when incident0__1_.INCIDENT_ID is not null then 1 when incident0_.INCIDENT_ID is not null then 0 end as clazz_1_, incident0_.NAME as NAME113_1_, incident0_.TIMESTAMP as TIMESTAMP113_1_, incident0_.MOD_TIMESTAMP as MOD_TIME4_113_1_, incident0_.STATUS as STATUS113_1_, incident0_.HOST_ID as HOST_ID113_1_, incident0__1_.STARTPOINT as STARTPOINT114_1_, incident0__1_.TICKET_NO as TICKET_NO114_1_, incident0__1_.COMMENTS as COMMENTS114_1_, incident0__1_.CONTACT as CONTACT114_1_, incident0__1_.SEVERITY as SEVERITY114_1_, incident0__1_.ON_VIOLATION as ON_VIOLA7_114_1_, incident0__1_.MATCH as MATCH114_1_, incident0__1_.VIOLATIONCOUNT as VIOLATIO9_114_1_, incident0__1_.ADDEDCOUNT as ADDEDCOUNT114_1_, incident0__1_.CHANGEDCOUNT as CHANGED11_114_1_, incident0__1_.REMOVEDCOUNT as REMOVED12_114_1_, incidentho1_.HOST_ID as HOST_ID0_, incidentho1_.HOSTNAME as HOSTNAME0_, incidentho1_.IPADDRESS as IPADDRESS0_ from RS_INCIDENT incident0_ left outer join RS_TW_INCDT incident0__1_ on incident0_.INCIDENT_ID=incident0__1_.INCIDENT_ID left outer join RS_INCDT_HOST incidentho1_ on incident0_.HOST_ID=incidentho1_.HOST_ID where incident0_.INCIDENT_ID=?
2004-10-14 13:36:16,101 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=22434.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:16,101 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=22434.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:16,101 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='22434.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:16,101 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.get] DEBUG - get called (key=22434.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:16,111 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistRetrieve] DEBUG - persistRetrieve called (key=22434.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:16,111 [com.opensymphony.oscache.base.Cache.getCacheEntry] DEBUG - No cache entry exists for key='22434.com.waypoint.rs.incident.Incident', creating
2004-10-14 13:36:16,111 [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.persistStore] DEBUG - persistStore called (key=22434.com.waypoint.rs.incident.Incident)
2004-10-14 13:36:16,111 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select removed0_.ID as ID__, removed0_.INCIDENT_ID as INCIDENT4___, removed0_.ID as ID0_, removed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT removed0_ where removed0_.INCIDENT_ID=? and removed0_.OBJECT_TYPE='REMOVED'
2004-10-14 13:36:16,151 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select changed0_.ID as ID__, changed0_.INCIDENT_ID as INCIDENT4___, changed0_.ID as ID0_, changed0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT changed0_ where changed0_.INCIDENT_ID=? and changed0_.OBJECT_TYPE='CHANGED'
2004-10-14 13:36:16,211 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select added0_.ID as ID__, added0_.INCIDENT_ID as INCIDENT4___, added0_.ID as ID0_, added0_.NAME as NAME0_ from RS_TW_INCDT_OBJECT added0_ where added0_.INCIDENT_ID=? and added0_.OBJECT_TYPE='ADDED'
2004-10-14 13:36:16,261 [net.sf.hibernate.impl.BatcherImpl.getPreparedStatement] DEBUG - select errors0_.error as error__, errors0_.INCIDENT_ID as INCIDENT1___ from RS_TW_INCDT_ERRORS errors0_ where errors0_.INCIDENT_I

_________________
Thanks
Sameet


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 8 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.