List of supportsCatalogsInTableDefinitions() Examples

Examples of supportsCatalogsInTableDefinitions()

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

Examples of java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions()

        
        assertFalse(dmd.supportsCatalogsInDataManipulation());
        assertFalse(dmd.supportsCatalogsInIndexDefinitions());
        assertFalse(dmd.supportsCatalogsInPrivilegeDefinitions());
        assertFalse(dmd.supportsCatalogsInProcedureCalls());
        assertFalse(dmd.supportsCatalogsInTableDefinitions());
        
        assertTrue(dmd.supportsColumnAliasing());
        
        assertFalse(dmd.supportsConvert());
        // Simple check since convert is not supported.

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions()


    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.supportsCatalogsInTableDefinitions()

    assertEquals(System.getProperty("hive.version"), meta.getDatabaseProductVersion());
    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.supportsCatalogsInTableDefinitions()

        
        assertFalse(dmd.supportsCatalogsInDataManipulation());
        assertFalse(dmd.supportsCatalogsInIndexDefinitions());
        assertFalse(dmd.supportsCatalogsInPrivilegeDefinitions());
        assertFalse(dmd.supportsCatalogsInProcedureCalls());
        assertFalse(dmd.supportsCatalogsInTableDefinitions());
        
        assertTrue(dmd.supportsColumnAliasing());
        
        // Bug DERBY-462 should return false.
        assertTrue(dmd.supportsConvert());

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions()


    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.supportsCatalogsInTableDefinitions()


    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.supportsCatalogsInTableDefinitions()

  private static List<String> getPKColumnList(ISQLConnection sourceConn, ITableInfo ti) throws SQLException
  {
    ArrayList<String> pkColumns = new ArrayList<String>();
    DatabaseMetaData md = sourceConn.getConnection().getMetaData();
    ResultSet rs = null;
    if (md.supportsCatalogsInTableDefinitions())
    {
      rs = md.getPrimaryKeys(ti.getCatalogName(), null, ti.getSimpleName());
    } else if (md.supportsSchemasInTableDefinitions())
    {
      rs = md.getPrimaryKeys(null, ti.getSchemaName(), ti.getSimpleName());

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions()

  private static List<String> getPKColumnList(ISQLConnection sourceConn, ITableInfo ti) throws SQLException
  {
    ArrayList<String> pkColumns = new ArrayList<String>();
    DatabaseMetaData md = sourceConn.getConnection().getMetaData();
    ResultSet rs = null;
    if (md.supportsCatalogsInTableDefinitions())
    {
      rs = md.getPrimaryKeys(ti.getCatalogName(), null, ti.getSimpleName());
    }
    else if (md.supportsSchemasInTableDefinitions())
    {

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions()

        
        assertFalse(dmd.supportsCatalogsInDataManipulation());
        assertFalse(dmd.supportsCatalogsInIndexDefinitions());
        assertFalse(dmd.supportsCatalogsInPrivilegeDefinitions());
        assertFalse(dmd.supportsCatalogsInProcedureCalls());
        assertFalse(dmd.supportsCatalogsInTableDefinitions());
        
        assertTrue(dmd.supportsColumnAliasing());
        
        // Bug DERBY-462 should return false.
        assertTrue(dmd.supportsConvert());

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions()


    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());
  }

View Full Code Here

0 1 2 3

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.