QueryResults results = oql.execute(Database.READONLY);

    while (results.hasMore())

    {

    }

    results.close();

    oql.close();

    QueryResults results = oql.execute(Database.READONLY);

    while (results.hasMore())

    {

    }

    results.close();

    oql.close();

  }

  public static TableCount getTableCount(String tableName) throws Exception

  {

   

    Database db = CastorDatabaseService.getDatabase();

        beginTransaction(db);

  }

  public static TableCount getTableCount(String tableName, String columnName) throws Exception

  {

   

    Database db = CastorDatabaseService.getDatabase();

        beginTransaction(db);

   

    QueryResults results = oql.execute(Database.READONLY);

    while (results.hasMore())

    {

    }

    /*

    String sql = "CALL SQL select count(*) from cmAccessRight ar where ar.interceptionPointId in (select interceptionPointId from cmInterceptionPoint where name like 'SiteNodeVersion.%') AND ar.parameters NOT IN (select siteNodeVersionId from cmSiteNodeVersion where siteNodeVersionId = ar.parameters) AS org.infoglue.cms.entities.management.TableCount";

    if(CmsPropertyHandler.getUseShortTableNames().equalsIgnoreCase("true"))

      sql = "CALL SQL select count(*) from cmAccessRight ar where ar.interceptionPointId in (select interceptionPointId from cmInterceptionPoint where name like 'SiteNodeVersion.%') AND ar.parameters NOT IN (select siNoVerId from cmSiNoVer where siNoVerId = ar.parameters) AS org.infoglue.cms.entities.management.TableCount";

   */

 

  public static TableCount getNumberOfUnusedAssets() throws Exception

  {

   

    Database db = CastorDatabaseService.getDatabase();

        beginTransaction(db);