Esempio n. 1
0
  /** Basic test of DatabaseMetaData functions that access system tables */
  public void testTwo() throws Exception {

    Connection conn = newConnection();
    int updateCount;

    try {
      TestUtil.testScript(conn, "testrun/hsqldb/TestSelf.txt");

      DatabaseMetaData dbmeta = conn.getMetaData();

      dbmeta.allProceduresAreCallable();
      dbmeta.getBestRowIdentifier(null, null, "T_1", DatabaseMetaData.bestRowTransaction, true);
      dbmeta.getCatalogs();
      dbmeta.getColumnPrivileges(null, "PUBLIC", "T_1", "%");
      dbmeta.getColumns("PUBLIC", "PUBLIC", "T_1", "%");
      dbmeta.getCrossReference(null, null, "T_1", null, null, "T_1");
      dbmeta.getExportedKeys(null, null, "T_1");
      dbmeta.getFunctionColumns(null, "%", "%", "%");
      dbmeta.getFunctions(null, "%", "%");
      dbmeta.getImportedKeys("PUBLIC", "PUBLIC", "T_1");
      dbmeta.getIndexInfo("PUBLIC", "PUBLIC", "T1", true, true);
      dbmeta.getPrimaryKeys("PUBLIC", "PUBLIC", "T_1");
      dbmeta.getProcedureColumns(null, null, "%", "%");
      dbmeta.getProcedures("PUBLIC", "%", "%");
      dbmeta.getSchemas(null, "#");
      dbmeta.getTablePrivileges(null, "%", "%");
      dbmeta.getUDTs(null, "%", "%", new int[] {Types.DISTINCT});

    } catch (Exception e) {
      assertTrue("unable to prepare or execute DDL", false);
    } finally {
      conn.close();
    }
  }
 public ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)
     throws SQLException {
   _conn.checkOpen();
   try {
     return DelegatingResultSet.wrapResultSet(
         _conn, _meta.getTablePrivileges(catalog, schemaPattern, tableNamePattern));
   } catch (SQLException e) {
     handleException(e);
     throw new AssertionError();
   }
 }
 @Test
 public void columnOrderOfgetTablePrivileges() throws SQLException {
   ResultSet rs = meta.getTablePrivileges(null, null, null);
   assertFalse(rs.next());
   ResultSetMetaData rsmeta = rs.getMetaData();
   assertEquals(rsmeta.getColumnCount(), 7);
   assertEquals(rsmeta.getColumnName(1), "TABLE_CAT");
   assertEquals(rsmeta.getColumnName(2), "TABLE_SCHEM");
   assertEquals(rsmeta.getColumnName(3), "TABLE_NAME");
   assertEquals(rsmeta.getColumnName(4), "GRANTOR");
   assertEquals(rsmeta.getColumnName(5), "GRANTEE");
   assertEquals(rsmeta.getColumnName(6), "PRIVILEGE");
   assertEquals(rsmeta.getColumnName(7), "IS_GRANTABLE");
 }
 public ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)
     throws SQLException {
   return throwExceptionDelegate.getTablePrivileges(catalog, schemaPattern, tableNamePattern);
 }
Esempio n. 5
0
  public void testOne() throws Exception {

    Connection conn = newConnection();
    PreparedStatement pstmt;
    int updateCount;

    try {
      pstmt = conn.prepareStatement("DROP TABLE t1 IF EXISTS");

      pstmt.executeUpdate();
      pstmt.close();

      pstmt =
          conn.prepareStatement(
              "CREATE TABLE t1 (cha CHARACTER, dec DECIMAL, doub DOUBLE, lon BIGINT, \"IN\" INTEGER, sma SMALLINT, tin TINYINT, "
                  + "dat DATE DEFAULT CURRENT_DATE, tim TIME DEFAULT CURRENT_TIME, timest TIMESTAMP DEFAULT CURRENT_TIMESTAMP );");
      updateCount = pstmt.executeUpdate();

      assertTrue("expected update count of zero", updateCount == 0);

      pstmt = conn.prepareStatement("CREATE INDEX t1 ON t1 (cha );");
      updateCount = pstmt.executeUpdate();
      pstmt = conn.prepareStatement("DROP TABLE t2 IF EXISTS");
      updateCount = pstmt.executeUpdate();
      pstmt =
          conn.prepareStatement(
              "CREATE TABLE t2 (cha CHARACTER, dec DECIMAL, doub DOUBLE, lon BIGINT, \"IN\" INTEGER, sma SMALLINT, tin TINYINT, "
                  + "dat DATE DEFAULT CURRENT_DATE, tim TIME DEFAULT CURRENT_TIME, timest TIMESTAMP DEFAULT CURRENT_TIMESTAMP );");
      updateCount = pstmt.executeUpdate();
      pstmt = conn.prepareStatement("CREATE INDEX t2 ON t2 (cha );");
      updateCount = pstmt.executeUpdate();

      DatabaseMetaData dbmd = conn.getMetaData();
      ResultSet rsp = dbmd.getTablePrivileges(null, null, "T1");

      while (rsp.next()) {
        System.out.println("Table: " + rsp.getString(3) + " priv: " + rsp.getString(6));
      }

      rsp = dbmd.getIndexInfo(null, null, "T1", false, false);

      while (rsp.next()) {
        System.out.println("Table: " + rsp.getString(3) + " IndexName: " + rsp.getString(6));
      }

      rsp = dbmd.getIndexInfo(null, null, "T2", false, false);

      while (rsp.next()) {
        System.out.println("Table: " + rsp.getString(3) + " IndexName: " + rsp.getString(6));
      }

      pstmt = conn.prepareStatement("DROP INDEX t2;");
      updateCount = pstmt.executeUpdate();
      rsp = dbmd.getIndexInfo(null, null, "T2", false, false);

      assertTrue("expected getIndexInfo returns empty resultset", rsp.next() == false);

      ResultSet rs = dbmd.getTables(null, null, "T1", new String[] {"TABLE"});
      ArrayList tablesarr = new ArrayList();
      int i;

      for (i = 0; rs.next(); i++) {
        String tempstr = rs.getString("TABLE_NAME").trim().toLowerCase();

        tablesarr.add(tempstr);
      }

      rs.close();
      assertTrue("expected table t1 count of 1", i == 1);

      Iterator it = tablesarr.iterator();

      for (; it.hasNext(); ) {

        // create new ArrayList and HashMap for the table
        String tablename = ((String) it.next()).trim();
        List collist = new ArrayList(30);

        rs = dbmd.getColumns(null, null, tablename.toUpperCase(), null);

        for (i = 0; rs.next(); i++) {
          collist.add(rs.getString("COLUMN_NAME").trim().toLowerCase());
        }

        rs.close();
      }

      pstmt = conn.prepareStatement("DROP TABLE t_1 IF EXISTS");

      pstmt.executeUpdate();
      pstmt.close();

      pstmt =
          conn.prepareStatement(
              "CREATE TABLE t_1 (cha CHARACTER(10), deci DECIMAL(10,2), doub DOUBLE, lon BIGINT, \"IN\" INTEGER, sma SMALLINT, tin TINYINT, "
                  + "dat DATE DEFAULT CURRENT_DATE, tim TIME DEFAULT CURRENT_TIME, timest TIMESTAMP DEFAULT CURRENT_TIMESTAMP, bool BOOLEAN );");
      updateCount = pstmt.executeUpdate();

      assertTrue("expected update count of zero", updateCount == 0);

      rs = dbmd.getTables(null, null, "T\\_1", new String[] {"TABLE"});

      for (i = 0; rs.next(); i++) {
        String tempstr = rs.getString("TABLE_NAME").trim().toLowerCase();

        tablesarr.add(tempstr);
      }

      rs.close();
      assertTrue("expected table t_1 count of 1", i == 1);

      // test various methods
      dbmd.getPrimaryKeys(null, null, "T_1");
      dbmd.getImportedKeys(null, null, "T_1");
      dbmd.getCrossReference(null, null, "T_1", null, null, "T_1");

      // test ResultSetMetaData
      pstmt = conn.prepareStatement("INSERT INTO T_1 (cha, deci, doub) VALUES ('name', 10.23, 0)");

      pstmt.executeUpdate();
      pstmt.close();

      pstmt = conn.prepareStatement("SELECT * FROM T_1");
      rs = pstmt.executeQuery();

      ResultSetMetaData md = rs.getMetaData();
      int x = md.getColumnDisplaySize(1);
      int y = md.getColumnDisplaySize(2);
      int b = md.getPrecision(2);
      int c = md.getScale(1);
      int d = md.getScale(2);
      String e = md.getColumnClassName(10);
      boolean testresult =
          (x == 10)
              && (y == 12)
              && (b == 10)
              && (c == 0)
              && (d == 2)
              && e.equals("java.sql.Timestamp");

      assertTrue("wrong result metadata", testresult);

      e = md.getColumnClassName(11);
      testresult = e.equals("java.lang.Boolean");

      assertTrue("wrong result metadata", testresult);
      pstmt.close();

      //
    } catch (Exception e) {
      assertTrue("unable to prepare or execute DDL", false);
    } finally {
      conn.close();
    }
  }