List of supportsSchemasInTableDefinitions() Examples

Examples of supportsSchemasInTableDefinitions()

java.sql.DatabaseMetaData.supportsSchemasInTableDefinitions()
Determine if a schema name can be used in a table definition statement. @return true if a schema name can be used in a tabledefinition otherwise false. @throws SQLException a database error occurred
net.sourceforge.squirrel_sql.fw.sql.ISQLDatabaseMetaData.supportsSchemasInTableDefinitions()
Retrieves whether a schema name can be used in a table definition statement. Cached on first call. @return true if a schema name can be used in a tabledefinition statement. @throws SQLException Thrown if an SQL error occurs.
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.supportsSchemasInTableDefinitions()
@see net.sourceforge.squirrel_sql.fw.sql.ISQLDatabaseMetaData#supportsSchemasInTableDefinitions()
org.jpox.store.rdbms.adapter.RDBMSAdapter.supportsSchemasInTableDefinitions()
Whether this datastore supports the use of the schema name in SQL table definitions (DDL). @return whether we can use the schema name in DDL

Examples of java.sql.DatabaseMetaData.supportsSchemasInTableDefinitions()

        assertTrue(dmd.supportsSavepoints());
        assertTrue(dmd.supportsSchemasInDataManipulation());
        assertTrue(dmd.supportsSchemasInIndexDefinitions());
        assertTrue(dmd.supportsSchemasInPrivilegeDefinitions());
        assertTrue(dmd.supportsSchemasInProcedureCalls());
        assertTrue(dmd.supportsSchemasInTableDefinitions());
        assertTrue(dmd.supportsSelectForUpdate());
        
        assertFalse(dmd.supportsStatementPooling());
        assertTrue(dmd.supportsStoredProcedures());
        assertTrue(dmd.supportsSubqueriesInComparisons());

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsSchemasInTableDefinitions()

    assertEquals("Hive", meta.getDatabaseProductName());
    assertEquals("1", meta.getDatabaseProductVersion());
    assertEquals(DatabaseMetaData.sqlStateSQL99, meta.getSQLStateType());
    assertNull(meta.getProcedures(null, null, null));
    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertFalse(meta.supportsSchemasInTableDefinitions());
    assertFalse(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());
  }

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsSchemasInTableDefinitions()

    assertTrue("verifying hive version pattern. got " + meta.getDatabaseProductVersion(),
        Pattern.matches("\\d+\\.\\d+\\.\\d+.*", meta.getDatabaseProductVersion()) );


    assertEquals(DatabaseMetaData.sqlStateSQL99, meta.getSQLStateType());
    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertFalse(meta.supportsSchemasInTableDefinitions());
    assertFalse(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());
  }

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsSchemasInTableDefinitions()

        assertTrue(dmd.supportsSavepoints());
        assertTrue(dmd.supportsSchemasInDataManipulation());
        assertTrue(dmd.supportsSchemasInIndexDefinitions());
        assertTrue(dmd.supportsSchemasInPrivilegeDefinitions());
        assertTrue(dmd.supportsSchemasInProcedureCalls());
        assertTrue(dmd.supportsSchemasInTableDefinitions());
        assertTrue(dmd.supportsSelectForUpdate());
        
        assertFalse(dmd.supportsStatementPooling());
        assertTrue(dmd.supportsStoredProcedures());
        assertTrue(dmd.supportsSubqueriesInComparisons());

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsSchemasInTableDefinitions()

      SequenceProperties sequence1 = mock(SequenceProperties.class);
      SequenceProperties sequence2 = mock(SequenceProperties.class);
      DatabaseMetaData metaData = mock(DatabaseMetaData.class);
      ResultSet resultSet = mock(ResultSet.class);
      
      when(metaData.supportsSchemasInTableDefinitions()).thenReturn(true);
      when(metaData.supportsSchemasInDataManipulation()).thenReturn(true);
      when(metaData.getTables(eq(""), eq((String) null), eq("%"), aryEq(new String[] { "SEQUENCE" }))).thenReturn(resultSet);
      when(resultSet.next()).thenReturn(true).thenReturn(true).thenReturn(false);
      when(resultSet.getString("TABLE_SCHEM")).thenReturn("schema1").thenReturn("schema2");
      when(resultSet.getString("TABLE_NAME")).thenReturn("sequence1").thenReturn("sequence2");

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsSchemasInTableDefinitions()

    assertEquals("Hive", meta.getDatabaseProductName());
    assertEquals("1", meta.getDatabaseProductVersion());
    assertEquals(DatabaseMetaData.sqlStateSQL99, meta.getSQLStateType());
    assertNull(meta.getProcedures(null, null, null));
    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertFalse(meta.supportsSchemasInTableDefinitions());
    assertFalse(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());
  }

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsSchemasInTableDefinitions()

    assertEquals("Hive", meta.getDatabaseProductName());
    assertEquals("0", meta.getDatabaseProductVersion());
    assertEquals(DatabaseMetaData.sqlStateSQL99, meta.getSQLStateType());
    assertNull(meta.getProcedures(null, null, null));
    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertFalse(meta.supportsSchemasInTableDefinitions());
    assertFalse(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());
  }

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsSchemasInTableDefinitions()

      SequenceProperties sequence1 = mock(SequenceProperties.class);
      SequenceProperties sequence2 = mock(SequenceProperties.class);
      DatabaseMetaData metaData = mock(DatabaseMetaData.class);
      ResultSet resultSet = mock(ResultSet.class);
      
      when(metaData.supportsSchemasInTableDefinitions()).thenReturn(true);
      when(metaData.supportsSchemasInDataManipulation()).thenReturn(true);
      when(metaData.getTables(eq(""), eq((String) null), eq("%"), aryEq(new String[] { "SEQUENCE" }))).thenReturn(resultSet);
      when(resultSet.next()).thenReturn(true).thenReturn(true).thenReturn(false);
      when(resultSet.getString("TABLE_SCHEM")).thenReturn("schema1").thenReturn("schema2");
      when(resultSet.getString("TABLE_NAME")).thenReturn("sequence1").thenReturn("sequence2");

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsSchemasInTableDefinitions()

      String schema = null;
      try
      {
        final DatabaseMetaData data = conn.getMetaData();
        final boolean isHsql = ("HSQL Database Engine".equals(data.getDatabaseProductName()));
        if (data.supportsSchemasInTableDefinitions())
        {
          final LinkedMap schemas = new LinkedMap();
          final ResultSet rs = data.getSchemas();
          while (rs.next())
          {

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsSchemasInTableDefinitions()

            if (Debug.infoOn()) Debug.logInfo("Getting Column Info From Database", module);


            Map<String, Map<String, ColumnCheckInfo>> colInfo = FastMap.newInstance();
            String lookupSchemaName = null;
            try {
                if (dbData.supportsSchemasInTableDefinitions()) {
                    if (this.datasourceInfo.schemaName != null && this.datasourceInfo.schemaName.length() > 0) {
                        lookupSchemaName = this.datasourceInfo.schemaName;
                    } else {
                        lookupSchemaName = dbData.getUserName();
                    }

View Full Code Here

0 1 2 3 4 5

TOP

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.