<%
 		 try 
                    {
                    	
                    
                    	
                        Connection conn = Hibernate3Support.currentSession().connection();
                        
                        Statement stmt = conn.createStatement();
                        
                         for  ( int  i =  0 ; i <  1 ; i++)
                        
                            {
                            	
								ResultSet rs = stmt.executeQuery("select * from Rubriks");
								 while  (rs.next())
								{
									String s = rs.getString("RubName");
									
								}
								
								rs.close();
								
								
							 }
                                               
                           stmt.close();
                    }
                 catch  (Exception e)
                    {
                        e.printStackTrace();
                    }
   %>

<prop key="hibernate.c3p0.min_size"> 0 </prop>
				<prop key="hibernate.c3p0.max_size"> 1 </prop>
				<prop key="hibernate.c3p0.max_statements"> 0 </prop>

<prop key="hibernate.c3p0.min_size"> 0 </prop>
				<prop key="hibernate.c3p0.max_size"> 2 </prop>
				<prop key="hibernate.c3p0.timeout"> 5 </prop>
				<prop key="hibernate.c3p0.max_statements"> 0 </prop>

 try {
Session s = sessionFactory.openSession();
                        
                        Connection conn = s.connection();
                        
                        Statement stmt = conn.createStatement();
                        
                                                    	
								ResultSet rs = stmt.executeQuery("select * from Rubriks");
								 while  (rs.next())
								{
									String str = rs.getString("RubName");
									
								}
								
								rs.close();
								rs= null ;
								
							                                               
                           stmt.close();
                           stmt= null ;
                           s.close();
                           
                                               }
                 catch  (Exception e)
                    {
                        e.printStackTrace();
                    }

/*
 * Created on Nov 29, 2005
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
 package  test;

/**
 * @author alexey
 * 
 * TODO To change the template for this generated type comment go to Window -
 * Preferences - Java - Code Style - Code Templates
 */
 import  org.hibernate.*;
 import  org.hibernate.cfg.*;

 public   class  Hibernate3Support {

	 private   static   final  SessionFactory sessionFactory;
	 static  {
		 try  {
			// Create the SessionFactory

			Configuration cfg =  new  Configuration()

					.setProperty("hibernate.connection.driver_class",
							"com.mysql.jdbc.Driver")
					.setProperty(
							"hibernate.connection.url",
							"jdbc:mysql://localhost:3306/test?useUnicode=true&autoReconnect=true&characterEncoding=Cp1251")
					.setProperty("hibernate.connection.username", "test")
					.setProperty("hibernate.connection.password", "test")
					.setProperty("hibernate.c3p0.min_size", "0").setProperty(
							"hibernate.c3p0.max_size", "1").setProperty(
							"hibernate.c3p0.timeout", "5").setProperty(
							"hibernate.dialect",
							"org.hibernate.dialect.MySQLDialect");

			;

			sessionFactory = (SessionFactory) cfg.buildSessionFactory();
		}  catch  (Throwable ex) {

			 throw   new  ExceptionInInitializerError(ex);
		}
	}

	 public   static   final  ThreadLocal session =  new  ThreadLocal();

	 public   static  Session currentSession() {
		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;
	}

	 public   static   void  closeSession() {
		Session s = (Session) session.get();
		 if  (s !=  null )
			s.close();
		session.set( null );
	}

}

 /*
 * Created on May 24, 2006
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
 package  test;

 import  java.sql.Connection;
 import  java.sql.ResultSet;
 import  java.sql.SQLException;
 import  java.sql.Statement;
 import  java.util.Iterator;
 import  com.mchange.v2.c3p0.DataSources;

 import  javax.sql.DataSource;

 import  com.mchange.v2.c3p0.C3P0Registry;

/**
 * @author ALEXEY
 * 
 * TODO To change the template for this generated type comment go to Window -
 * Preferences - Java - Code Style - Code Templates
 */
 public   class  LeakTest {

	 static   final  String TABLE_NAME = "rubs";

	 public   static   void  main(String[] args)  throws  SQLException {

		 while  (true) {

			Connection conn = Hibernate3Support.currentSession().connection();

			Statement stmt = conn.createStatement();

			ResultSet rs = stmt.executeQuery("select * from " + TABLE_NAME);

			 while  (rs.next()) {

				String id = rs.getString( 1 );

			}

			rs.close();

			stmt.close();

			Hibernate3Support.closeSession();

		}

	}

}