public   void  testCriteriaProjection()
            {
                Criteria c = Hibernate3Support.currentSession().createCriteria(Test. class );

                Projection sqlProj =  new  ProjectionTestImp1("count(distinct(this_.id))",  new  String[]{"this_.id"},  new  Type[] { Hibernate.INTEGER });
              
                c.setProjection(sqlProj);
                
                List l = c.list();

                 for  ( int  i =  0 ; i < l.size(); i++)
                    {
                        System.out.println(l.get(i));
                    }

            }

         class  ProjectionTestImp1  extends  SQLProjection
            {

                 public  ProjectionTestImp1(String sql, String groupBy, String[] columnAliases, Type[] types)
                    {
                         super (sql, groupBy, columnAliases, types);
                        // TODO Auto-generated constructor stub
                    }

                 public  ProjectionTestImp1(String sql, String[] columnAliases, Type[] types)
                    {
                         super (sql, columnAliases, types);
                        // TODO Auto-generated constructor stub
                    }
            }