Package com.intersys.objects

Examples of com.intersys.objects.CacheQuery

36
37
38
39
40
41
42
43
44
45
46
47
         Database cacDb =  (JBindDatabase) CacheDatabase.getDatabase(_session.getSQLConnection().getConnection());
         StringBuffer script = new StringBuffer();

         for (int i = 0; i < selectedViews.length; i++)
         {
            CacheQuery qry = new CacheQuery(cacDb, "%Library.SQLCatalog", "SQLViewInfo");
            ResultSet viewInfo = qry.execute(selectedViews[i]);

            viewInfo.next();
            if (selectedViews[i].toLowerCase().startsWith(PREFIX_SQLUSER.toLowerCase()))
            {
               script.append("CREATE VIEW ").append(selectedViews[i].substring(PREFIX_SQLUSER.length())).append(" AS\n");
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
44
      try
      {
         String curServerName = getUrlBegin(_session.getSQLConnection().getConnection().getMetaData().getURL());

         Database conn = (JBindDatabase) CacheDatabase.getDatabase(_session.getSQLConnection().getConnection());
         CacheQuery qry = new CacheQuery(conn, "%Library.RoutineMgr", "NamespaceList");
         ResultSet resNamespaces = qry.execute();

         Hashtable aliasesByNamespaces = new Hashtable();
         while (resNamespaces.next())
         {
            aliasesByNamespaces.put(resNamespaces.getString(1).toUpperCase(), "");
View Full Code Here
TOP

Related Classes of com.intersys.objects.CacheQuery

  • de.ixdb.squirrel_sql.plugins.cache.ScriptViewCommand
  • de.ixdb.squirrel_sql.plugins.cache.ShowNamespacesCommand
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.