Index: forgon-tools/src/main/java/com/forgon/tools/hibernate/ObjectDaoImpl.java
===================================================================
diff -u -r13855 -r14757
--- forgon-tools/src/main/java/com/forgon/tools/hibernate/ObjectDaoImpl.java	(.../ObjectDaoImpl.java)	(revision 13855)
+++ forgon-tools/src/main/java/com/forgon/tools/hibernate/ObjectDaoImpl.java	(.../ObjectDaoImpl.java)	(revision 14757)
@@ -383,7 +383,7 @@
 			sql = "";
 		}
 		List list = getHibernateTemplate().find(
-				"select count(*) from " + objectPOName + " as po " + sql);
+				"select count(*) from " + objectPOName + "  po " + sql);
 		int count = ((Long) list.get(0)).intValue();
 		return count;
 	}
@@ -669,13 +669,13 @@
 		}
 
 		Query query = session.createQuery("select po from "
-				+ objectPOName + " as po " + hql + orderby);
+				+ objectPOName + "  po " + hql + orderby);
 		return query;
 	}
 	
 	public List<Long> getLongProperties(String objectPOName,String propertyName,String sql){
 		List<Long> retList = null;
-		String finalSql = String.format("select po.%s from %s as po %s",propertyName, objectPOName,sql);
+		String finalSql = String.format("select po.%s from %s  po %s",propertyName, objectPOName,sql);
 		List myList = getHibernateTemplate().find(finalSql);
 		
 		if (myList != null && myList.size() > 0){