PreparedStatement ps = null;
ResultSet rs = null;
SessionImpl session = null;
try{
session = ((SessionImpl)getEntityManager().getDelegate());
conn = session.connection();
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()){
return rs.getLong(1);
}