-->
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.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users (Deutsch)

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 5 posts ] 
  Previous topic | Next topic 
Author Message
Semmerl
 Post subject: Bei jedem DB-Zugriff entsteht neuer Thread-->Warum?
PostPosted: Tue Apr 04, 2006 6:44 am 
Regular
Regular

Joined: Sat Sep 03, 2005 9:07 am
Posts: 87
Location: Graz, AUSTRIA
Ich habe Probleme mit der Anzahl an Threads die bei Datenbankzugriffen mit Hibernate entstehen. Ich verwende die HibernateUtil Klasse um eine Session zu öffnen und auch wieder zu schließen.
Öffnen du ich die Verbindung mit:
Code:
Session session = HibernateUtil.currentSession();
     Transaction tx = null;
      try {
         tx = session.beginTransaction();
                    ....


und schließen wieder so:

Code:
HibernateUtil.closeSession();


Das Problem ist nun, dass sich bei jedem Datenbankzugriff ein Thread öffnet, jedoch dieser nie wieder geschlossen wird und somit irgendwann der Tomcat Server mit einer OutofMemoryError Exception stirbt...

Mache ich irgendetwas falsch oder wieso entsteht bei jedem Datenbankzugriff ein neuer Thread.

Mein System: RedHat Enterprise, Tomcat 5.5.9, JRE 1.4.2_10


Hibernate version:
3.1.2

Anbei meine HibernateUtilklasse:
Code:
public class HibernateUtil {

   private static Logger logger = Logger.getLogger(HibernateUtil.class);

   private static final SessionFactory sessionFactory;
   
   
   /**
    * Anlegen einer Sessionfactory. Dabei wird das Hibernate.cfg.xml ausgelesen
    */
   static {
      try {
         // Create the SessionFactory
         sessionFactory = new Configuration().configure()
               .buildSessionFactory();
         
      } catch (Throwable ex) {
         logger.error("Initial SessionFactory creation failed.", ex);
         throw new ExceptionInInitializerError(ex);
      }
   }
   
   
   
   public static final ThreadLocal session = new ThreadLocal();

   /**
    * Öffnet eine neue Hibernate Session, falls noch nicht vorhanden
    *
    * @return Hibernate Session
    * @throws HibernateException
    */
   public static Session currentSession() throws HibernateException {
   
      
      Session s = (Session) session.get();
      // Open a new Session, if this Thread has none yet
      if (s == null) {
         s = sessionFactory.openSession();
         session.set(s);
      }
      return s;
   }
   

   /**
    * Schließen der Hibernate Session
    *
    * @throws HibernateException
    */
   public static void closeSession() throws HibernateException {
      Session s = (Session) session.get();
      session.set(null);
      if (s != null)
         s.close();
      

   }
}
Top
 Profile  
 
MikePloed
 Post subject:
PostPosted: Tue Apr 04, 2006 9:38 am 
Expert
Expert

Joined: Tue Dec 07, 2004 6:57 am
Posts: 285
Location: Nürnberg, Germany
Poste bitte mal ein Debug log. Damit hatte ich noch nie Probleme. Kann es u.u. sein, dass du die Transaktion nicht commitest?

_________________
Please don't forget to rate

Top
 Profile  
 
Semmerl
 Post subject:
PostPosted: Tue Apr 04, 2006 9:51 am 
Regular
Regular

Joined: Sat Sep 03, 2005 9:07 am
Posts: 87
Location: Graz, AUSTRIA
Doch, ich committe die Transaktionen immer...

Hier das DEbug log einer Abfrage...

Code:
2006-04-04 15:50:10,447 DEBUG [http-8080-Processor24] org.hibernate.impl.SessionImpl: opened session at timestamp: 4686473668390912
2006-04-04 15:50:10,447 DEBUG [http-8080-Processor24] org.hibernate.transaction.JDBCTransaction: begin
2006-04-04 15:50:10,447 DEBUG [http-8080-Processor24] org.hibernate.jdbc.ConnectionManager: opening JDBC connection
2006-04-04 15:50:10,447 DEBUG [http-8080-Processor24] org.hibernate.transaction.JDBCTransaction: current autocommit status: false
2006-04-04 15:50:10,447 DEBUG [http-8080-Processor24] org.hibernate.jdbc.JDBCContext: after transaction begin
2006-04-04 15:50:10,447 DEBUG [http-8080-Processor24] org.hibernate.engine.query.QueryPlanCache: located HQL query plan in cache (Select et.iId, et.userAcronym, et.insDate, et.messagetext, et.link, et.extern  from EtInfomessages et where et.insDate >=:datumneu and et.dauerhaft=0 order by et.insDate desc)
2006-04-04 15:50:10,447 DEBUG [http-8080-Processor24] org.hibernate.engine.query.QueryPlanCache: located HQL query plan in cache (Select et.iId, et.userAcronym, et.insDate, et.messagetext, et.link, et.extern  from EtInfomessages et where et.insDate >=:datumneu and et.dauerhaft=0 order by et.insDate desc)
2006-04-04 15:50:10,447 DEBUG [http-8080-Processor24] org.hibernate.engine.query.HQLQueryPlan: find: Select et.iId, et.userAcronym, et.insDate, et.messagetext, et.link, et.extern  from EtInfomessages et where et.insDate >=:datumneu and et.dauerhaft=0 order by et.insDate desc
2006-04-04 15:50:10,463 DEBUG [http-8080-Processor24] org.hibernate.engine.QueryParameters: named parameters: {datumneu=04 März 2006}
2006-04-04 15:50:10,463 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2006-04-04 15:50:10,463 DEBUG [http-8080-Processor24] org.hibernate.SQL: select etinfomess0_.I_ID as col_0_0_, etinfomess0_.USER_ACRONYM as col_1_0_, etinfomess0_.INS_DATE as col_2_0_, etinfomess0_.MESSAGETEXT as col_3_0_, etinfomess0_.LINK as col_4_0_, etinfomess0_.EXTERN as col_5_0_ from EDITOOLS.ET_INFOMESSAGES etinfomess0_ where etinfomess0_.INS_DATE>=? and etinfomess0_.DAUERHAFT=0 order by etinfomess0_.INS_DATE desc
2006-04-04 15:50:10,463 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: preparing statement
2006-04-04 15:50:10,463 DEBUG [http-8080-Processor24] org.hibernate.loader.hql.QueryLoader: bindNamedParameters() Sat Mar 04 15:50:10 CET 2006 -> datumneu [1]
2006-04-04 15:50:10,463 DEBUG [http-8080-Processor24] org.hibernate.type.DateType: binding '04 März 2006' to parameter: 1
2006-04-04 15:50:10,463 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to open ResultSet (open ResultSets: 0, globally: 0)
2006-04-04 15:50:10,463 DEBUG [http-8080-Processor24] org.hibernate.loader.Loader: processing result set
2006-04-04 15:50:10,463 DEBUG [http-8080-Processor24] org.hibernate.loader.Loader: done processing result set (0 rows)
2006-04-04 15:50:10,463 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to close ResultSet (open ResultSets: 1, globally: 1)
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: closing statement
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.engine.StatefulPersistenceContext: initializing non-lazy collections
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.engine.query.QueryPlanCache: located HQL query plan in cache (Select et.iId, et.userAcronym, et.insDate, et.messagetext, et.link, et.extern  from EtInfomessages et where et.dauerhaft=1 order by et.insDate desc)
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.engine.query.QueryPlanCache: located HQL query plan in cache (Select et.iId, et.userAcronym, et.insDate, et.messagetext, et.link, et.extern  from EtInfomessages et where et.dauerhaft=1 order by et.insDate desc)
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.engine.query.HQLQueryPlan: find: Select et.iId, et.userAcronym, et.insDate, et.messagetext, et.link, et.extern  from EtInfomessages et where et.dauerhaft=1 order by et.insDate desc
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.engine.QueryParameters: named parameters: {}
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.SQL: select etinfomess0_.I_ID as col_0_0_, etinfomess0_.USER_ACRONYM as col_1_0_, etinfomess0_.INS_DATE as col_2_0_, etinfomess0_.MESSAGETEXT as col_3_0_, etinfomess0_.LINK as col_4_0_, etinfomess0_.EXTERN as col_5_0_ from EDITOOLS.ET_INFOMESSAGES etinfomess0_ where etinfomess0_.DAUERHAFT=1 order by etinfomess0_.INS_DATE desc
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: preparing statement
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to open ResultSet (open ResultSets: 0, globally: 0)
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.loader.Loader: processing result set
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.loader.Loader: result set row: 0
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.loader.Loader: result row:
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.type.LongType: returning '7989' as column: col_0_0_
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.type.StringType: returning 'MITTERA' as column: col_1_0_
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.type.DateType: returning '07 März 2006' as column: col_2_0_
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.type.StringType: returning 'EDITOOL IN BETA PHASE' as column: col_3_0_
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.type.StringType: returning 'http://ilinux:8180/editool' as column: col_4_0_
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.type.LongType: returning '1' as column: col_5_0_
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.loader.Loader: done processing result set (1 rows)
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to close ResultSet (open ResultSets: 1, globally: 1)
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: closing statement
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.engine.StatefulPersistenceContext: initializing non-lazy collections
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.transaction.JDBCTransaction: commit
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.impl.SessionImpl: automatically flushing session
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.jdbc.JDBCContext: before transaction completion
2006-04-04 15:50:10,494 DEBUG [http-8080-Processor24] org.hibernate.impl.SessionImpl: before transaction completion
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.transaction.JDBCTransaction: committed JDBC Connection
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.jdbc.JDBCContext: after transaction completion
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.jdbc.ConnectionManager: aggressively releasing JDBC connection
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.jdbc.ConnectionManager: releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.impl.SessionImpl: after transaction completion
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.impl.SessionImpl: closing session
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.jdbc.ConnectionManager: connection already null in cleanup : no action
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.impl.SessionImpl: opened session at timestamp: 4686473668648960
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.transaction.JDBCTransaction: begin
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.jdbc.ConnectionManager: opening JDBC connection
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.transaction.JDBCTransaction: current autocommit status: false
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.jdbc.JDBCContext: after transaction begin
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.engine.query.QueryPlanCache: located HQL query plan in cache (Select et.iId, et.userAcronym, et.insDate, et.messagetext, et.link, et.extern  from EtInfomessages et where et.insDate >=:datumneu and et.dauerhaft=0 order by et.insDate desc)
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.engine.query.QueryPlanCache: located HQL query plan in cache (Select et.iId, et.userAcronym, et.insDate, et.messagetext, et.link, et.extern  from EtInfomessages et where et.insDate >=:datumneu and et.dauerhaft=0 order by et.insDate desc)
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.engine.query.HQLQueryPlan: find: Select et.iId, et.userAcronym, et.insDate, et.messagetext, et.link, et.extern  from EtInfomessages et where et.insDate >=:datumneu and et.dauerhaft=0 order by et.insDate desc
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.engine.QueryParameters: named parameters: {datumneu=04 März 2006}
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.SQL: select etinfomess0_.I_ID as col_0_0_, etinfomess0_.USER_ACRONYM as col_1_0_, etinfomess0_.INS_DATE as col_2_0_, etinfomess0_.MESSAGETEXT as col_3_0_, etinfomess0_.LINK as col_4_0_, etinfomess0_.EXTERN as col_5_0_ from EDITOOLS.ET_INFOMESSAGES etinfomess0_ where etinfomess0_.INS_DATE>=? and etinfomess0_.DAUERHAFT=0 order by etinfomess0_.INS_DATE desc
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: preparing statement
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.loader.hql.QueryLoader: bindNamedParameters() Sat Mar 04 15:50:10 CET 2006 -> datumneu [1]
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.type.DateType: binding '04 März 2006' to parameter: 1
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to open ResultSet (open ResultSets: 0, globally: 0)
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.loader.Loader: processing result set
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.loader.Loader: done processing result set (0 rows)
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to close ResultSet (open ResultSets: 1, globally: 1)
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: closing statement
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.engine.StatefulPersistenceContext: initializing non-lazy collections
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.engine.query.QueryPlanCache: located HQL query plan in cache (Select et.iId, et.userAcronym, et.insDate, et.messagetext, et.link, et.extern  from EtInfomessages et where et.dauerhaft=1 order by et.insDate desc)
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.engine.query.QueryPlanCache: located HQL query plan in cache (Select et.iId, et.userAcronym, et.insDate, et.messagetext, et.link, et.extern  from EtInfomessages et where et.dauerhaft=1 order by et.insDate desc)
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.engine.query.HQLQueryPlan: find: Select et.iId, et.userAcronym, et.insDate, et.messagetext, et.link, et.extern  from EtInfomessages et where et.dauerhaft=1 order by et.insDate desc
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.engine.QueryParameters: named parameters: {}
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.SQL: select etinfomess0_.I_ID as col_0_0_, etinfomess0_.USER_ACRONYM as col_1_0_, etinfomess0_.INS_DATE as col_2_0_, etinfomess0_.MESSAGETEXT as col_3_0_, etinfomess0_.LINK as col_4_0_, etinfomess0_.EXTERN as col_5_0_ from EDITOOLS.ET_INFOMESSAGES etinfomess0_ where etinfomess0_.DAUERHAFT=1 order by etinfomess0_.INS_DATE desc
2006-04-04 15:50:10,510 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: preparing statement
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to open ResultSet (open ResultSets: 0, globally: 0)
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.loader.Loader: processing result set
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.loader.Loader: result set row: 0
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.loader.Loader: result row:
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.type.LongType: returning '7989' as column: col_0_0_
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.type.StringType: returning 'MITTERA' as column: col_1_0_
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.type.DateType: returning '07 März 2006' as column: col_2_0_
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.type.StringType: returning 'EDITOOL IN BETA PHASE' as column: col_3_0_
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.type.StringType: returning 'http://ilinux:8180/editool' as column: col_4_0_
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.type.LongType: returning '1' as column: col_5_0_
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.loader.Loader: done processing result set (1 rows)
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to close ResultSet (open ResultSets: 1, globally: 1)
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: closing statement
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.engine.StatefulPersistenceContext: initializing non-lazy collections
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.transaction.JDBCTransaction: commit
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.impl.SessionImpl: automatically flushing session
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.jdbc.JDBCContext: before transaction completion
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.impl.SessionImpl: before transaction completion
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.transaction.JDBCTransaction: committed JDBC Connection
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.jdbc.JDBCContext: after transaction completion
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.jdbc.ConnectionManager: aggressively releasing JDBC connection
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.jdbc.ConnectionManager: releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.impl.SessionImpl: after transaction completion
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.impl.SessionImpl: closing session
2006-04-04 15:50:10,525 DEBUG [http-8080-Processor24] org.hibernate.jdbc.ConnectionManager: connection already null in cleanup : no action
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.impl.SessionImpl: opened session at timestamp: 4686473668775936
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.transaction.JDBCTransaction: begin
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.jdbc.ConnectionManager: opening JDBC connection
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.transaction.JDBCTransaction: current autocommit status: false
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.jdbc.JDBCContext: after transaction begin
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.engine.query.QueryPlanCache: located HQL query plan in cache (Select et.iId, et.userAcronym, et.insDate, et.messagetext, et.detailsmessagetext, et.link from EtInfomessages et where et.iId =:iId)
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.engine.query.QueryPlanCache: located HQL query plan in cache (Select et.iId, et.userAcronym, et.insDate, et.messagetext, et.detailsmessagetext, et.link from EtInfomessages et where et.iId =:iId)
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.engine.query.HQLQueryPlan: find: Select et.iId, et.userAcronym, et.insDate, et.messagetext, et.detailsmessagetext, et.link from EtInfomessages et where et.iId =:iId
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.engine.QueryParameters: named parameters: {iId=7989}
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.SQL: select etinfomess0_.I_ID as col_0_0_, etinfomess0_.USER_ACRONYM as col_1_0_, etinfomess0_.INS_DATE as col_2_0_, etinfomess0_.MESSAGETEXT as col_3_0_, etinfomess0_.DETAILSMESSAGETEXT as col_4_0_, etinfomess0_.LINK as col_5_0_ from EDITOOLS.ET_INFOMESSAGES etinfomess0_ where etinfomess0_.I_ID=?
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: preparing statement
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.loader.hql.QueryLoader: bindNamedParameters() 7989 -> iId [1]
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.type.LongType: binding '7989' to parameter: 1
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to open ResultSet (open ResultSets: 0, globally: 0)
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.loader.Loader: processing result set
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.loader.Loader: result set row: 0
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.loader.Loader: result row:
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.type.LongType: returning '7989' as column: col_0_0_
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.type.StringType: returning 'MITTERA' as column: col_1_0_
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.type.DateType: returning '07 März 2006' as column: col_2_0_
2006-04-04 15:50:10,541 DEBUG [http-8080-Processor24] org.hibernate.type.StringType: returning 'EDITOOL IN BETA PHASE' as column: col_3_0_
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.type.StringType: returning '<p>Das EDI Partner Tool befindet sich ab sofort in der Beta-Phase.</p><p>Bitte eifrig testen um alle m&ouml;glichen Bugs beseitigen zu k&ouml;nnen.</p><p>&nbsp;</p><p>Der Systemadministrator<br /> </p>' as column: col_4_0_
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.type.StringType: returning 'http://ilinux:8180/editool' as column: col_5_0_
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.loader.Loader: done processing result set (1 rows)
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to close ResultSet (open ResultSets: 1, globally: 1)
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.jdbc.AbstractBatcher: closing statement
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.engine.StatefulPersistenceContext: initializing non-lazy collections
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.transaction.JDBCTransaction: commit
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.impl.SessionImpl: automatically flushing session
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.jdbc.JDBCContext: before transaction completion
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.impl.SessionImpl: before transaction completion
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.transaction.JDBCTransaction: committed JDBC Connection
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.jdbc.JDBCContext: after transaction completion
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.jdbc.ConnectionManager: aggressively releasing JDBC connection
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.jdbc.ConnectionManager: releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.impl.SessionImpl: after transaction completion
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.impl.SessionImpl: closing session
2006-04-04 15:50:10,557 DEBUG [http-8080-Processor24] org.hibernate.jdbc.ConnectionManager: connection already null in cleanup : no action
[/quote]
Top
 Profile  
 
Semmerl
 Post subject:
PostPosted: Tue Apr 04, 2006 10:41 am 
Regular
Regular

Joined: Sat Sep 03, 2005 9:07 am
Posts: 87
Location: Graz, AUSTRIA
Problem gelöst, es war wirklich eine Abfrage, die ich nicht commitiert hatte und die aber in einem Listener vorhanden war und somit bei jedem Request aufgerufen wurde...
War ein Überbleibsel eines alten Codes und ich hab vergessen, dass rauszunehmen...
Danke für den Tipp!!!
Top
 Profile  
 
Semmerl
 Post subject:
PostPosted: Wed Apr 05, 2006 1:57 am 
Regular
Regular

Joined: Sat Sep 03, 2005 9:07 am
Posts: 87
Location: Graz, AUSTRIA
Problem besteht weiterhin... Hab mich gestern getäuscht!

Bei jedem Datenbankzugriff entsteht ein extra Thread am Tomcat Server... Langsam fang ich an zu verzweifeln...

Hat irgendwer noch einen Tipp für mich.

Thx!
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 5 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users (Deutsch)

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.